The Fruit Shop site shows a number of Joomla! features.
The template uses classes in cascading style sheets to change the layout of items, such as creating the horizontal alphabetical list in the Fruit Encyclopedia.
We search the whole countryside for the best fruit growers.
You can let each supplier have a page that he or she can edit. To see this in action you will need to create a user who is in the suppliers group.
Create one page in the growers category for that user and make that supplier the author of the page. That user will be able to edit his or her page.
This illustrates the use of the Edit Own permission.
At our orchard we grow the world's best oranges as well as other citrus fruit such as lemons and grapefruit. Our family has been tending this orchard for generations.
Joomla! Version | 5.3.2 |
PHP Version | 8.4.7 |
Identity | guest |
Response | 200 |
Template | planis |
Database |
|
1 x afterInitialise (1.29MB) (30.47%) | 25.75ms |
1 x Before Access::getAssetRules (id:8 name:com_content) (480.12KB) (18.51%) | 15.64ms |
1 x afterRenderComponent com_content (449.93KB) (7.35%) | 6.21ms |
1 x afterRoute (865.26KB) (6.13%) | 5.18ms |
1 x Before Access::getAssetRules (id:128 name:com_content.article.30) (134.23KB) (5.31%) | 4.49ms |
1 x beforeRenderModule mod_menu (Naši partneri) (200.13KB) (5.09%) | 4.30ms |
1 x afterRender (258.57KB) (3.85%) | 3.26ms |
1 x afterDispatch (85.19KB) (2.72%) | 2.30ms |
1 x afterLoad (79.33KB) (2.7%) | 2.28ms |
1 x afterRenderRawModule mod_menu (Fruit Shop) (130.07KB) (2.57%) | 2.17ms |
1 x After Access::preloadPermissions (com_content) (767.94KB) (2.47%) | 2.09ms |
1 x afterRenderRawModule mod_custom (About Fruit Shop) (13.56KB) (2.11%) | 1.79ms |
1 x Before Access::getAssetRules (id:121 name:com_content.article.23) (13.05KB) (2.03%) | 1.71ms |
1 x After Access::preloadComponents (all components) (117.95KB) (1.57%) | 1.33ms |
1 x Before Access::preloadComponents (all components) (156.8KB) (1.45%) | 1.22ms |
1 x afterRenderRawModule mod_menu (Dozvedieť sa viac) (64.6KB) (0.91%) | 766μs |
1 x afterRenderRawModule mod_menu (Naši partneri) (49.53KB) (0.89%) | 749μs |
1 x afterRenderRawModule mod_menu (Kategórie) (27.41KB) (0.7%) | 593μs |
1 x afterRenderRawModule mod_menu (User Menu) (24.2KB) (0.58%) | 487μs |
1 x beforeRenderComponent com_content (35.88KB) (0.47%) | 398μs |
1 x Before Access::getAssetRules (id:1384 name:com_attachments) (10.58KB) (0.3%) | 254μs |
1 x afterRenderModule mod_menu (Naši partneri) (2.63KB) (0.16%) | 138μs |
1 x afterRenderModule mod_menu (Fruit Shop) (2.06KB) (0.11%) | 91μs |
1 x afterRenderModule mod_menu (User Menu) (2.13KB) (0.11%) | 91μs |
1 x afterRenderModule mod_custom (About Fruit Shop) (1.89KB) (0.11%) | 91μs |
1 x afterRenderModule mod_menu (Kategórie) (2.06KB) (0.11%) | 89μs |
1 x afterRenderModule mod_menu (Dozvedieť sa viac) (2.2KB) (0.11%) | 89μs |
1 x After Access::getAssetRules (id:55 name:com_content.category.30) (9.45KB) (0.08%) | 67μs |
1 x After Access::getAssetRules (id:128 name:com_content.article.30) (8.26KB) (0.06%) | 50μs |
1 x beforeRenderModule mod_menu (Kategórie) (296B) (0.06%) | 49μs |
1 x beforeRenderModule mod_menu (Dozvedieť sa viac) (296B) (0.06%) | 47μs |
1 x beforeRenderModule mod_menu (User Menu) (456B) (0.05%) | 46μs |
1 x beforeRenderModule mod_menu (Fruit Shop) (1.41KB) (0.05%) | 44μs |
1 x After Access::getAssetRules (id:8 name:com_content) (8.24KB) (0.05%) | 42μs |
1 x beforeRenderModule mod_custom (About Fruit Shop) (1.16KB) (0.05%) | 41μs |
1 x Before Access::getAssetRules (id:55 name:com_content.category.30) (34.65KB) (0.05%) | 38μs |
1 x After Access::getAssetRules (id:156 name:com_content.article.58) (8.26KB) (0.04%) | 35μs |
1 x Before Access::getAssetRules (id:156 name:com_content.article.58) (576B) (0.03%) | 27μs |
1 x After Access::getAssetRules (id:1384 name:com_attachments) (8.1KB) (0.03%) | 25μs |
1 x Before Access::getAssetRules (id:1 name:root.1) (696B) (0.02%) | 18μs |
1 x After Access::getAssetRules (id:121 name:com_content.article.23) (1.3KB) (0.02%) | 14μs |
1 x Before Access::preloadPermissions (com_content) (1.57KB) (0.02%) | 14μs |
1 x beforeRenderModule mod_menu (Naši partneri) (720B) (0.01%) | 6μs |
1 x After Access::getAssetRules (id:1 name:root.1) (1.91KB) (0.01%) | 5μs |
1 x beforeRenderModule mod_menu (Kategórie) (720B) (0.01%) | 5μs |
1 x beforeRenderModule mod_menu (Dozvedieť sa viac) (720B) (0.01%) | 5μs |
1 x beforeRenderModule mod_menu (Fruit Shop) (720B) (0.01%) | 5μs |
1 x beforeRenderModule mod_menu (User Menu) (704B) (0.01%) | 5μs |
1 x beforeRenderModule mod_custom (About Fruit Shop) (720B) (0.01%) | 5μs |
SELECT @@SESSION.sql_mode;
109μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259CopySELECT `data`
FROM `qw0o8_session`
WHERE `session_id` = ?
103μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `qw0o8_session`
WHERE `session_id` = :session_id LIMIT 1
101μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `qw0o8_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
9.16ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `qw0o8_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
352μs1.61KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `qw0o8_viewlevels`
140μs640B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `qw0o8_usergroups` AS `a`
LEFT JOIN `qw0o8_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
262μs1.31KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `qw0o8_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1)
ORDER BY `ordering`
698μs3.96KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT *
FROM `qw0o8_nextend2_section_storage`
WHERE `application` = 'smartslider' AND `section` = 'settings'
189μs1.5KB/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:182CopySELECT id FROM qw0o8_yendifvideoshare_imports WHERE state = 1 AND next_import_date IS NOT NULL AND next_import_date != '0000-00-00 00:00:00' AND next_import_date <= '2025-08-07 01:34:44' LIMIT 1
140μs520B/plugins/system/yendifvideoshare/yendifvideoshare.php:75CopySELECT *
FROM `qw0o8_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
175μs1.59KB/libraries/src/Language/LanguageHelper.php:179CopySELECT `element`,`name`,`client_id`,`extension_id`
FROM `qw0o8_extensions`
WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1
166μs784B/libraries/src/Language/LanguageHelper.php:252CopySELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component`
FROM `qw0o8_menu` AS `m`
LEFT JOIN `qw0o8_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`
WHERE
(
(`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2)
ORDER BY `m`.`lft`
1.06ms133.8KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `qw0o8_template_styles` AS `s`
LEFT JOIN `qw0o8_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id`
WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1
268μs848B/administrator/components/com_templates/src/Model/StyleModel.php:718CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `qw0o8_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)
529μs7.44KBParams/libraries/src/Access/Access.php:357CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `qw0o8_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0
1.11ms85.48KBParams/libraries/src/Access/Access.php:301CopySELECT `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`,(
SELECT COUNT(`i`.`id`)
FROM `qw0o8_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1 AND `i`.`language` IN (:preparedArray3,:preparedArray4)) AS `numitems`
FROM `qw0o8_categories` AS `s`
INNER JOIN `qw0o8_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`
823μs5.28KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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`
FROM `qw0o8_content` AS `a`
LEFT JOIN `qw0o8_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `qw0o8_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `qw0o8_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `qw0o8_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `qw0o8_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1) AND `c`.`access` IN (:preparedArray2) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` = :categoryId 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 (:preparedArray3,:preparedArray4)
ORDER BY c.lft, a.title, a.created LIMIT 9
831μs6.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.*
FROM `qw0o8_contentitem_tag_map` AS `m`
INNER JOIN `qw0o8_tags` AS `t` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2) AND `t`.`access` IN (:preparedArray3)
372μs4KBParams/libraries/src/Helper/TagsHelper.php:448CopySELECT COUNT(*)
FROM `qw0o8_content` AS `a`
LEFT JOIN `qw0o8_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `qw0o8_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `qw0o8_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `qw0o8_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `qw0o8_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1) AND `c`.`access` IN (:preparedArray2) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` = :categoryId 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 (:preparedArray3,:preparedArray4)
451μs4.6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:197CopySELECT `m`.`tag_id`,`t`.*
FROM `qw0o8_contentitem_tag_map` AS `m`
INNER JOIN `qw0o8_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)
306μs3.95KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT `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 `qw0o8_categories` AS `s`
INNER JOIN `qw0o8_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
583μs3.97KBParams/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 qw0o8_fields AS a
LEFT JOIN `qw0o8_languages` AS l ON l.lang_code = a.language
LEFT JOIN qw0o8_users AS uc ON uc.id=a.checked_out
LEFT JOIN qw0o8_viewlevels AS ag ON ag.id = a.access
LEFT JOIN qw0o8_users AS ua ON ua.id = a.created_user_id
LEFT JOIN qw0o8_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `qw0o8_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,:preparedArray4)) AND `a`.`access` IN (:preparedArray5)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6)) 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
441μs4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT created_by, catid
FROM qw0o8_content
WHERE id = 58
150μs592B/plugins/attachments/attachments_for_content/attachments_for_content.php:818CopySELECT a.*, u.name as creator_name
FROM qw0o8_attachments AS a
LEFT JOIN qw0o8_users AS u ON u.id = a.created_by
WHERE a.parent_id=58 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1)
ORDER BY filename
257μs2.98KB/components/com_attachments/src/Model/AttachmentsModel.php:435CopySELECT created_by, catid
FROM qw0o8_content
WHERE id = 23
111μs592B/plugins/attachments/attachments_for_content/attachments_for_content.php:818CopySELECT a.*, u.name as creator_name
FROM qw0o8_attachments AS a
LEFT JOIN qw0o8_users AS u ON u.id = a.created_by
WHERE a.parent_id=23 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1)
ORDER BY filename
219μs2.98KB/components/com_attachments/src/Model/AttachmentsModel.php:435CopySELECT 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 qw0o8_fields AS a
LEFT JOIN `qw0o8_languages` AS l ON l.lang_code = a.language
LEFT JOIN qw0o8_users AS uc ON uc.id=a.checked_out
LEFT JOIN qw0o8_viewlevels AS ag ON ag.id = a.access
LEFT JOIN qw0o8_users AS ua ON ua.id = a.created_user_id
LEFT JOIN qw0o8_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`a`.`context` = :context AND `a`.`access` IN (:preparedArray1)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray2)) 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
389μs4.03KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `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 `qw0o8_categories` AS `s`
INNER JOIN `qw0o8_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
591μs3.97KBParams/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 qw0o8_fields AS a
LEFT JOIN `qw0o8_languages` AS l ON l.lang_code = a.language
LEFT JOIN qw0o8_users AS uc ON uc.id=a.checked_out
LEFT JOIN qw0o8_viewlevels AS ag ON ag.id = a.access
LEFT JOIN qw0o8_users AS ua ON ua.id = a.created_user_id
LEFT JOIN qw0o8_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `qw0o8_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,:preparedArray4)) AND `a`.`access` IN (:preparedArray5)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6)) 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
366μs4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT created_by, catid
FROM qw0o8_content
WHERE id = 30
152μs592B/plugins/attachments/attachments_for_content/attachments_for_content.php:818CopySELECT a.*, u.name as creator_name
FROM qw0o8_attachments AS a
LEFT JOIN qw0o8_users AS u ON u.id = a.created_by
WHERE a.parent_id=30 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1)
ORDER BY filename
191μs2.98KB/components/com_attachments/src/Model/AttachmentsModel.php:435CopySELECT 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 qw0o8_fields AS a
LEFT JOIN `qw0o8_languages` AS l ON l.lang_code = a.language
LEFT JOIN qw0o8_users AS uc ON uc.id=a.checked_out
LEFT JOIN qw0o8_viewlevels AS ag ON ag.id = a.access
LEFT JOIN qw0o8_users AS ua ON ua.id = a.created_user_id
LEFT JOIN qw0o8_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`a`.`context` = :context AND `a`.`access` IN (:preparedArray1)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray2)) 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
372μs6.53KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT id
FROM qw0o8_categories
WHERE description='<p>We search the whole countryside for the best fruit growers.</p>\r\n<p><em>You can let each supplier have a page that he or she can edit. To see this in action you will need to create a user who is in the suppliers group. </em></p>\r\n<p><em>Create one page in the growers category for that user and make that supplier the author of the page. That user will be able to edit his or her page. </em></p>\r\n<p><em>This illustrates the use of the Edit Own permission. </em></p>' LIMIT 1
136μs536B/plugins/content/attachments/attachments.php:195CopySELECT id
FROM qw0o8_categories
WHERE id = 30 LIMIT 1
129μs536B/plugins/attachments/attachments_for_content/attachments_for_content.php:798CopySELECT a.*, u.name as creator_name
FROM qw0o8_attachments AS a
LEFT JOIN qw0o8_users AS u ON u.id = a.created_by
WHERE a.parent_id=30 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='category' AND a.access IN (1)
ORDER BY filename
205μs2.98KB/components/com_attachments/src/Model/AttachmentsModel.php:435CopySELECT `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 `qw0o8_categories` AS `s`
INNER JOIN `qw0o8_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
573μs3.97KBParams/libraries/src/Categories/Categories.php:375CopySELECT `language`,`id`
FROM `qw0o8_menu`
WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0
315μs592B/libraries/src/Language/Multilanguage.php:123CopySELECT `c2`.`language`,`c2`.`id`
FROM `qw0o8_menu` AS `c`
INNER JOIN `qw0o8_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `qw0o8_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `qw0o8_menu` AS `c2` ON `a2`.`id` = `c2`.`id`
WHERE `c`.`id` = :id
229μs1.37KBParams/libraries/src/Language/Associations.php:145CopySELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
FROM `qw0o8_categories` AS `c`
INNER JOIN `qw0o8_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `qw0o8_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `qw0o8_categories` AS `c2` ON `a2`.`id` = `c2`.`id` AND c2.extension = :extension1
WHERE `c`.`id` = :id AND `c`.`extension` = :extension3
182μs1.42KBParams/libraries/src/Language/Associations.php:145CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `qw0o8_modules` AS `m`
LEFT JOIN `qw0o8_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `qw0o8_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)) 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 (:preparedArray2,:preparedArray3)
ORDER BY `m`.`position`,`m`.`ordering`
1.2ms2.03KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT 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 qw0o8_fields AS a
LEFT JOIN `qw0o8_languages` AS l ON l.lang_code = a.language
LEFT JOIN qw0o8_users AS uc ON uc.id=a.checked_out
LEFT JOIN qw0o8_viewlevels AS ag ON ag.id = a.access
LEFT JOIN qw0o8_users AS ua ON ua.id = a.created_user_id
LEFT JOIN qw0o8_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`a`.`context` = :context AND `a`.`access` IN (:preparedArray1)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray2)) 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
377μs4.03KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT 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 `qw0o8_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
235μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517CopySELECT `session_id`
FROM `qw0o8_session`
WHERE `session_id` = ?
145μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `qw0o8_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
10.27ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy