Footnotes
[13] New Scientist vol 179 issue 2413 - 20 September 2003, page 25
We have 35 guests and no members online
[13] New Scientist vol 179 issue 2413 - 20 September 2003, page 25
In September and October 2017 Wendy and I took another trip to the United States where we wanted to see some of the 'middle bits'. Travel notes from earlier visits to the East coast and West Coast can also be found on this website.
For over six weeks we travelled through a dozen states and stayed for a night or more in 20 different cities, towns or locations. This involved six domestic flights for the longer legs; five car hires and many thousands of miles of driving on America's excellent National Highways and in between on many not so excellent local roads and streets.
We had decided to start in Chicago and 'head on down south' to New Orleans via: Tennessee; Georgia; Louisiana; and South Carolina. From there we would head west to: Texas; New Mexico; Arizona; Utah and Nevada; then to Los Angeles and home. That's only a dozen states - so there are still lots of 'middle bits' left to be seen.
During the trip, disaster, in the form of three hurricanes and a mass shooting, seemed to precede us by a couple of days.
The United States is a fascinating country that has so much history, culture and language in common with us that it's extremely accessible. So these notes have turned out to be long and could easily have been much longer.
As another test of ChatGPT I asked it: "in 2 thousand words, to write a fiction about a modern-day witch who uses chemistry and female charms to enslave her familiars". This is one of the motifs in my novella: The Craft (along with: the great famine; world government; cyber security and overarching artificial intelligence).
Rather alarmingly, two of five ChatGPT offerings, each taking around 22 seconds to generate, came quite close to the sub-plot, although I'm not keen on the style or moralistic endings. Here they are:
Well, the Gillard government has done it; they have announced the long awaited price on carbon. But this time it's not the highly compromised CPRS previously announced by Kevin Rudd.
Accusations of lying and broken promises aside, the problem of using a tax rather than the earlier proposed cap-and-trade mechanism is devising a means by which the revenue raised will be returned to stimulate investment in new non-carbon based energy.
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.22MB) (18.44%) | 39.51ms |
1 x afterRoute (352.02KB) (17.07%) | 36.57ms |
1 x afterInitialise (1.26MB) (12.72%) | 27.26ms |
1 x afterRenderRawModule mod_articles_news (Travel) (372.17KB) (10.69%) | 22.91ms |
1 x afterRenderRawModule mod_articles_news (Opinions and Philosophy) (250.08KB) (9.05%) | 19.39ms |
1 x afterRenderRawModule mod_articles_news (Fiction, Recollections & News) (291.91KB) (8.79%) | 18.83ms |
1 x afterRenderComponent com_content (217.11KB) (4.73%) | 10.14ms |
1 x afterRenderRawModule mod_menu (Main Menu) (241.83KB) (3.45%) | 7.40ms |
1 x afterRender (179.9KB) (3.44%) | 7.37ms |
1 x afterLoad (529.34KB) (2.57%) | 5.52ms |
1 x afterRenderRawModule mod_finder (Search) (71.7KB) (1.68%) | 3.60ms |
1 x beforeRenderRawModule mod_finder (Search) (22.92KB) (1.25%) | 2.68ms |
1 x Before Access::preloadComponents (all components) (35.21KB) (0.77%) | 1.65ms |
1 x beforeRenderComponent com_content (28.58KB) (0.64%) | 1.38ms |
1 x Before Access::getAssetRules (id:8 name:com_content) (22.32KB) (0.64%) | 1.38ms |
1 x beforeRenderRawModule mod_menu (Main Menu) (60.68KB) (0.6%) | 1.28ms |
1 x afterDispatch (12.37KB) (0.47%) | 1.00ms |
1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (11.29KB) (0.47%) | 1.00ms |
1 x afterRenderRawModule mod_whosonline (Who is Online) (14.37KB) (0.43%) | 927μs |
1 x After Access::preloadComponents (all components) (123.43KB) (0.31%) | 669μs |
1 x After Access::preloadPermissions (com_content) (186.05KB) (0.31%) | 665μs |
1 x Before Access::getAssetRules (id:16 name:com_menus) (8.24KB) (0.2%) | 424μs |
1 x beforeRenderModule mod_menu (Main Menu) (23.11KB) (0.16%) | 338μs |
1 x beforeRenderModule mod_articles_news (Travel) (8.62KB) (0.11%) | 232μs |
1 x After Access::getAssetRules (id:124 name:com_content.article.18) (8.47KB) (0.08%) | 175μs |
1 x afterRenderModule mod_articles_news (Travel) (7.46KB) (0.07%) | 148μs |
1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (1.2KB) (0.06%) | 118μs |
1 x afterRenderModule mod_finder (Search) (3.26KB) (0.06%) | 118μs |
1 x afterRenderModule mod_menu (Main Menu) (5.93KB) (0.05%) | 113μs |
1 x afterRenderModule mod_articles_news (Fiction, Recollections & News) (3.46KB) (0.04%) | 94μs |
1 x afterRenderModule mod_articles_news (Opinions and Philosophy) (3.21KB) (0.04%) | 94μs |
1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.95KB) (0.04%) | 94μs |
1 x afterRenderModule mod_whosonline (Who is Online) (2.26KB) (0.04%) | 90μs |
1 x beforeRenderRawModule mod_articles_news (Travel) (4.72KB) (0.03%) | 57μs |
1 x beforeRenderModule mod_finder (Search) (368B) (0.03%) | 55μs |
1 x beforeRenderRawModule mod_articles_news (Fiction, Recollections & News) (80B) (0.02%) | 47μs |
1 x beforeRenderModule mod_articles_news (Opinions and Philosophy) (1.79KB) (0.02%) | 47μs |
1 x beforeRenderRawModule mod_articles_news (Opinions and Philosophy) (1.33KB) (0.02%) | 46μs |
1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (720B) (0.02%) | 44μs |
1 x After Access::getAssetRules (id:8 name:com_content) (6.95KB) (0.02%) | 42μs |
1 x After Access::getAssetRules (id:450 name:com_engage) (6.95KB) (0.02%) | 40μs |
1 x After Access::getAssetRules (id:16 name:com_menus) (6.95KB) (0.02%) | 40μs |
1 x beforeRenderModule mod_articles_news (Fiction, Recollections & News) (984B) (0.02%) | 34μs |
1 x Before Access::getAssetRules (id:124 name:com_content.article.18) (18.8KB) (0.01%) | 27μs |
1 x beforeRenderRawModule mod_whosonline (Who is Online) (336B) (0.01%) | 27μs |
1 x beforeRenderModule mod_whosonline (Who is Online) (728B) (0.01%) | 26μs |
1 x Before Access::preloadPermissions (com_content) (2.76KB) (0.01%) | 18μs |
SELECT @@SESSION.sql_mode;
108μs1.57KB/libraries/src/Session/MetadataManager.php:184CopySELECT `session_id`
FROM `ttl_session`
WHERE `session_id` = :session_id LIMIT 1
238μ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)
275μs944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `id`,`rules`
FROM `ttl_viewlevels`
91μ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
86μ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`
624μs13.17KBParams/libraries/src/Categories/Categories.php:375CopySHOW TABLES
656μ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)
170μ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
145μs27.05KBParams/libraries/src/Access/Access.php:301CopySHOW FULL COLUMNS FROM `ttl_content`
514μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopyUPDATE `ttl_content`
SET `hits` = (`hits` + 1)
WHERE `id` = '18'
741μ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)
536μs136.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`
133μ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)
314μ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'
73μ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`
141μ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
148μ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
646μs2.22KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188CopySHOW FULL COLUMNS FROM `ttl_users`
377μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT *
FROM `ttl_users`
WHERE `id` = :userid
106μ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`
437μs2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT *
FROM `ttl_categories`
WHERE `id` = '12'
113μ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)
91μ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 `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
109μs1.73KBParams/libraries/src/Language/Associations.php:145CopySELECT *
FROM `ttl_categories`
WHERE `id` = '47'
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)
78μ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)
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)
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
383μ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
246μs2.45KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:199CopySELECT `alias`
FROM `ttl_content`
WHERE `id` = :id
184μs1.63KBParams/components/com_content/src/Service/Router.php:168CopySELECT `alias`
FROM `ttl_content`
WHERE `id` = :id
82μ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`
1.34ms2.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`
152μs5.23KBParams/libraries/src/Categories/Categories.php:375CopySELECT `language`,`id`
FROM `ttl_menu`
WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0
84μs912B/libraries/src/Language/Multilanguage.php:123CopySELECT `alias`
FROM `ttl_content`
WHERE `id` = :id
91μs1.63KBParams/components/com_content/src/Service/Router.php:168CopySELECT `alias`
FROM `ttl_content`
WHERE `id` = :id
88μ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 21:33:15') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-04-05 21:33:15') AND c2.state = 1
452μs1.78KBParams/libraries/src/Language/Associations.php:145CopySELECT `name`,`element`
FROM `ttl_extensions`
WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1
93μ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)
68μs1000B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314CopySELECT guest, client_id
FROM ttl_session
WHERE client_id = 0
268μs1.5KB/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
11.67ms475.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`
592μ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
143μ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`
136μ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
664μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `asset_id`
FROM `ttl_content`
WHERE `id` = '209'
152μs856B/plugins/content/engage/src/Extension/Engage.php:691CopySELECT *
FROM `ttl_categories`
WHERE `id` = '20'
204μ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)
200μ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
249μs1.73KBParams/libraries/src/Language/Associations.php:145CopySELECT *
FROM `ttl_categories`
WHERE `id` = '48'
108μ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)
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
91μ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)
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)
80μ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
10.65ms57.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μ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`
138μ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
145μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `asset_id`
FROM `ttl_content`
WHERE `id` = '427'
196μs856B/plugins/content/engage/src/Extension/Engage.php:691CopySELECT *
FROM `ttl_categories`
WHERE `id` = '6'
104μ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)
92μ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
89μs1.73KBParams/libraries/src/Language/Associations.php:145CopySELECT *
FROM `ttl_categories`
WHERE `id` = '46'
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)
86μ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
104μs1.73KBParams/libraries/src/Language/Associations.php:145CopySELECT *
FROM `ttl_categories`
WHERE `id` = '1'
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)
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)
80μ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
11.47ms27.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`
172μ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`
130μ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
146μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `asset_id`
FROM `ttl_content`
WHERE `id` = '60'
164μs856B/plugins/content/engage/src/Extension/Engage.php:691CopySELECT *
FROM `ttl_categories`
WHERE `id` = '13'
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)
84μ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
89μs1.73KBParams/libraries/src/Language/Associations.php:145CopySELECT *
FROM `ttl_categories`
WHERE `id` = '47'
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)
77μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT *
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)
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)
78μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT `alias`
FROM `ttl_content`
WHERE `id` = :id
80μ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 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
225μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517CopySHOW TABLES
636μ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`
148μ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`
136μs5.25KBParams/libraries/src/Categories/Categories.php:375Copy