More photos of Bali
Click on the image above to see the photo album
We have 94 guests and no members online
September 2014
Off the plane we are welcomed by a warm Autumn day in the south of France. Fragrant and green.
Lyon is the first step on our short stay in Southern France, touring in leisurely hops by car, down the Rhône valley from Lyon to Avignon and then to Aix and Nice with various stops along the way.
Months earlier I’d booked a car from Lyon Airport to be dropped off at Nice Airport. I’d tried booking town centre to town centre but there was nothing available.
This meant I got to drive an unfamiliar car, with no gearstick or ignition switch and various other novel idiosyncrasies, ‘straight off the plane’. But I managed to work it out and we got to see the countryside between the airport and the city and quite a bit of the outer suburbs at our own pace. Fortunately we had ‘Madam Butterfly’ with us (more of her later) else we could never have reached our hotel through the maze of one way streets.
Back in 2021 I went to see the first installment of ‘DUNE’ and was slightly 'put out' to discover that it ended half way through the (first) book.
It was the second big-screen attempt to make a movie of the book, if you don’t count the first ‘Star Wars’, that borrows shamelessly from Frank Herbert’s Si-Fi classic, and I thought it a lot better.
Now the long-awaited second part has been released.
|
Directed by Denis Villeneuve Screenplay by Denis Villeneuve, Jon Spaihts Based on Dune by Frank Herbert Starring Timothée Chalamet, Zendaya, Rebecca Ferguson, Josh Brolin, Austin Butler' Florence Pugh, Dave Bautista Christopher Walken, Léa Seydoux, Souheila Yacoub, Stellan Skarsgård, Charlotte Rampling, Javier Bardem Cinematography Greig Fraser, Edited by Joe Walker Music by Hans Zimmer Running time 165 minutes |
I originally wrote the paper, Issues Arising from the Greenhouse Hypothesis, in 1990 and do not see a need to revise it substantially. Some of the science is better defined and there have been some minor changes in some of the projections; but otherwise little has changed.
In the Introduction to the 2006 update to that paper I wrote:
Climate change has wide ranging implications... ranging from its impacts on agriculture (through drought, floods, water availability, land degradation and carbon credits) mining (by limiting markets for coal and minerals processing) manufacturing and transport (through energy costs) to property damage resulting from storms.
The issues are complex, ranging from disputes about the impact of human activities on global warming, to arguments about what should be done and the consequences of the various actions proposed.
Joomla! Version | 4.4.13 |
PHP Version | 8.1.32 |
Identity | guest |
Response | 200 |
Template | cassiopeia |
Database |
|
1 x Before Access::getAssetRules (id:450 name:com_engage) (1.27MB) (24.64%) | 51.61ms |
1 x afterInitialise (1.26MB) (12.93%) | 27.07ms |
1 x afterRenderRawModule mod_articles_news (Travel) (287.61KB) (10.83%) | 22.69ms |
1 x afterRenderComponent com_content (269.75KB) (9.26%) | 19.40ms |
1 x afterRenderRawModule mod_articles_news (Fiction, Recollections & News) (292.29KB) (8.81%) | 18.45ms |
1 x afterRenderRawModule mod_articles_news (Opinions and Philosophy) (270.62KB) (8.79%) | 18.40ms |
1 x afterRender (187.69KB) (5.16%) | 10.81ms |
1 x afterRenderRawModule mod_menu (Main Menu) (242.59KB) (3.54%) | 7.42ms |
1 x afterRoute (352.88KB) (3.48%) | 7.29ms |
1 x afterLoad (529.34KB) (2.79%) | 5.84ms |
1 x afterRenderRawModule mod_finder (Search) (71.7KB) (2.07%) | 4.33ms |
1 x Before Access::preloadComponents (all components) (36.3KB) (1.34%) | 2.81ms |
1 x afterRenderRawModule mod_whosonline (Who is Online) (78.37KB) (0.68%) | 1.43ms |
1 x Before Access::getAssetRules (id:8 name:com_content) (22.16KB) (0.66%) | 1.39ms |
1 x beforeRenderComponent com_content (27.79KB) (0.64%) | 1.35ms |
1 x beforeRenderRawModule mod_menu (Main Menu) (59.41KB) (0.62%) | 1.31ms |
1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (11.16KB) (0.61%) | 1.28ms |
1 x afterDispatch (12.52KB) (0.44%) | 914μs |
1 x After Access::preloadComponents (all components) (123.43KB) (0.38%) | 803μs |
1 x After Access::preloadPermissions (com_content) (186.05KB) (0.33%) | 695μs |
1 x Before Access::getAssetRules (id:16 name:com_menus) (8.24KB) (0.28%) | 596μs |
1 x beforeRenderRawModule mod_finder (Search) (22.92KB) (0.21%) | 430μs |
1 x beforeRenderModule mod_menu (Main Menu) (23.11KB) (0.18%) | 376μs |
1 x beforeRenderModule mod_articles_news (Travel) (8.62KB) (0.11%) | 235μs |
1 x After Access::getAssetRules (id:341 name:com_content.article.192) (8.47KB) (0.09%) | 191μs |
1 x afterRenderModule mod_articles_news (Travel) (6.71KB) (0.08%) | 162μs |
1 x afterRenderModule mod_finder (Search) (3.26KB) (0.06%) | 123μs |
1 x afterRenderModule mod_articles_news (Fiction, Recollections & News) (3.96KB) (0.06%) | 122μs |
1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (2.95KB) (0.06%) | 122μs |
1 x afterRenderModule mod_menu (Main Menu) (5.93KB) (0.05%) | 108μs |
1 x afterRenderModule mod_articles_news (Opinions and Philosophy) (4.46KB) (0.05%) | 99μs |
1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.82KB) (0.05%) | 97μs |
1 x afterRenderModule mod_whosonline (Who is Online) (2.26KB) (0.04%) | 93μs |
1 x beforeRenderRawModule mod_articles_news (Travel) (4.72KB) (0.04%) | 86μs |
1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (720B) (0.04%) | 77μs |
1 x beforeRenderRawModule mod_articles_news (Fiction, Recollections & News) (80B) (0.03%) | 67μs |
1 x beforeRenderModule mod_finder (Search) (496B) (0.03%) | 56μs |
1 x beforeRenderRawModule mod_articles_news (Opinions and Philosophy) (1.33KB) (0.03%) | 53μs |
1 x After Access::getAssetRules (id:8 name:com_content) (6.95KB) (0.02%) | 47μs |
1 x After Access::getAssetRules (id:450 name:com_engage) (6.95KB) (0.02%) | 46μs |
1 x After Access::getAssetRules (id:16 name:com_menus) (6.95KB) (0.02%) | 43μs |
1 x beforeRenderRawModule mod_whosonline (Who is Online) (336B) (0.02%) | 36μs |
1 x beforeRenderModule mod_articles_news (Opinions and Philosophy) (2.54KB) (0.02%) | 36μs |
1 x beforeRenderModule mod_articles_news (Fiction, Recollections & News) (984B) (0.02%) | 34μs |
1 x Before Access::getAssetRules (id:341 name:com_content.article.192) (18.8KB) (0.01%) | 29μs |
1 x beforeRenderModule mod_whosonline (Who is Online) (728B) (0.01%) | 25μs |
1 x Before Access::preloadPermissions (com_content) (2.76KB) (0.01%) | 21μs |
SELECT @@SESSION.sql_mode;
98μs1.57KB/libraries/src/Session/MetadataManager.php:184CopySELECT `session_id`
FROM `ttl_session`
WHERE `session_id` = :session_id LIMIT 1
263μs1.61KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `ttl_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
337μs944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `id`,`rules`
FROM `ttl_viewlevels`
68μs976B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `ttl_usergroups` AS `a`
LEFT JOIN `ttl_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
93μs2.27KBParams/libraries/src/Access/Access.php:868CopySELECT `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 `ttl_categories` AS `s`
INNER JOIN `ttl_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray1,:preparedArray2)) 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`
599μs13.17KBParams/libraries/src/Categories/Categories.php:375CopySHOW TABLES
652μs2.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `ttl_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)
194μs8.12KBParams/libraries/src/Access/Access.php:357CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `ttl_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0
132μs27.05KBParams/libraries/src/Access/Access.php:301CopySHOW FULL COLUMNS FROM `ttl_content`
554μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopyUPDATE `ttl_content`
SET `hits` = (`hits` + 1)
WHERE `id` = '192'
683μs48B/libraries/src/Table/Table.php:1325CopySELECT `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 `ttl_content` AS `a`
INNER JOIN `ttl_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `ttl_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `ttl_users` AS `u` ON `u`.`id` = `a`.`created_by`
LEFT JOIN `ttl_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `ttl_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE
(
(`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) 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 (:preparedArray3,:preparedArray4)
574μs128.69KBParams/components/com_content/src/Model/ArticleModel.php:215CopySELECT `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 `ttl_categories` AS `s`
INNER JOIN `ttl_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
135μs5.23KBParams/libraries/src/Categories/Categories.php:375CopySELECT `m`.`tag_id`,`t`.*
FROM `ttl_contentitem_tag_map` AS `m`
INNER JOIN `ttl_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)
333μs5.22KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT `extension_id`,`name`,`enabled`,`params`
FROM ttl_extensions
WHERE `type` = 'plugin' AND `element` = 'osembed' AND `folder` = 'content'
75μs1KB/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:170CopySELECT `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 `ttl_categories` AS `s`
INNER JOIN `ttl_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
154μs5.23KBParams/libraries/src/Categories/Categories.php:375CopySELECT 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 ttl_fields AS a
LEFT JOIN `ttl_languages` AS l ON l.lang_code = a.language
LEFT JOIN ttl_users AS uc ON uc.id=a.checked_out
LEFT JOIN ttl_viewlevels AS ag ON ag.id = a.access
LEFT JOIN ttl_users AS ua ON ua.id = a.created_user_id
LEFT JOIN ttl_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `ttl_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 ASC
846μs8.56KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `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 `ttl_content` AS `a`
LEFT JOIN `ttl_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) AND `a`.`language` IN (:preparedArray3,:preparedArray4)
ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC
790μs2.31KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188CopySHOW FULL COLUMNS FROM `ttl_users`
394μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT *
FROM `ttl_users`
WHERE `id` = :userid
112μs4.41KBParams/libraries/src/Table/User.php:104CopySELECT `g`.`id`,`g`.`title`
FROM `ttl_usergroups` AS `g`
INNER JOIN `ttl_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id`
WHERE `m`.`user_id` = :muserid
81μs1.7KBParams/libraries/src/Table/User.php:132CopySHOW FULL COLUMNS FROM `ttl_categories`
446μs2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT *
FROM `ttl_categories`
WHERE `id` = '19'
246μs4.25KB/libraries/src/Table/Table.php:755CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
210μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
80μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
FROM `ttl_categories` AS `c`
INNER JOIN `ttl_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `ttl_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `ttl_categories` AS `c2` ON `a2`.`id` = `c2`.`id` AND c2.extension = :extension1
WHERE `c`.`id` = :id AND `c`.`extension` = :extension3
254μs1.73KBParams/libraries/src/Language/Associations.php:145CopySELECT *
FROM `ttl_categories`
WHERE `id` = '48'
112μs20.25KB/libraries/src/Table/Table.php:755CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
83μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
80μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
FROM `ttl_categories` AS `c`
INNER JOIN `ttl_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `ttl_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `ttl_categories` AS `c2` ON `a2`.`id` = `c2`.`id` AND c2.extension = :extension1
WHERE `c`.`id` = :id AND `c`.`extension` = :extension3
88μs1.73KBParams/libraries/src/Language/Associations.php:145CopySELECT *
FROM `ttl_categories`
WHERE `id` = '1'
105μs4.25KB/libraries/src/Table/Table.php:755CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
81μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
80μs12.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
FROM `ttl_categories` AS `c`
INNER JOIN `ttl_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `ttl_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `ttl_categories` AS `c2` ON `a2`.`id` = `c2`.`id` AND c2.extension = :extension1
WHERE `c`.`id` = :id AND `c`.`extension` = :extension3
87μs1.73KBParams/libraries/src/Language/Associations.php:145CopySELECT `c`.`id`,`c`.`parent_id`
FROM `ttl_engage_comments` AS `c`
LEFT JOIN `ttl_users` AS `u` ON `u`.`id` = `c`.`created_by`
LEFT JOIN `ttl_content` AS `a` ON `a`.`asset_id` = `c`.`asset_id`
LEFT JOIN `ttl_categories` AS `cat` ON `cat`.`id` = `a`.`catid`
WHERE `c`.`asset_id` = :asset_id AND `c`.`enabled` = :enabled
ORDER BY `c`.`created` DESC, `c`.`id` DESC
461μs1.69KBParams/administrator/components/com_engage/src/Model/CommentsModel.php:220CopySELECT COUNT(*)
FROM `ttl_engage_comments` AS `c`
LEFT JOIN `ttl_users` AS `u` ON `u`.`id` = `c`.`created_by`
LEFT JOIN `ttl_content` AS `a` ON `a`.`asset_id` = `c`.`asset_id`
LEFT JOIN `ttl_categories` AS `cat` ON `cat`.`id` = `a`.`catid`
WHERE `c`.`asset_id` = :asset_id AND `c`.`enabled` = :enabled
306μs2.45KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:199CopySELECT `alias`
FROM `ttl_content`
WHERE `id` = :id
165μs1.63KBParams/components/com_content/src/Service/Router.php:168CopySELECT `alias`
FROM `ttl_content`
WHERE `id` = :id
85μs1.63KBParams/components/com_content/src/Service/Router.php:168CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `ttl_modules` AS `m`
LEFT JOIN `ttl_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `ttl_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) AND `m`.`language` IN (:preparedArray3,:preparedArray4)
ORDER BY `m`.`position`,`m`.`ordering`
958μs2.28KBParams/libraries/src/Cache/Controller/CallbackController.php:120CopySELECT `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 `ttl_categories` AS `s`
INNER JOIN `ttl_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
147μs5.23KBParams/libraries/src/Categories/Categories.php:375CopySELECT `language`,`id`
FROM `ttl_menu`
WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0
93μs912B/libraries/src/Language/Multilanguage.php:123CopySELECT `alias`
FROM `ttl_content`
WHERE `id` = :id
77μs1.63KBParams/components/com_content/src/Service/Router.php:168CopySELECT `alias`
FROM `ttl_content`
WHERE `id` = :id
73μs1.63KBParams/components/com_content/src/Service/Router.php:168CopySELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid`
FROM `ttl_content` AS `c`
INNER JOIN `ttl_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `ttl_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `ttl_content` AS `c2` ON `a2`.`id` = `c2`.`id`
INNER JOIN `ttl_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2
WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-05-06 05:57:35') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-05-06 05:57:35') AND c2.state = 1
394μs1.78KBParams/libraries/src/Language/Associations.php:145CopySELECT `name`,`element`
FROM `ttl_extensions`
WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1
91μs992B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135CopySELECT `title`
FROM `ttl_finder_taxonomy`
WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)
90μs1000B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314CopySELECT guest, client_id
FROM ttl_session
WHERE client_id = 0
382μs2.38KB/modules/mod_whosonline/src/Helper/WhosonlineHelper.php:51CopySELECT `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 `ttl_content` AS `a`
LEFT JOIN `ttl_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `ttl_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `ttl_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `ttl_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `ttl_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `ttl_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`.`id` <> :articleId AND `a`.`catid` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray14,:preparedArray15)
ORDER BY RAND() ASC LIMIT 1
10.26ms115.05KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `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 `ttl_categories` AS `s`
INNER JOIN `ttl_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
186μs5.23KBParams/libraries/src/Categories/Categories.php:375CopySELECT 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 ttl_fields AS a
LEFT JOIN `ttl_languages` AS l ON l.lang_code = a.language
LEFT JOIN ttl_users AS uc ON uc.id=a.checked_out
LEFT JOIN ttl_viewlevels AS ag ON ag.id = a.access
LEFT JOIN ttl_users AS ua ON ua.id = a.created_user_id
LEFT JOIN ttl_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) 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 ASC
203μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `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 `ttl_categories` AS `s`
INNER JOIN `ttl_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
189μs5.23KBParams/libraries/src/Categories/Categories.php:375CopySELECT 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 ttl_fields AS a
LEFT JOIN `ttl_languages` AS l ON l.lang_code = a.language
LEFT JOIN ttl_users AS uc ON uc.id=a.checked_out
LEFT JOIN ttl_viewlevels AS ag ON ag.id = a.access
LEFT JOIN ttl_users AS ua ON ua.id = a.created_user_id
LEFT JOIN ttl_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `ttl_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 ASC
174μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `asset_id`
FROM `ttl_content`
WHERE `id` = '168'
219μs856B/plugins/content/engage/src/Extension/Engage.php:691CopySELECT *
FROM `ttl_categories`
WHERE `id` = '17'
115μs4.25KB/libraries/src/Table/Table.php:755CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
114μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
95μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
FROM `ttl_categories` AS `c`
INNER JOIN `ttl_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `ttl_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `ttl_categories` AS `c2` ON `a2`.`id` = `c2`.`id` AND c2.extension = :extension1
WHERE `c`.`id` = :id AND `c`.`extension` = :extension3
91μs1.73KBParams/libraries/src/Language/Associations.php:145CopySELECT *
FROM `ttl_categories`
WHERE `id` = '48'
130μs4.25KB/libraries/src/Table/Table.php:755CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
84μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
98μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT *
FROM `ttl_categories`
WHERE `id` = '1'
109μs4.25KB/libraries/src/Table/Table.php:755CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
82μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
79μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `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 `ttl_content` AS `a`
LEFT JOIN `ttl_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `ttl_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `ttl_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `ttl_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `ttl_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `ttl_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`.`id` <> :articleId AND `a`.`catid` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray10,:preparedArray11)
ORDER BY RAND() ASC LIMIT 1
8.86ms25.67KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `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 `ttl_categories` AS `s`
INNER JOIN `ttl_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
157μs13.23KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `ttl_categories` AS `s`
INNER JOIN `ttl_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
133μs5.23KBParams/libraries/src/Categories/Categories.php:375CopySELECT 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 ttl_fields AS a
LEFT JOIN `ttl_languages` AS l ON l.lang_code = a.language
LEFT JOIN ttl_users AS uc ON uc.id=a.checked_out
LEFT JOIN ttl_viewlevels AS ag ON ag.id = a.access
LEFT JOIN ttl_users AS ua ON ua.id = a.created_user_id
LEFT JOIN ttl_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `ttl_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 ASC
150μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `asset_id`
FROM `ttl_content`
WHERE `id` = '428'
223μs856B/plugins/content/engage/src/Extension/Engage.php:691CopySELECT *
FROM `ttl_categories`
WHERE `id` = '43'
129μs4.25KB/libraries/src/Table/Table.php:755CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
103μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
99μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
FROM `ttl_categories` AS `c`
INNER JOIN `ttl_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `ttl_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `ttl_categories` AS `c2` ON `a2`.`id` = `c2`.`id` AND c2.extension = :extension1
WHERE `c`.`id` = :id AND `c`.`extension` = :extension3
119μs1.73KBParams/libraries/src/Language/Associations.php:145CopySELECT *
FROM `ttl_categories`
WHERE `id` = '55'
129μs4.25KB/libraries/src/Table/Table.php:755CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
100μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
99μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
FROM `ttl_categories` AS `c`
INNER JOIN `ttl_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `ttl_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `ttl_categories` AS `c2` ON `a2`.`id` = `c2`.`id` AND c2.extension = :extension1
WHERE `c`.`id` = :id AND `c`.`extension` = :extension3
107μs1.73KBParams/libraries/src/Language/Associations.php:145CopySELECT *
FROM `ttl_categories`
WHERE `id` = '1'
128μs4.25KB/libraries/src/Table/Table.php:755CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
102μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
100μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `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 `ttl_content` AS `a`
LEFT JOIN `ttl_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `ttl_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `ttl_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `ttl_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `ttl_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `ttl_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`.`id` <> :articleId AND `a`.`catid` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray16,:preparedArray17)
ORDER BY RAND() ASC LIMIT 1
7.15ms67.05KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `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 `ttl_categories` AS `s`
INNER JOIN `ttl_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
613μs5.23KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `ttl_categories` AS `s`
INNER JOIN `ttl_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
158μs5.23KBParams/libraries/src/Categories/Categories.php:375CopySELECT 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 ttl_fields AS a
LEFT JOIN `ttl_languages` AS l ON l.lang_code = a.language
LEFT JOIN ttl_users AS uc ON uc.id=a.checked_out
LEFT JOIN ttl_viewlevels AS ag ON ag.id = a.access
LEFT JOIN ttl_users AS ua ON ua.id = a.created_user_id
LEFT JOIN ttl_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `ttl_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 ASC
741μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `asset_id`
FROM `ttl_content`
WHERE `id` = '17'
181μs856B/plugins/content/engage/src/Extension/Engage.php:691CopySELECT *
FROM `ttl_categories`
WHERE `id` = '11'
241μs4.25KB/libraries/src/Table/Table.php:755CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
254μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
98μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
FROM `ttl_categories` AS `c`
INNER JOIN `ttl_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `ttl_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `ttl_categories` AS `c2` ON `a2`.`id` = `c2`.`id` AND c2.extension = :extension1
WHERE `c`.`id` = :id AND `c`.`extension` = :extension3
271μs1.73KBParams/libraries/src/Language/Associations.php:145CopySELECT *
FROM `ttl_categories`
WHERE `id` = '47'
132μs4.25KB/libraries/src/Table/Table.php:755CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
101μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
99μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
FROM `ttl_categories` AS `c`
INNER JOIN `ttl_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `ttl_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `ttl_categories` AS `c2` ON `a2`.`id` = `c2`.`id` AND c2.extension = :extension1
WHERE `c`.`id` = :id AND `c`.`extension` = :extension3
122μs1.73KBParams/libraries/src/Language/Associations.php:145CopySELECT *
FROM `ttl_categories`
WHERE `id` = '1'
130μs4.25KB/libraries/src/Table/Table.php:755CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
105μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `t`.`id`
FROM `ttl_tags` AS `t`
INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
100μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `alias`
FROM `ttl_content`
WHERE `id` = :id
104μs1.63KBParams/components/com_content/src/Service/Router.php:168CopySELECT `alias`
FROM `ttl_content`
WHERE `id` = :id
97μs1.63KBParams/components/com_content/src/Service/Router.php:168CopySELECT 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 `ttl_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
405μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517CopySHOW TABLES
701μs2.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678CopySELECT `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 `ttl_categories` AS `s`
INNER JOIN `ttl_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
187μs5.23KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `ttl_categories` AS `s`
INNER JOIN `ttl_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
158μs5.25KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `ttl_categories` AS `s`
INNER JOIN `ttl_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
154μs5.25KBParams/libraries/src/Categories/Categories.php:375Copy