Clarke Quay Redevelopment - Singapore
Clarke Quay Redevelopment - Singapore

Clarke Quay Redevelopment - Singapore

Entry in the LSAA 2007 Design Awards (Cat 4, 4007)  "Large Fabric Structures"

Entrant: Tensys

Location: Clarke Quay Redevelopment - Singapore   Client: Capital and Commercial Ltd
Architect: SMC Alsops & RSP Architects   Structural Engineer: Tensys
Specialist Consultant(s): Arup (Environmental)   Builder: Kajima Overseas Asia Pte Ltd
Fabricator(s): Skyspan (Asia) Pvt Ltd – Riverside/Bluebell 
canopies HIghtex GmbH – Street/Angel Canopies

Application and Function:

More than $50 million was spent upgrading the outdoor precinct to increase the shade and add to the comfort of visitors.

The Angel Structures are made from high performance thermoplastic film (ETFE).  It is the first time this material has been used on such a large scale in Asia.

Around the river’s edge, striking bluebell canopies over lilypads revitalize the area, helping to create a new trend in outdoor dining and entertainment.

LSAADA2007Cat4369
LSAADA2007Cat4368
LSAADA2007Cat4367
LSAADA2007Cat4366
LSAADA2007Cat4365
LSAADA2007Cat4364
LSAADA2007Cat4363
LSAADA2007Cat4362
LSAADA2007Cat4361
LSAADA2007Cat4359
LSAADA2007Cat4360
LSAADA2007Cat4357
LSAADA2007Cat4358
LSAADA2007Cat4356
LSAADA2007Cat4355
LSAADA2007Cat4393
LSAADA2007Cat4392
LSAADA2007Cat4391
LSAADA2007Cat4390
LSAADA2007Cat4388
LSAADA2007Cat4389
LSAADA2007Cat4386
LSAADA2007Cat4387
LSAADA2007Cat4384
LSAADA2007Cat4385
LSAADA2007Cat4382
LSAADA2007Cat4383
LSAADA2007Cat4380
LSAADA2007Cat4381
LSAADA2007Cat4379
LSAADA2007Cat4378
LSAADA2007Cat4377
LSAADA2007Cat4376
LSAADA2007Cat4374
LSAADA2007Cat4375
LSAADA2007Cat4373
LSAADA2007Cat4372
LSAADA2007Cat4371
LSAADA2007Cat4370

Description, Construction and Maintenance

SMC Alsop of UK were engaged by Capitaland to create a new Singaporean landmark with the redevelopment of Clarke Quay in Singapore.  Local Singaporean architectural firm RSP Architects worked as the local documentation and project architect.

Clarke Quay is a riverside neighbourhood composed of 100 year old Chinese dockside shop fronts. The area has been redeveloped by Capitaland as a major tourist precinct with cafes, restaurants and nightclubs.

Along the Riverside is a strip of outdoor dining areas with Riverside Canopies. The dining areas take the form of Lilypads or raised seating areas covered with Bluebells which take the form of modular fabric canopies seemingly hanging from curved steel stems. There are covered links back to the shopfronts which can be raised drawbridge style to allow clearance for emergency vehicles along the riverfront.

The river course takes a right angle bend at Clarke Quay and so there are two streets running away from the river that meet at a crossroad in the middle of the district. Along these two streets and at the central plaza junction Alsop planned to have some tall Angel like structures with torsos standing in the streets and wings forming a canopy overhanging the street side buildings. The canopies are clad with ETFE pillow structures in the central regions and with single layer ETFE at the edges.

Tensys Engineers have assisted specialist contractors Rightech and Hightex with concept realization and structural design works for the Riverside and Street Canopies respectively at Clarke Quay.

Riverside/Bluebell Canopies

Singaporean specialist contractor Rightech was appointed to undertake these works. Tensys were appointed as specialist consultants to design these structures.

The Bluebells are dome shape structures that are fabricated with an exterior steel skeleton frame (a series of hoops and ribs). The frames are clad with tensioned PTFE glass fabric that is tensioned and attached to the interior of the frame. There are two different modules; a 4m and a 5m diameter dome that are seemingly suspended from curved steel masts.

The structures are challengingly intricate for PTFE structures with great accuracy required in detailing, patterning and fabrication.

The irregular interstices between the Bluebells are filled with a tensioned PTFE glass fabric panel ribbons that flow over arches linking the Bluebell frames.  The ribbons also flow around trees growing up between Bluebells.

Again these structures are particularly challenging for PTFE structures also requiring very accurate control of setout and installation of Bluebells relative to each other.

The ribbon infills drain into gutters hidden at the perimeter of the Bluebell structures which then drain discretely into downpipes with the stem columns.

Providing weatherproof coverage from the Shopfront facades to the Riverside Canopies are a series of Link structures.

The Links structures are shallow PTFE cone structures with catenary cable edges with external steel frames attached to slab level at the facades (slab levels vary from one building to the next). The structures  cantilever over the quayside street and overhang the Riverside Canopies. The Link structures can be raised by a retractable arm with the canopy pivoting at the building face to allow clearance for transit of emergency vehicles.

Tensys developed the architect’s concepts, bringing this interesting and very detailed group of interlinked structures to reality.

Street/Angel Canopies

These structures are the first use of ETFE in Asia (especially Singapore) and so there was much work required to satisfy regulatory authorities for it use on this project. Hightex and Tensys worked closely with the architects to get the concepts approved.

Specialist German international contractor Hightex were awarded the contract prior to selection of the main contractor and were novated to undertake the works. Tensys provided much technical and administrative support to help Hightex win this project.

Tensys also worked closely with the architect to develop a suitable rational geometry and structural system to support the canopy.

The structural system is a series of spiral truss columns that zigzag from side to side along each of the four legs along streets leading to the central crossroad area. The zigzag helps to provide some stability and also decreases the uniformity that the architect was trying to avoid.

At the head of each truss column is a series of twelve radial arms that crank in elevation and overhang the shopfront buildings along the sides of the streets. The arms are stayed with tension rods both above and below.

At the central cross road area there are four tall spiral truss columns interlinked with rod stayed radial arms that also crank and cantilever over the street canopies and corner shop front buildings.

Each of the four street canopies and central canopy are structurally independent of each other.

Each spiral truss column is capped with a large polygonal ETFE pillow and each of the radial arm frames are clad with ETFE pillow structures. The ETFE has an intricate organic frit pattern printed on its surface to provide some shading.

At the ends of each radial arm, the arm cranks down to provide some weather protection as the structures cantilever over underlying shop fronts. The cranked regions are clad with tensioned single layer ETFE skins.

There was detailed study of rain shadow patterns the ETFE pillow structures drain into box gutters at the head of each truss and thence into downpipes that are hidden inside structural members. A siphonic drainage system was adopted to minimise downpipe size.

Costs

Overall development of Clarke Quay cost SGD50 million.  The projects for riverside/bluebell canopies and street/angel canopies cost SGD$12 million.

 

 


Settings27.603MBMemory Usage276msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.1
PHP Version8.2.28
Identityguest
Response200
Templateflex
Database
Server
mysql
Version
10.6.22-MariaDB-log
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:61 [ "USER" => "lsaa" "HOME" => "/home/lsaa" "SCRIPT_NAME" => "/index.php" "REQUEST_UR...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1749917592 "last" => 1749917592...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.63MB) (22.07ms)
  • afterInitialise (7.77MB) (73.18ms)
  • afterRoute (1.15MB) (13.84ms)
  • beforeRenderComponent com_content (1.11MB) (20.24ms)
  • Before Access::preloadComponents (all components) (419.96KB) (3.48ms)
  • After Access::preloadComponents (all components) (118.8KB) (531μs)
  • Before Access::preloadPermissions (com_content) (1.73KB) (19μs)
  • After Access::preloadPermissions (com_content) (621.98KB) (1.01ms)
  • Before Access::getAssetRules (id:177 name:com_content.article.96) (18.65KB) (54μs)
  • After Access::getAssetRules (id:177 name:com_content.article.96) (105.3KB) (318μs)
  • afterRenderComponent com_content (5.7MB) (54.1ms)
  • afterDispatch (14.72KB) (606μs)
  • beforeRenderRawModule mod_menu (Main Menu - Off Canvas) (2.31MB) (30.55ms)
  • afterRenderRawModule mod_menu (Main Menu - Off Canvas) (203.48KB) (10.94ms)
  • beforeRenderModule mod_menu (Main Menu - Off Canvas) (720B) (12μs)
  • afterRenderModule mod_menu (Main Menu - Off Canvas) (23.55KB) (431μs)
  • beforeRenderRawModule mod_menu (PK_Footer_Menu) (632B) (81μs)
  • afterRenderRawModule mod_menu (PK_Footer_Menu) (9.23KB) (7.6ms)
  • beforeRenderModule mod_menu (PK_Footer_Menu) (720B) (11μs)
  • afterRenderModule mod_menu (PK_Footer_Menu) (10.72KB) (168μs)
  • beforeRenderRawModule mod_custom (LSAA_Logo_Only) (2.24KB) (64μs)
  • afterRenderRawModule mod_custom (LSAA_Logo_Only) (14.03KB) (580μs)
  • beforeRenderModule mod_custom (LSAA_Logo_Only) (720B) (8μs)
  • afterRenderModule mod_custom (LSAA_Logo_Only) (2.73KB) (167μs)
  • beforeRenderRawModule mod_articles_popular (Popular Articles) (1.34KB) (53μs)
  • afterRenderRawModule mod_articles_popular (Popular Articles) (268.97KB) (6.51ms)
  • beforeRenderModule mod_articles_popular (Popular Articles) (720B) (10μs)
  • afterRenderModule mod_articles_popular (Popular Articles) (5.99KB) (209μs)
  • beforeRenderRawModule mod_articles_latest (Latest Articles) (2.74KB) (63μs)
  • afterRenderRawModule mod_articles_latest (Latest Articles) (77.7KB) (4.32ms)
  • beforeRenderModule mod_articles_latest (Latest Articles) (720B) (9μs)
  • afterRenderModule mod_articles_latest (Latest Articles) (6.22KB) (199μs)
  • beforeRenderRawModule mod_articles_latest (Recent Projects) (424B) (63μs)
  • afterRenderRawModule mod_articles_latest (Recent Projects) (68.6KB) (3.68ms)
  • beforeRenderModule mod_articles_latest (Recent Projects) (720B) (9μs)
  • afterRenderModule mod_articles_latest (Recent Projects) (6.22KB) (191μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (24B) (112μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (29.71KB) (1.15ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (7μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.13KB) (156μs)
  • afterRender (1.09MB) (18.65ms)
  • 1 x afterInitialise (7.77MB) (26.49%)
    73.18ms
    1 x afterRenderComponent com_content (5.7MB) (19.59%)
    54.10ms
    1 x beforeRenderRawModule mod_menu (Main Menu - Off Canvas) (2.31MB) (11.06%)
    30.55ms
    1 x afterLoad (3.63MB) (7.99%)
    22.07ms
    1 x beforeRenderComponent com_content (1.11MB) (7.33%)
    20.24ms
    1 x afterRender (1.09MB) (6.75%)
    18.65ms
    1 x afterRoute (1.15MB) (5.01%)
    13.84ms
    1 x afterRenderRawModule mod_menu (Main Menu - Off Canvas) (203.48KB) (3.96%)
    10.94ms
    1 x afterRenderRawModule mod_menu (PK_Footer_Menu) (9.23KB) (2.75%)
    7.60ms
    1 x afterRenderRawModule mod_articles_popular (Popular Articles) (268.97KB) (2.36%)
    6.51ms
    1 x afterRenderRawModule mod_articles_latest (Latest Articles) (77.7KB) (1.56%)
    4.32ms
    1 x afterRenderRawModule mod_articles_latest (Recent Projects) (68.6KB) (1.33%)
    3.68ms
    1 x Before Access::preloadComponents (all components) (419.96KB) (1.26%)
    3.48ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (29.71KB) (0.42%)
    1.15ms
    1 x After Access::preloadPermissions (com_content) (621.98KB) (0.37%)
    1.01ms
    1 x afterDispatch (14.72KB) (0.22%)
    606μs
    1 x afterRenderRawModule mod_custom (LSAA_Logo_Only) (14.03KB) (0.21%)
    580μs
    1 x After Access::preloadComponents (all components) (118.8KB) (0.19%)
    531μs
    1 x afterRenderModule mod_menu (Main Menu - Off Canvas) (23.55KB) (0.16%)
    431μs
    1 x After Access::getAssetRules (id:177 name:com_content.article.96) (105.3KB) (0.12%)
    318μs
    1 x afterRenderModule mod_articles_popular (Popular Articles) (5.99KB) (0.08%)
    209μs
    1 x afterRenderModule mod_articles_latest (Latest Articles) (6.22KB) (0.07%)
    199μs
    1 x afterRenderModule mod_articles_latest (Recent Projects) (6.22KB) (0.07%)
    191μs
    1 x afterRenderModule mod_menu (PK_Footer_Menu) (10.72KB) (0.06%)
    168μs
    1 x afterRenderModule mod_custom (LSAA_Logo_Only) (2.73KB) (0.06%)
    167μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.13KB) (0.06%)
    156μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (24B) (0.04%)
    112μs
    1 x beforeRenderRawModule mod_menu (PK_Footer_Menu) (632B) (0.03%)
    81μs
    1 x beforeRenderRawModule mod_custom (LSAA_Logo_Only) (2.24KB) (0.02%)
    64μs
    1 x beforeRenderRawModule mod_articles_latest (Latest Articles) (2.74KB) (0.02%)
    63μs
    1 x beforeRenderRawModule mod_articles_latest (Recent Projects) (424B) (0.02%)
    63μs
    1 x Before Access::getAssetRules (id:177 name:com_content.article.96) (18.65KB) (0.02%)
    54μs
    1 x beforeRenderRawModule mod_articles_popular (Popular Articles) (1.34KB) (0.02%)
    53μs
    1 x Before Access::preloadPermissions (com_content) (1.73KB) (0.01%)
    19μs
    1 x beforeRenderModule mod_menu (Main Menu - Off Canvas) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_menu (PK_Footer_Menu) (720B) (0%)
    11μs
    1 x beforeRenderModule mod_articles_popular (Popular Articles) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_articles_latest (Recent Projects) (720B) (0%)
    9μ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_breadcrumbs (Breadcrumbs) (704B) (0%)
    7μs
66 statements were executed, 24 of which were duplicates, 42 unique30.85ms664.8KB
  • SELECT @@SESSION.sql_mode;72μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `evapj_session` WHERE `session_id` = ?552μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `evapj_session` WHERE `session_id` = :session_id LIMIT 1154μ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)2.06ms944BParams/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` = 1118μs57.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `evapj_viewlevels`44μ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` = :guest73μ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`79μs4.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `template` FROM `evapj_template_styles` WHERE `client_id` = 0 AND `home` = 194μ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.19ms180.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`670μs3.88KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `evapj_content` WHERE `id` = :id174μs1.31KBParams/components/com_content/src/Service/Router.php:289Copy
  • SELECT * FROM `evapj_languages` WHERE `published` = 1 ORDER BY `ordering` ASC8.88ms1.59KB/libraries/src/Language/LanguageHelper.php:179Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `evapj_template_styles` AS `s` LEFT JOIN `evapj_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1120μs16.89KB/administrator/components/com_templates/src/Model/StyleModel.php:718Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `evapj_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44)133μ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` = 0198μs81.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `evapj_content`464μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `evapj_content` SET `hits` = (`hits` + 1) WHERE `id` = '96'1.1ms48B/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)460μs22.13KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `evapj_categories` AS `s` INNER JOIN `evapj_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`134μ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)719μ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`202μ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 ASC887μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT id FROM evapj_categories as c WHERE c.parent_id = 167296μs520B/components/com_droppics/models/frontcategories.php:143Copy
  • SELECT id FROM evapj_categories as c WHERE c.parent_id = 16734μs0B/components/com_droppics/models/frontcategories.php:144Copy
  • SELECT parent_id FROM evapj_categories as c WHERE c.id = 167119μs536B/components/com_droppics/models/frontcategories.php:156Copy
  • SELECT parent_id FROM evapj_categories as c WHERE c.id = 16737μs0B/components/com_droppics/models/frontcategories.php:157Copy
  • SELECT parent_id FROM evapj_categories as c WHERE c.id = 164115μs536B/components/com_droppics/models/frontcategories.php:156Copy
  • SELECT parent_id FROM evapj_categories as c WHERE c.id = 16430μs0B/components/com_droppics/models/frontcategories.php:157Copy
  • SELECT theme FROM evapj_droppics WHERE id='167'132μs536B/administrator/components/com_droppics/models/gallery.php:212Copy
  • SELECT theme FROM evapj_droppics WHERE id='167'30μs0B/administrator/components/com_droppics/models/gallery.php:213Copy
  • SELECT params FROM evapj_droppics WHERE id='167'119μ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='167' ORDER BY position ASC636μs36.45KB/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='167' ORDER BY position ASC57μs0B/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=167 AND c.extension="com_droppics" ORDER BY c.lft ASC280μ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=167 AND c.extension="com_droppics" ORDER BY c.lft ASC34μ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=167) AND c.extension="com_droppics" GROUP BY p.id_gallery ORDER BY c.lft ASC,p.position ASC293μ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=167) AND c.extension="com_droppics" GROUP BY p.id_gallery ORDER BY c.lft ASC,p.position ASC44μ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 `a`.`ordering`598μs2.47KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:205Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `evapj_categories` AS `s` INNER JOIN `evapj_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`125μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `evapj_template_styles` WHERE `client_id` = 0 AND `id` = '28'77μ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`708μs2.13KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `evapj_content` AS `a` LEFT JOIN `evapj_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `evapj_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `evapj_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `evapj_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `evapj_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `evapj_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.hits DESC LIMIT 41.94ms22.41KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `evapj_categories` AS `s` INNER JOIN `evapj_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`124μ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 `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`98μ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.71ms22.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`113μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `evapj_content` AS `a` LEFT JOIN `evapj_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `evapj_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `evapj_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `evapj_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `evapj_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `evapj_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.modified DESC, a.created DESC LIMIT 31.31ms40.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`117μ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`148μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `evapj_schemaorg` WHERE `itemId` = :itemId AND `context` = :context187μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:406Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `evapj_content` AS `a` INNER JOIN `evapj_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `evapj_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `evapj_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `evapj_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `evapj_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)159μs22.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `evapj_content` AS `a` INNER JOIN `evapj_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `evapj_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `evapj_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `evapj_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `evapj_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)159μs22.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT * FROM evapj_jmap_metainfo WHERE `linkurl` = 'https://lsaa.blacklightproductions.com.au/projects/large-fabric-structures/96-clarke-quay-redevelopment' AND `published` = 1747μs912B/plugins/system/jmap/jmap.php:838Copy
  • SELECT * FROM evapj_jmap_canonicals WHERE `linkurl` = 'https://lsaa.blacklightproductions.com.au/projects/large-fabric-structures/96-clarke-quay-redevelopment'97μ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` = 1160μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT manifest_cache FROM evapj_extensions WHERE type='component' AND element='com_baforms'52μs536B/components/com_baforms/src/Helper/BaformsHelper.php:731Copy
  • SELECT `key` FROM evapj_baforms_api WHERE service = 'balbooa_activation'47μs536B/components/com_baforms/src/Helper/BaformsHelper.php:716Copy
  • SELECT manifest_cache FROM evapj_extensions WHERE type='component' AND element='com_baforms'42μ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 * FROM evapj_jmap_headings WHERE `linkurl` = 'https://lsaa.blacklightproductions.com.au/projects/large-fabric-structures/96-clarke-quay-redevelopment'127μ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` = 147μs688B/plugins/system/jmap/jmap.php:508Copy
  • 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`127μs19.95KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `session_id` FROM `evapj_session` WHERE `session_id` = ?164μs12KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `evapj_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?698μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy