Creating Packages Offline

To create packages offline you must prepare a CSV file. It can be imported as Learning Package by using the data exchange function of the program. How you can import will be explained in the section about data exchange.

General structure of the CSV file:

  1. Each cardfile occupies an own input line
  2. Exactly the first cardfile of each lesson / sublesson is signed with the name of those lesson / sublesson
  3. Delimiter between the items is the semicolon. Single entries of a cardfile must not contain a semicolon or newline character.
  4. To make semicolon / newline in Question / Answer usable, the following "Entity References" can be used: {semi} for a semicolon, {newline} for a line break.
  5. The whole file must be encoded in UTF-8 code.

A single line is structured as follows:

Column Content
1 Lesson name for the first cardfile of a lesson, empty for successors
2 Sublesson name for the first cardfile of a sublesson, empty for successors
3 Empty
4 Question of the cardfile
5 Answer of the cardfile
6

Empty or a reference to a sound file in mp3 format (relative to csv file), intended for the pronounciation of foreign vocables

A sample file will be provided here . It contains 3 lessons from a English - German - Learning Package.

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.

Ok
24.731MBMemory Usage1.27sRequest Duration
Joomla! Version5.2.3
PHP Version8.2.28
Identityguest
Response200
Templateallrounder
Database
Server
mysql
Version
8.0.36
Collation
utf8mb4_general_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
array:1 [ "start" => "5" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:46 [ "REDIRECT_STATUS" => "200" "UNIQUE_ID" => "Z_FMFNY6UuuL3_tG_1wUtgAADnk" "SCRIPT_URL...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743866900 "last" => 1743866900...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-GB" ]
plg_system_webauthn
array:1 [ "returnUrl" => "https://juergen.habelt-jena.de/en/programming-projects/cardbox-e-learnin...
gtag
false
  • afterLoad (3.69MB) (86.02ms)
  • afterInitialise (8.47MB) (273ms)
  • afterRoute (1.05MB) (36.63ms)
  • beforeRenderComponent com_content (768.75KB) (41.36ms)
  • Before Access::preloadComponents (all components) (1.25MB) (29.34ms)
  • After Access::preloadComponents (all components) (134.63KB) (6.13ms)
  • Before Access::preloadPermissions (com_content) (424B) (24μs)
  • After Access::preloadPermissions (com_content) (47.25KB) (2.47ms)
  • Before Access::getAssetRules (id:128 name:com_content.article.22) (1.15KB) (27μs)
  • After Access::getAssetRules (id:128 name:com_content.article.22) (25.65KB) (1.37ms)
  • afterRenderComponent com_content (3.37MB) (210ms)
  • Before Access::getAssetRules (id:8 name:com_content) (354.09KB) (16.69ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.27KB) (50μs)
  • afterDispatch (44.55KB) (12.96ms)
  • beforeRenderRawModule mod_languages (Language Switcher) (2.58MB) (336ms)
  • afterRenderRawModule mod_languages (Language Switcher) (284.54KB) (17.33ms)
  • beforeRenderModule mod_languages (Language Switcher) (704B) (14μs)
  • afterRenderModule mod_languages (Language Switcher) (19.14KB) (2.85ms)
  • beforeRenderRawModule mod_custom (GTranslate - en) (1.16KB) (30μs)
  • afterRenderRawModule mod_custom (GTranslate - en) (8.48KB) (3.43ms)
  • beforeRenderModule mod_custom (GTranslate - en) (720B) (6μs)
  • afterRenderModule mod_custom (GTranslate - en) (3.15KB) (393μs)
  • beforeRenderRawModule mod_articles_popular (Most Popular Articles) (1.92KB) (27μs)
  • afterRenderRawModule mod_articles_popular (Most Popular Articles) (300.6KB) (22.7ms)
  • beforeRenderModule mod_articles_popular (Most Popular Articles) (720B) (12μs)
  • afterRenderModule mod_articles_popular (Most Popular Articles) (4.05KB) (486μs)
  • beforeRenderRawModule mod_login (Login Form) (464B) (37μs)
  • afterRenderRawModule mod_login (Login Form) (268.5KB) (19.63ms)
  • beforeRenderModule mod_login (Login Form) (720B) (8μs)
  • afterRenderModule mod_login (Login Form) (10.29KB) (694μs)
  • beforeRenderRawModule mod_finder (Smart Search) (5.51KB) (112μs)
  • afterRenderRawModule mod_finder (Smart Search) (479.23KB) (33.35ms)
  • beforeRenderModule mod_finder (Smart Search) (720B) (9μs)
  • afterRenderModule mod_finder (Smart Search) (13.6KB) (3.48ms)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.37KB) (89μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (30.84KB) (3.91ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (5μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.49KB) (320μs)
  • beforeRenderRawModule mod_menu (Main Menu - EN) (1.02KB) (68μs)
  • afterRenderRawModule mod_menu (Main Menu - EN) (374.34KB) (19.45ms)
  • beforeRenderModule mod_menu (Main Menu - EN) (720B) (9μs)
  • afterRenderModule mod_menu (Main Menu - EN) (15.07KB) (2.52ms)
  • afterRender (601.25KB) (80.14ms)
  • 1 x beforeRenderRawModule mod_languages (Language Switcher) (2.58MB) (26.54%)
    336ms
    1 x afterInitialise (8.47MB) (21.59%)
    273ms
    1 x afterRenderComponent com_content (3.37MB) (16.57%)
    210ms
    1 x afterLoad (3.69MB) (6.79%)
    86.02ms
    1 x afterRender (601.25KB) (6.33%)
    80.14ms
    1 x beforeRenderComponent com_content (768.75KB) (3.27%)
    41.36ms
    1 x afterRoute (1.05MB) (2.89%)
    36.63ms
    1 x afterRenderRawModule mod_finder (Smart Search) (479.23KB) (2.63%)
    33.35ms
    1 x Before Access::preloadComponents (all components) (1.25MB) (2.32%)
    29.34ms
    1 x afterRenderRawModule mod_articles_popular (Most Popular Articles) (300.6KB) (1.79%)
    22.70ms
    1 x afterRenderRawModule mod_login (Login Form) (268.5KB) (1.55%)
    19.63ms
    1 x afterRenderRawModule mod_menu (Main Menu - EN) (374.34KB) (1.54%)
    19.45ms
    1 x afterRenderRawModule mod_languages (Language Switcher) (284.54KB) (1.37%)
    17.33ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (354.09KB) (1.32%)
    16.69ms
    1 x afterDispatch (44.55KB) (1.02%)
    12.96ms
    1 x After Access::preloadComponents (all components) (134.63KB) (0.48%)
    6.13ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (30.84KB) (0.31%)
    3.91ms
    1 x afterRenderModule mod_finder (Smart Search) (13.6KB) (0.27%)
    3.48ms
    1 x afterRenderRawModule mod_custom (GTranslate - en) (8.48KB) (0.27%)
    3.43ms
    1 x afterRenderModule mod_languages (Language Switcher) (19.14KB) (0.23%)
    2.85ms
    1 x afterRenderModule mod_menu (Main Menu - EN) (15.07KB) (0.2%)
    2.52ms
    1 x After Access::preloadPermissions (com_content) (47.25KB) (0.2%)
    2.47ms
    1 x After Access::getAssetRules (id:128 name:com_content.article.22) (25.65KB) (0.11%)
    1.37ms
    1 x afterRenderModule mod_login (Login Form) (10.29KB) (0.05%)
    694μs
    1 x afterRenderModule mod_articles_popular (Most Popular Articles) (4.05KB) (0.04%)
    486μs
    1 x afterRenderModule mod_custom (GTranslate - en) (3.15KB) (0.03%)
    393μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.49KB) (0.03%)
    320μs
    1 x beforeRenderRawModule mod_finder (Smart Search) (5.51KB) (0.01%)
    112μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.37KB) (0.01%)
    89μs
    1 x beforeRenderRawModule mod_menu (Main Menu - EN) (1.02KB) (0.01%)
    68μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.27KB) (0%)
    50μs
    1 x beforeRenderRawModule mod_login (Login Form) (464B) (0%)
    37μs
    1 x beforeRenderRawModule mod_custom (GTranslate - en) (1.16KB) (0%)
    30μs
    1 x Before Access::getAssetRules (id:128 name:com_content.article.22) (1.15KB) (0%)
    27μs
    1 x beforeRenderRawModule mod_articles_popular (Most Popular Articles) (1.92KB) (0%)
    27μs
    1 x Before Access::preloadPermissions (com_content) (424B) (0%)
    24μs
    1 x beforeRenderModule mod_languages (Language Switcher) (704B) (0%)
    14μs
    1 x beforeRenderModule mod_articles_popular (Most Popular Articles) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_finder (Smart Search) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_menu (Main Menu - EN) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_login (Login Form) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (GTranslate - en) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    5μs
140 statements were executed, 5 of which were duplicates, 135 unique214ms573.73KB
  • SELECT @@SESSION.sql_mode;909μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?1ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 1996μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)4.44ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`1.03ms976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `jos_usergroups` AS `a` LEFT JOIN `jos_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest1.21ms1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `jos_menu` AS `m` LEFT JOIN `jos_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`4.59ms84.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `jos_template_styles` AS `s` LEFT JOIN `jos_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` = 11.26ms864B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_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,:preparedArray45,:preparedArray46)2.58ms8.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.25ms3.23KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`5.56ms1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '22'6.04ms48B/libraries/src/Table/Table.php:1348Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jos_content` AS `a` INNER JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jos_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jos_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)2.63ms22.19KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `jos_categories` AS `s` INNER JOIN `jos_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`1.75ms4.02KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_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)1.66ms3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `jos_categories` AS `s` INNER JOIN `jos_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`1.39ms4.02KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id LEFT JOIN `jos_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,:preparedArray5)) AND `a`.`access` IN (:preparedArray6,:preparedArray7)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray8,:preparedArray9)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray10,:preparedArray11) ORDER BY a.ordering ASC2ms6.12KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `jos_content` AS `a` LEFT JOIN `jos_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 `a`.`ordering`1.42ms1.77KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • SELECT `language`,`id` FROM `jos_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 01.46ms624B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `jos_content` AS `c` INNER JOIN `jos_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `jos_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `jos_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `jos_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:28:20') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-04-05 15:28:20') AND c2.state = 11.78ms1.48KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `jos_categories` AS `s` INNER JOIN `jos_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`3.49ms4.02KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params AS extra, 0 AS menuid, m.publish_up, m.publish_down FROM jos_modules AS m LEFT JOIN jos_extensions AS e ON e.element = m.module AND e.client_id = m.client_id LEFT JOIN jos_advancedmodules as am ON am.module_id = m.id WHERE m.published = 1 AND e.enabled = 1 AND m.client_id = 0 ORDER BY m.position, m.ordering3.48ms178.17KB/plugins/system/advancedmodules/src/Helper.php:199Copy
  • SELECT m.condition_id,m.item_id FROM jos_conditions_map as m LEFT JOIN jos_conditions as c ON c.id = m.condition_id WHERE `m`.`extension` = 'com_advancedmodules' AND `c`.`published` = 11.15ms1.19KB/administrator/components/com_conditions/src/Model/ItemModel.php:831Copy
  • SHOW FULL COLUMNS FROM `jos_conditions`2.34ms1.45KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '16'1.3ms1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 161.06ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 8915μs832B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 16 ORDER BY m.extension,m.item_id995μs704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT `id`,`title` AS `value` FROM `jos_modules`1.17ms2.06KB/administrator/components/com_conditions/src/Helper/Helper.php:184Copy
  • SHOW FULL COLUMNS FROM `jos_modules`2.16ms1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT `id`,`published` AS `value` FROM `jos_modules`2.34ms2.06KB/administrator/components/com_conditions/src/Helper/Helper.php:184Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '17'1.13ms1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 17990μs3.19KB/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 91.04ms848B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 17 ORDER BY m.extension,m.item_id1.02ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '29'1.09ms1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 292.23ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 18997μs832B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 29 ORDER BY m.extension,m.item_id990μs704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '28'1.04ms1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 281.03ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 171.01ms832B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 28 ORDER BY m.extension,m.item_id1.47ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '35'938μs1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 35937μs704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 302.39ms832B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 35 ORDER BY m.extension,m.item_id1.08ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '3'1.3ms1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 31ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 234.82ms832B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 3 ORDER BY m.extension,m.item_id986μs704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '23'986μs1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 23998μs704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 14995μs832B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 23 ORDER BY m.extension,m.item_id1.08ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '22'959μs1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 221.18ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 13961μs832B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 22 ORDER BY m.extension,m.item_id1.08ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '25'940μs1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 253.99ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 281.32ms832B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 25 ORDER BY m.extension,m.item_id1.15ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '27'1.88ms1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 27999μs11.67KB/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 27 ORDER BY m.extension,m.item_id952μs704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '21'931μs1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 21915μs688B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 21 ORDER BY m.extension,m.item_id930μs704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '10'2.54ms1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 10952μs704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 32961μs848B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 10 ORDER BY m.extension,m.item_id956μs704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '15'1.06ms1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 153.39ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 71.71ms848B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 15 ORDER BY m.extension,m.item_id939μs704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '30'1.39ms1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 301.88ms688B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 30 ORDER BY m.extension,m.item_id1.35ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '34'1.24ms1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 341.4ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 291.02ms832B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 34 ORDER BY m.extension,m.item_id1.22ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '12'955μs1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 12990μs704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 311.19ms832B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 12 ORDER BY m.extension,m.item_id1.11ms720B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '24'953μs1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 24889μs704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 331.51ms848B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 24 ORDER BY m.extension,m.item_id899μs704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '14'1.13ms1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 141.3ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 35951μs848B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 14 ORDER BY m.extension,m.item_id1.05ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '19'1.11ms1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 191.07ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 34928μs848B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 19 ORDER BY m.extension,m.item_id3.05ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '13'2.92ms1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 131.02ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 5909μs832B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 13 ORDER BY m.extension,m.item_id1.12ms720B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '26'901μs1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 261.03ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 26961μs848B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 26 ORDER BY m.extension,m.item_id1.2ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '18'934μs1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 18920μs704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 10909μs848B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 18 ORDER BY m.extension,m.item_id959μs704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '2'895μs1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 21.71ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 11.04ms848B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 2 ORDER BY m.extension,m.item_id885μs704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '20'1.09ms1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 201.33ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 123.97ms832B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 20 ORDER BY m.extension,m.item_id919μs704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT * FROM `jos_conditions` WHERE `id` = '11'958μs1.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM jos_conditions_groups as g WHERE g.condition_id = 111.1ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:1049Copy
  • SELECT * FROM jos_conditions_rules as r WHERE r.group_id = 3938μs832B/administrator/components/com_conditions/src/Model/GroupModel.php:108Copy
  • SELECT m.extension,m.item_id,m.table,m.name_column FROM jos_conditions_map as m WHERE m.condition_id = 11 ORDER BY m.extension,m.item_id1.04ms704B/administrator/components/com_conditions/src/Model/ItemModel.php:917Copy
  • SELECT `c2`.`language`,`c2`.`id` FROM `jos_menu` AS `c` INNER JOIN `jos_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `jos_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `jos_menu` AS `c2` ON `a2`.`id` = `c2`.`id` WHERE `c`.`id` = :id1.09ms1.41KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `jos_content` AS `a` LEFT JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jos_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `jos_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jos_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.hits DESC LIMIT 52.96ms55.08KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `jos_categories` AS `s` INNER JOIN `jos_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`1.99ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `jos_categories` AS `s` INNER JOIN `jos_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`1.51ms4KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `jos_categories` AS `s` INNER JOIN `jos_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`1.44ms12KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `jos_categories` AS `s` INNER JOIN `jos_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`1.51ms4KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 11.8ms656B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `jos_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)1.31ms584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT a.params FROM jos_advancedmodules AS a WHERE a.module_id = 106926μs520B/plugins/system/advancedmodules/src/Helper.php:159Copy
  • SELECT a.params FROM jos_advancedmodules AS a WHERE a.module_id = 100976μs520B/plugins/system/advancedmodules/src/Helper.php:159Copy
  • SELECT * FROM `jos_schemaorg` WHERE `itemId` = :itemId AND `context` = :context1.45ms1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:403Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jos_content` AS `a` INNER JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jos_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jos_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)2.3ms22.23KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jos_content` AS `a` INNER JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jos_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jos_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)1.97ms22.23KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `jos_scheduler_tasks` AS `a` WHERE `a`.`state` = 11.15ms1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?1.02ms1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?4.41ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy