In April 2023 we took a package tour to South Africa with our friends Craig and Sonia. We flew via Singapore to Cape Town.
We have 244 guests and no members online
In April 2023 we took a package tour to South Africa with our friends Craig and Sonia. We flew via Singapore to Cape Town.
In 1957-58 the film ‘The Bridge on the River Kwai‘ was ground breaking. It was remarkable for being mainly shot on location (in Ceylon not Thailand) rather than in a studio and for involving the construction and demolition of a real, fully functioning rail bridge. It's still regarded by many as one of the finest movies ever made.
One of the things a tourist to Bangkok is encouraged to do is to take a day trip to the actual bridge.
Regular readers will know that I have an artificial heart valve. Indeed many people have implanted prosthesis, from metal joints or tooth fillings to heart pacemakers and implanted cochlear hearing aides, or just eye glasses or dentures. Some are kept alive by drugs. All of these are ways in which our individual survival has become progressively more dependent on technology. So that should it fail many would suffer. Indeed some today feel bereft without their mobile phone that now substitutes for skills, like simple mathematics, that people once had to have themselves. But while we may be increasingly transformed by tools and implants, the underlying genes, conferred by reproduction, remain human.
The possibility of accelerated genetic evolution through technology was brought nearer last week when, on 28 November 2018, a young scientist, He Jiankui, announced, at the Second International Summit on Human Genome Editing in Hong Kong, that he had successfully used the powerful gene-editing tool CRISPR to edit a gene in several children.
This essay is most of all about understanding; what we can know and what we think we do know. It is an outline originally written for my children and I have tried to avoid jargon or to assume the reader's in-depth familiarity with any of the subjects I touch on. I began it in 1997 when my youngest was still a small child and parts are still written in language I used with her then. I hope this makes it clear and easy to understand for my children and anyone else.
Joomla! Version | 4.4.12 |
PHP Version | 8.1.31 |
Identity | guest |
Response | 200 |
Template | cassiopeia |
Database |
|
1 x Before Access::getAssetRules (id:450 name:com_engage) (1.69MB) (37.47%) | 115.78ms |
1 x afterRenderRawModule mod_articles_news (Travel) (288.44KB) (10.17%) | 31.42ms |
1 x afterRenderRawModule mod_articles_news (Fiction, Recollections & News) (292.4KB) (7.85%) | 24.24ms |
1 x afterInitialise (1.26MB) (7.78%) | 24.02ms |
1 x afterRenderRawModule mod_articles_news (Opinions and Philosophy) (269.99KB) (7.04%) | 21.76ms |
1 x afterRenderComponent com_content (333.12KB) (6.85%) | 21.16ms |
1 x afterRoute (419.67KB) (4.43%) | 13.68ms |
1 x afterRenderRawModule mod_menu (Main Menu) (244.7KB) (3.8%) | 11.74ms |
1 x afterRender (155.22KB) (3.32%) | 10.25ms |
1 x Before Access::preloadComponents (all components) (100.6KB) (2.71%) | 8.37ms |
1 x afterLoad (529.34KB) (1.5%) | 4.64ms |
1 x afterRenderRawModule mod_finder (Search) (71.7KB) (1.25%) | 3.87ms |
1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (76.51KB) (0.82%) | 2.54ms |
1 x beforeRenderRawModule mod_finder (Search) (22.92KB) (0.74%) | 2.30ms |
1 x Before Access::getAssetRules (id:8 name:com_content) (22.48KB) (0.69%) | 2.15ms |
1 x beforeRenderRawModule mod_menu (Main Menu) (60.79KB) (0.64%) | 1.97ms |
1 x afterRenderRawModule mod_whosonline (Who is Online) (14.77KB) (0.54%) | 1.67ms |
1 x beforeRenderComponent com_content (29.52KB) (0.42%) | 1.29ms |
1 x afterDispatch (12.5KB) (0.3%) | 924μs |
1 x After Access::preloadComponents (all components) (123.43KB) (0.27%) | 840μs |
1 x After Access::preloadPermissions (com_content) (186.05KB) (0.22%) | 670μs |
1 x Before Access::getAssetRules (id:16 name:com_menus) (8.24KB) (0.16%) | 488μs |
1 x afterRenderModule mod_articles_news (Travel) (6.62KB) (0.12%) | 382μs |
1 x beforeRenderModule mod_menu (Main Menu) (23.11KB) (0.12%) | 373μs |
1 x beforeRenderModule mod_articles_news (Travel) (8.62KB) (0.07%) | 229μs |
1 x After Access::getAssetRules (id:446 name:com_content.article.418) (8.47KB) (0.06%) | 194μs |
1 x afterRenderModule mod_finder (Search) (3.26KB) (0.04%) | 122μs |
1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (1.95KB) (0.04%) | 121μs |
1 x afterRenderModule mod_articles_news (Fiction, Recollections & News) (3.96KB) (0.03%) | 105μs |
1 x afterRenderModule mod_menu (Main Menu) (5.93KB) (0.03%) | 103μs |
1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.82KB) (0.03%) | 97μs |
1 x afterRenderModule mod_articles_news (Opinions and Philosophy) (3.46KB) (0.03%) | 94μs |
1 x afterRenderModule mod_whosonline (Who is Online) (2.26KB) (0.03%) | 92μs |
1 x beforeRenderRawModule mod_articles_news (Travel) (4.72KB) (0.02%) | 65μs |
1 x beforeRenderModule mod_finder (Search) (496B) (0.02%) | 55μs |
1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (720B) (0.02%) | 53μs |
1 x beforeRenderRawModule mod_articles_news (Fiction, Recollections & News) (80B) (0.02%) | 50μs |
1 x beforeRenderRawModule mod_articles_news (Opinions and Philosophy) (1.33KB) (0.02%) | 50μs |
1 x After Access::getAssetRules (id:8 name:com_content) (6.95KB) (0.01%) | 46μs |
1 x After Access::getAssetRules (id:450 name:com_engage) (6.95KB) (0.01%) | 44μs |
1 x After Access::getAssetRules (id:16 name:com_menus) (6.95KB) (0.01%) | 42μs |
1 x beforeRenderModule mod_articles_news (Fiction, Recollections & News) (984B) (0.01%) | 37μs |
1 x beforeRenderModule mod_articles_news (Opinions and Philosophy) (2.79KB) (0.01%) | 36μs |
1 x beforeRenderRawModule mod_whosonline (Who is Online) (336B) (0.01%) | 30μs |
1 x Before Access::getAssetRules (id:446 name:com_content.article.418) (18.8KB) (0.01%) | 28μ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%) | 18μs |
SELECT @@SESSION.sql_mode;
96μs1.57KB/libraries/src/Session/MetadataManager.php:184CopySELECT `session_id`
FROM `ttl_session`
WHERE `session_id` = :session_id LIMIT 1
202μ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)
312μs944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `id`,`rules`
FROM `ttl_viewlevels`
80μ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
80μ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`
563μs13.17KBParams/libraries/src/Categories/Categories.php:375CopySHOW TABLES
669μ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)
196μ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
138μs27.05KBParams/libraries/src/Access/Access.php:301CopySHOW FULL COLUMNS FROM `ttl_content`
816μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopyUPDATE `ttl_content`
SET `hits` = (`hits` + 1)
WHERE `id` = '418'
1ms48B/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)
590μs72.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`
566μ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)
345μ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'
87μ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`
183μ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
1.3ms8.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
606μs2.09KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188CopySHOW FULL COLUMNS FROM `ttl_users`
459μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT *
FROM `ttl_users`
WHERE `id` = :userid
115μ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
84μs1.7KBParams/libraries/src/Table/User.php:132CopySHOW FULL COLUMNS FROM `ttl_categories`
513μs2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT *
FROM `ttl_categories`
WHERE `id` = '42'
268μ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)
321μ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
244μ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)
80μ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)
77μ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
87μ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)
79μ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
380μ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
321μs2.45KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:199CopySELECT `alias`
FROM `ttl_content`
WHERE `id` = :id
163μs1.63KBParams/components/com_content/src/Service/Router.php:168CopySELECT `alias`
FROM `ttl_content`
WHERE `id` = :id
74μ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`
992μ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`
170μs5.23KBParams/libraries/src/Categories/Categories.php:375CopySELECT `language`,`id`
FROM `ttl_menu`
WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0
78μs912B/libraries/src/Language/Multilanguage.php:123CopySELECT `alias`
FROM `ttl_content`
WHERE `id` = :id
88μs1.63KBParams/components/com_content/src/Service/Router.php:168CopySELECT `alias`
FROM `ttl_content`
WHERE `id` = :id
72μ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-04-05 15:45:12') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-04-05 15:45:12') AND c2.state = 1
415μs1.78KBParams/libraries/src/Language/Associations.php:145CopySELECT `name`,`element`
FROM `ttl_extensions`
WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1
85μ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)
80μs1000B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314CopySELECT guest, client_id
FROM ttl_session
WHERE client_id = 0
332μs4.88KB/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
15.28ms27.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`
171μ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
173μ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`
157μ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
184μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `asset_id`
FROM `ttl_content`
WHERE `id` = '152'
318μs856B/plugins/content/engage/src/Extension/Engage.php:691CopySELECT *
FROM `ttl_categories`
WHERE `id` = '19'
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)
104μ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)
105μ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
108μs1.73KBParams/libraries/src/Language/Associations.php:145CopySELECT *
FROM `ttl_categories`
WHERE `id` = '48'
154μ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)
93μ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)
207μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT *
FROM `ttl_categories`
WHERE `id` = '1'
127μ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)
110μ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
15.15ms25.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`
154μ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`
194μ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
153μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `asset_id`
FROM `ttl_content`
WHERE `id` = '220'
294μs856B/plugins/content/engage/src/Extension/Engage.php:691CopySELECT *
FROM `ttl_categories`
WHERE `id` = '43'
110μ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)
85μ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 `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
90μs1.73KBParams/libraries/src/Language/Associations.php:145CopySELECT *
FROM `ttl_categories`
WHERE `id` = '55'
111μ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)
97μ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)
83μ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
90μs1.73KBParams/libraries/src/Language/Associations.php:145CopySELECT *
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)
97μ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
10.69ms835.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`
777μ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`
142μ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
872μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `asset_id`
FROM `ttl_content`
WHERE `id` = '11'
206μs856B/plugins/content/engage/src/Extension/Engage.php:691CopySELECT *
FROM `ttl_categories`
WHERE `id` = '4'
301μ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)
268μ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)
110μ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
250μs1.73KBParams/libraries/src/Language/Associations.php:145CopySELECT *
FROM `ttl_categories`
WHERE `id` = '46'
121μ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)
89μ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
87μs1.73KBParams/libraries/src/Language/Associations.php:145CopySELECT *
FROM `ttl_categories`
WHERE `id` = '1'
107μ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)
87μ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)
81μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `alias`
FROM `ttl_content`
WHERE `id` = :id
90μs1.63KBParams/components/com_content/src/Service/Router.php:168CopySELECT `alias`
FROM `ttl_content`
WHERE `id` = :id
76μ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
361μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517CopySHOW TABLES
702μ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`
171μ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`
138μs5.25KBParams/libraries/src/Categories/Categories.php:375Copy