Query Time: 0.83 ms Query memory: 0.048 MB Memory before query: 0.933 MB Rows returned: 80
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions`
WHERE `type` = 'component'
EXPLAIN not possible on query: SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions`
WHERE `type` = 'component'
| Status | Duration |
|---|
| starting | 0.07 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| executing | 0.31 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
Query Time: 0.44 ms After last query: 0.49 ms Query memory: 0.021 MB Memory before query: 0.997 MB Rows returned: 1
SELECT b.id
FROM joom_usergroups AS a
LEFT JOIN joom_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
EXPLAIN not possible on query: SELECT b.id
FROM joom_usergroups AS a
LEFT JOIN joom_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 1
| Status | Duration |
|---|
| starting | 0.06 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.03 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
Query Time: 0.44 ms After last query: 1.38 ms Query memory: 0.021 MB Memory before query: 1.306 MB Rows returned: 1
SELECT *
FROM `axs_brands`
WHERE language = 'en-GB'
AND (FIND_IN_SET('stg.tovuti.io', domains) > 0)
LIMIT 1
EXPLAIN not possible on query: SELECT * FROM `axs_brands` WHERE language = 'en-GB' AND (FIND_IN_SET('stg.tovuti.io', domains) > 0) LIMIT 1
| Status | Duration |
|---|
| starting | 0.06 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.02 ms |
| executing | 0.05 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
Query Time: 0.52 ms After last query: 0.12 ms Query memory: 0.029 MB Memory before query: 1.327 MB Rows returned: 20
SELECT *
FROM joom_languages
WHERE published = 1
ORDER BY `title`
EXPLAIN not possible on query: SELECT * FROM joom_languages WHERE published = 1 ORDER BY `title`
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.02 ms |
| executing | 0.18 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
Query Time: 0.35 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 1.367 MB Rows returned: 1
SELECT *
FROM axs_domains
WHERE domain = 'stg.tovuti.io'
EXPLAIN not possible on query: SELECT * FROM axs_domains WHERE domain = 'stg.tovuti.io'
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.04 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
Query Time: 0.38 ms After last query: 1.14 ms Query memory: 0.021 MB Memory before query: 1.676 MB Rows returned: 1
SELECT *
FROM `axs_homepage_templates`
WHERE id = '1'
EXPLAIN not possible on query: SELECT * FROM `axs_homepage_templates` WHERE id = '1'
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.00 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.03 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
Query Time: 0.34 ms After last query: 0.15 ms Query memory: 0.021 MB Memory before query: 1.716 MB Rows returned: 1
SELECT *
FROM `axs_dashboard_templates`
WHERE id = '2'
EXPLAIN not possible on query: SELECT * FROM `axs_dashboard_templates` WHERE id = '2'
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
Query Time: 0.31 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 1.744 MB Rows returned: 1
SELECT *
FROM axs_email_settings
WHERE id = '1'
EXPLAIN not possible on query: SELECT *
FROM axs_email_settings
WHERE id = '1'
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
Query Time: 0.31 ms After last query: 0.15 ms Query memory: 0.021 MB Memory before query: 1.752 MB Rows returned: 1
SELECT *
FROM axs_payment_gateways
WHERE id = '1'
EXPLAIN not possible on query: SELECT *
FROM axs_payment_gateways
WHERE id = '1'
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
Query Time: 0.33 ms After last query: 0.15 ms Query memory: 0.021 MB Memory before query: 1.763 MB Rows returned: 1
SELECT *
FROM axs_integrations
WHERE id = '1'
EXPLAIN not possible on query: SELECT *
FROM axs_integrations
WHERE id = '1'
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
Query Time: 0.35 ms After last query: 0.73 ms Query memory: 0.021 MB Memory before query: 1.904 MB Rows returned: 7
SELECT id, rules
FROM `joom_viewlevels`
EXPLAIN not possible on query: SELECT id, rules
FROM `joom_viewlevels`
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.02 ms |
| executing | 0.05 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
Query Time: 1.97 ms After last query: 0.23 ms Query memory: 0.046 MB Memory before query: 1.931 MB Rows returned: 143
SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM joom_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
EXPLAIN not possible on query: SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM joom_extensions
WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1)
ORDER BY ordering
| Status | Duration |
|---|
| starting | 0.05 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.03 ms |
| executing | 1.46 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.00 ms |
Query Time: 0.56 ms After last query: 2.67 ms Query memory: 0.024 MB Memory before query: 2.540 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions`
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| starting | 0.07 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.09 ms |
| preparing | 0.02 ms |
| executing | 0.04 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 ms |
Query Time: 0.44 ms After last query: 0.19 ms Query memory: 0.006 MB Memory before query: 2.531 MB
UPDATE `joom_extensions`
SET `params` = '{\"mediaversion\":\"aff8f2ed8d8543a3032f2ef2680c5cca\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `joom_extensions`
SET `params` = '{\"mediaversion\":\"aff8f2ed8d8543a3032f2ef2680c5cca\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| starting | 0.04 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.07 ms |
| updating | 0.05 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
Query Time: 0.81 ms After last query: 8.99 ms Query memory: 0.029 MB Memory before query: 3.233 MB Rows returned: 20
SELECT *
FROM joom_languages
WHERE published=1
ORDER BY ordering ASC
EXPLAIN not possible on query: SELECT *
FROM joom_languages
WHERE published=1
ORDER BY ordering ASC
| Status | Duration |
|---|
| starting | 0.10 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.07 ms |
| init | 0.01 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.03 ms |
| executing | 0.18 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.03 ms |
| closing tables | 0.04 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
Query Time: 0.80 ms After last query: 0.25 ms Query memory: 0.030 MB Memory before query: 3.274 MB Rows returned: 96
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `joom_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1
EXPLAIN not possible on query: SELECT `element`,`name`,`client_id`,`extension_id`
FROM `joom_extensions`
WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1
| Status | Duration |
|---|
| starting | 0.05 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| executing | 0.37 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
Query Time: 1.71 ms After last query: 2.88 ms Query memory: 0.102 MB Memory before query: 3.499 MB Rows returned: 88
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, 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,e.element as component
FROM joom_menu AS m
LEFT JOIN joom_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
EXPLAIN not possible on query: SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, 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,e.element as component
FROM joom_menu AS m
LEFT JOIN joom_extensions AS e ON m.component_id = e.extension_id
WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0
ORDER BY m.lft
| Status | Duration |
|---|
| starting | 0.11 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.05 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.04 ms |
| executing | 1.15 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
Query Time: 1.82 ms After last query: 5.04 ms Query memory: 0.028 MB Memory before query: 3.890 MB Rows returned: 19
SHOW FULL COLUMNS
FROM `joom_users`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `joom_users`
| Status | Duration |
|---|
| starting | 0.08 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.50 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.09 ms |
| preparing | 0.03 ms |
| Creating tmp table | 0.05 ms |
| executing | 0.10 ms |
| checking permissions | 0.07 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.06 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.01 ms |
Query Time: 0.38 ms After last query: 0.30 ms Query memory: 0.022 MB Memory before query: 3.987 MB Rows returned: 1
SELECT `id`,`title`
FROM `joom_usergroups`
WHERE `id` = 1
EXPLAIN not possible on query: SELECT `id`,`title`
FROM `joom_usergroups`
WHERE `id` = 1
| Status | Duration |
|---|
| starting | 0.05 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
Query Time: 0.30 ms After last query: 5.34 ms Query memory: 0.020 MB Memory before query: 4.000 MB Rows returned: 0
SELECT params
FROM axs_user_settings
WHERE id = 1
EXPLAIN not possible on query: SELECT params
FROM axs_user_settings
WHERE id = 1
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
Query Time: 0.37 ms After last query: 0.33 ms Query memory: 0.019 MB Memory before query: 4.025 MB Rows returned: 0
SELECT *
FROM `joom_users`
WHERE `id` = 15
EXPLAIN not possible on query: SELECT *
FROM `joom_users`
WHERE `id` = 15
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
Query Time: 0.61 ms After last query: 0.34 ms Query memory: 0.019 MB Memory before query: 4.035 MB Rows returned: 6
SELECT id, home, template, s.params
FROM joom_template_styles as s
LEFT JOIN joom_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
EXPLAIN not possible on query: SELECT id, home, template, s.params
FROM joom_template_styles as s
LEFT JOIN joom_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
| Status | Duration |
|---|
| starting | 0.05 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.03 ms |
| executing | 0.12 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
Query Time: 10.17 ms After last query: 6.52 ms Query memory: 0.064 MB Memory before query: 4.442 MB Rows returned: 757
SHOW TABLES
EXPLAIN not possible on query: SHOW TABLES
| Status | Duration |
|---|
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.06 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.07 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.06 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.07 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.05 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.22 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.03 ms |
| closing tables | 0.02 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.02 ms |
Query Time: 1.97 ms After last query: 0.65 ms Query memory: 0.033 MB Memory before query: 4.524 MB Rows returned: 30
SHOW FULL COLUMNS
FROM `joom_splms_lessons`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `joom_splms_lessons`
| Status | Duration |
|---|
| starting | 0.06 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.48 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.09 ms |
| preparing | 0.03 ms |
| Creating tmp table | 0.05 ms |
| executing | 0.09 ms |
| checking permissions | 0.07 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.07 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.01 ms |
Query Time: 0.46 ms After last query: 0.63 ms Query memory: 0.023 MB Memory before query: 4.583 MB Rows returned: 1
SELECT joom_splms_lessons.*
FROM joom_splms_lessons
WHERE `joom_splms_lessons`.`splms_lesson_id` = '15'
EXPLAIN not possible on query: SELECT joom_splms_lessons.*
FROM joom_splms_lessons
WHERE `joom_splms_lessons`.`splms_lesson_id` = '15'
| Status | Duration |
|---|
| starting | 0.06 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| executing | 0.03 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.00 ms |
Query Time: 1.22 ms After last query: 1.27 ms Query memory: 0.031 MB Memory before query: 4.693 MB Rows returned: 63
SELECT `id`,`name`,`rules`,`parent_id`
FROM `joom_assets`
WHERE `name` IN ('com_accessibility','com_admin','com_advpoll','com_affiliate','com_ajax','com_associations','com_award','com_axs','com_banners','com_bigbluebutton','com_board','com_cache','com_categories','com_checkin','com_community','com_config','com_contact','com_contactpage','com_content','com_contenthistory','com_contracts','com_converge','com_cpanel','com_dashboard','com_dbmanager','com_demo','com_domains','com_dump','com_easyblog','com_eshop','com_eventbooking','com_fields','com_finder','com_improved_ajax_login','com_installer','com_interactivecontent','com_invitex','com_jbusinessdirectory','com_jce','com_joomlaupdate','com_jumi','com_kunena','com_languages','com_lifeboard','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_notifications','com_offlajn_installer','com_osmembership','com_permissioning','com_plugins','com_postinstall','com_redirect','com_reports','com_rsticketspro','com_saas','com_scheduler','com_search','com_splms','com_tags','com_templates','com_uniterevolution','com_uniterevolution2','com_uniteshowbiz','com_user_view','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0
EXPLAIN not possible on query: SELECT `id`,`name`,`rules`,`parent_id`
FROM `joom_assets`
WHERE `name` IN ('com_accessibility','com_admin','com_advpoll','com_affiliate','com_ajax','com_associations','com_award','com_axs','com_banners','com_bigbluebutton','com_board','com_cache','com_categories','com_checkin','com_community','com_config','com_contact','com_contactpage','com_content','com_contenthistory','com_contracts','com_converge','com_cpanel','com_dashboard','com_dbmanager','com_demo','com_domains','com_dump','com_easyblog','com_eshop','com_eventbooking','com_fields','com_finder','com_improved_ajax_login','com_installer','com_interactivecontent','com_invitex','com_jbusinessdirectory','com_jce','com_joomlaupdate','com_jumi','com_kunena','com_languages','com_lifeboard','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_notifications','com_offlajn_installer','com_osmembership','com_permissioning','com_plugins','com_postinstall','com_redirect','com_reports','com_rsticketspro','com_saas','com_scheduler','com_search','com_splms','com_tags','com_templates','com_uniterevolution','com_uniterevolution2','com_uniteshowbiz','com_user_view','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0
| Status | Duration |
|---|
| starting | 0.09 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.07 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.25 ms |
| preparing | 0.03 ms |
| executing | 0.45 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.02 ms |
Query Time: 0.45 ms After last query: 0.94 ms Query memory: 0.024 MB Memory before query: 4.812 MB Rows returned: 1
SELECT *
FROM axs_lms_settings
WHERE id=1
LIMIT 1
EXPLAIN not possible on query: SELECT *
FROM axs_lms_settings
WHERE id=1 LIMIT 1
| Status | Duration |
|---|
| starting | 0.05 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.03 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
Query Time: 0.53 ms After last query: 1.33 ms Query memory: 0.023 MB Memory before query: 4.926 MB Rows returned: 1
SELECT *
FROM `joom_splms_teachers`
WHERE `enabled`='1'
AND `splms_teacher_id`='1'
ORDER BY ordering DESC
EXPLAIN not possible on query: SELECT *
FROM `joom_splms_teachers`
WHERE `enabled`='1' AND `splms_teacher_id`='1'
ORDER BY ordering DESC
| Status | Duration |
|---|
| starting | 0.06 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.01 ms |
Query Time: 0.75 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 4.936 MB Rows returned: 0
SELECT `id`
FROM `joom_menu`
WHERE `link` LIKE '%option=com_splms&view=teachers%'
AND `published` = '1'
EXPLAIN not possible on query: SELECT `id`
FROM `joom_menu`
WHERE `link` LIKE '%option=com_splms&view=teachers%' AND `published` = '1'
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| executing | 0.40 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
Query Time: 0.59 ms After last query: 0.36 ms Query memory: 0.023 MB Memory before query: 4.945 MB Rows returned: 1
SELECT *
FROM `joom_splms_courses`
WHERE `enabled`='1'
AND `splms_course_id`='8'
AND (course_visible_before_open = 1 OR course_open_date IS NULL OR course_open_date = '0000-00-00' OR (DATE(NOW()) >= course_open_date))
AND (course_visible_after_close = 1 OR course_close_date IS NULL OR course_close_date = '0000-00-00' OR (DATE(NOW()) <= course_close_date))
AND ( ( access_type = 'access'
AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user'
AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list'
AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) )
ORDER BY ordering ASC
EXPLAIN not possible on query: SELECT *
FROM `joom_splms_courses`
WHERE `enabled`='1' AND `splms_course_id`='8' AND (course_visible_before_open = 1 OR course_open_date IS NULL OR course_open_date = '0000-00-00' OR (DATE(NOW()) >= course_open_date)) AND (course_visible_after_close = 1 OR course_close_date IS NULL OR course_close_date = '0000-00-00' OR (DATE(NOW()) <= course_close_date)) AND ( ( access_type = 'access' AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) )
ORDER BY ordering ASC
| Status | Duration |
|---|
| starting | 0.09 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.07 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.04 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| executing | 0.03 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
Query Time: 0.72 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 4.959 MB Rows returned: 2
SELECT `id`
FROM `joom_menu`
WHERE `link` LIKE '%option=com_splms&view=courses%'
AND `published` = '1'
EXPLAIN not possible on query: SELECT `id`
FROM `joom_menu`
WHERE `link` LIKE '%option=com_splms&view=courses%' AND `published` = '1'
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| executing | 0.38 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
Query Time: 0.34 ms After last query: 0.23 ms Query memory: 0.023 MB Memory before query: 4.975 MB Rows returned: 1
SELECT sef
FROM joom_languages
WHERE lang_code = 'en-GB'
LIMIT 1
EXPLAIN not possible on query: SELECT sef FROM joom_languages WHERE lang_code = 'en-GB' LIMIT 1
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
Query Time: 0.74 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 4.992 MB Rows returned: 1
SELECT params
FROM axs_lms_settings
WHERE id=1
LIMIT 1
EXPLAIN not possible on query: SELECT params
FROM axs_lms_settings
WHERE id=1 LIMIT 1
| Status | Duration |
|---|
| starting | 0.04 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
Query Time: 0.37 ms After last query: 6.33 ms Query memory: 0.025 MB Memory before query: 5.181 MB Rows returned: 1
SELECT id, rules
FROM `joom_viewlevels`
WHERE id = 1
EXPLAIN not possible on query: SELECT id, rules
FROM `joom_viewlevels`
WHERE id = 1
| Status | Duration |
|---|
| starting | 0.04 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
Query Time: 0.41 ms After last query: 0.07 ms Query memory: 0.026 MB Memory before query: 5.188 MB Rows returned: 1
SELECT *
FROM joom_splms_lessons
WHERE splms_lesson_id = '15'
EXPLAIN not possible on query: SELECT * FROM joom_splms_lessons WHERE splms_lesson_id = '15'
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
Query Time: 0.56 ms After last query: 0.09 ms Query memory: 0.026 MB Memory before query: 5.203 MB Rows returned: 1
SELECT *
FROM joom_splms_lessons
WHERE splms_course_id = 8
AND enabled = 1
AND language = 'fr-FR'
AND is_final_survey = 0
ORDER BY ordering ASC
EXPLAIN not possible on query: SELECT *
FROM joom_splms_lessons
WHERE splms_course_id = 8 AND enabled = 1 AND language = 'fr-FR' AND is_final_survey = 0
ORDER BY ordering ASC
| Status | Duration |
|---|
| starting | 0.04 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.08 ms |
| preparing | 0.03 ms |
| executing | 0.08 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
Query Time: 0.43 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 5.216 MB Rows returned: 0
SELECT *
FROM joom_splms_lessons
WHERE splms_course_id = 8
AND enabled = 1
AND language = 'fr-FR'
AND is_final_survey = 1
EXPLAIN not possible on query: SELECT *
FROM joom_splms_lessons
WHERE splms_course_id = 8 AND enabled = 1 AND language = 'fr-FR' AND is_final_survey = 1
| Status | Duration |
|---|
| starting | 0.04 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.00 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| executing | 0.04 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
Query Time: 0.49 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 5.223 MB Rows returned: 1
SELECT *
FROM joom_splms_lessons
WHERE splms_course_id = 8
AND enabled = 1
AND language = 'fr-FR'
AND is_final_survey = 0
ORDER BY ordering ASC
EXPLAIN not possible on query: SELECT *
FROM joom_splms_lessons
WHERE splms_course_id = 8 AND enabled = 1 AND language = 'fr-FR' AND is_final_survey = 0
ORDER BY ordering ASC
| Status | Duration |
|---|
| starting | 0.04 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.03 ms |
| executing | 0.07 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
Query Time: 0.47 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 5.236 MB Rows returned: 0
SELECT *
FROM joom_splms_lessons
WHERE splms_course_id = 8
AND enabled = 1
AND language = 'fr-FR'
AND is_final_survey = 1
EXPLAIN not possible on query: SELECT *
FROM joom_splms_lessons
WHERE splms_course_id = 8 AND enabled = 1 AND language = 'fr-FR' AND is_final_survey = 1
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| executing | 0.04 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.01 ms |
Query Time: 0.46 ms After last query: 0.26 ms Query memory: 0.026 MB Memory before query: 5.244 MB Rows returned: 0
SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e
ON e.id = ce.event_id
WHERE ce.course_id = 8
AND e.published = 1
ORDER BY event_date ASC
EXPLAIN not possible on query: SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 8 AND e.published = 1
ORDER BY event_date ASC
| Status | Duration |
|---|
| starting | 0.05 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.04 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.03 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.00 ms |
Query Time: 1.76 ms After last query: 0.37 ms Query memory: 0.030 MB Memory before query: 5.274 MB Rows returned: 21
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM joom_modules AS m
LEFT JOIN joom_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN joom_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.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-11-05 06:45:12')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-11-05 06:45:12')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 864 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.ordering
EXPLAIN not possible on query: SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM joom_modules AS m
LEFT JOIN joom_modules_menu AS mm ON mm.moduleid = m.id
LEFT JOIN joom_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.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-11-05 06:45:12') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-11-05 06:45:12') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 864 OR mm.menuid <= 0) AND m.language IN ('en-GB','*')
ORDER BY m.position, m.ordering
| Status | Duration |
|---|
| starting | 0.07 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.06 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.11 ms |
| preparing | 0.05 ms |
| executing | 1.15 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
Query Time: 0.45 ms After last query: 0.42 ms Query memory: 0.025 MB Memory before query: 5.297 MB Rows returned: 0
SELECT *
FROM `axs_course_purchases`
WHERE `user_id`=0
AND `course_id`=8
AND (status = 'PAID' OR status = 'PART' OR (status = 'REF'
AND access_retained = 1))
EXPLAIN not possible on query: SELECT *
FROM `axs_course_purchases`
WHERE `user_id`=0 AND `course_id`=8 AND (status = 'PAID' OR status = 'PART' OR (status = 'REF' AND access_retained = 1))
| Status | Duration |
|---|
| starting | 0.04 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
Query Time: 0.32 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 5.306 MB Rows returned: 0
SELECT `id`
FROM `axs_pay_subscriptions`
WHERE `user_id`=0
EXPLAIN not possible on query: SELECT `id`
FROM `axs_pay_subscriptions`
WHERE `user_id`=0
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
Query Time: 0.47 ms After last query: 0.15 ms Query memory: 0.026 MB Memory before query: 5.317 MB Rows returned: 1
SELECT *
FROM `joom_splms_courses`
WHERE `enabled`=1
AND `splms_course_id`=8
AND ( ( access_type = 'access'
AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user'
AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list'
AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) )
ORDER BY ordering ASC
EXPLAIN not possible on query: SELECT *
FROM `joom_splms_courses`
WHERE `enabled`=1 AND `splms_course_id`=8 AND ( ( access_type = 'access' AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) )
ORDER BY ordering ASC
| Status | Duration |
|---|
| starting | 0.06 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.05 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| executing | 0.03 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
Query Time: 0.46 ms After last query: 0.20 ms Query memory: 0.026 MB Memory before query: 5.327 MB Rows returned: 1
SELECT *
FROM `joom_splms_coursescategories`
WHERE `enabled`=1
AND `splms_coursescategory_id`=1
AND ( ( access_type = 'access'
AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user'
AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list'
AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) )
ORDER BY ordering ASC
EXPLAIN not possible on query: SELECT *
FROM `joom_splms_coursescategories`
WHERE `enabled`=1 AND `splms_coursescategory_id`=1 AND ( ( access_type = 'access' AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) )
ORDER BY ordering ASC
| Status | Duration |
|---|
| starting | 0.07 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.04 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
Query Time: 0.46 ms After last query: 1.78 ms Query memory: 0.025 MB Memory before query: 5.336 MB Rows returned: 0
SELECT *
FROM joom_splms_lesson_status
WHERE course_id = 8
AND lesson_id = 15
AND user_id = 0
AND language = 'en-GB'
AND status = 'completed'
AND archive_date IS NULL
LIMIT 1
EXPLAIN not possible on query: SELECT *
FROM joom_splms_lesson_status
WHERE course_id = 8 AND lesson_id = 15 AND user_id = 0 AND language = 'en-GB' AND status = 'completed' AND archive_date IS NULL LIMIT 1
| Status | Duration |
|---|
| starting | 0.05 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.08 ms |
| preparing | 0.02 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
Query Time: 0.38 ms After last query: 1.29 ms Query memory: 0.025 MB Memory before query: 5.390 MB Rows returned: 1
SELECT params, slug
FROM joom_splms_courses
WHERE `splms_course_id` = 8
EXPLAIN not possible on query: SELECT params, slug FROM joom_splms_courses WHERE `splms_course_id` = 8
| Status | Duration |
|---|
| starting | 0.04 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
Query Time: 0.50 ms After last query: 0.42 ms Query memory: 0.025 MB Memory before query: 5.508 MB Rows returned: 0
SELECT *
FROM assessment
LEFT JOIN assessment_quiz
ON assessment_quiz.assessment_id = assessment.id
WHERE enabled
AND type_id = 1
AND course_id = 8
AND lesson_id = 15
LIMIT 1
EXPLAIN not possible on query: SELECT *
FROM assessment
LEFT JOIN assessment_quiz ON assessment_quiz.assessment_id = assessment.id
WHERE enabled AND type_id = 1 AND course_id = 8 AND lesson_id = 15 LIMIT 1
| Status | Duration |
|---|
| starting | 0.06 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.04 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.03 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
Query Time: 0.37 ms After last query: 0.21 ms Query memory: 0.025 MB Memory before query: 5.516 MB Rows returned: 0
SELECT *
FROM `ratings_post`
WHERE `rating_id`='lesson_15'
EXPLAIN not possible on query: SELECT *
FROM `ratings_post`
WHERE `rating_id`='lesson_15'
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
Query Time: 0.45 ms After last query: 0.47 ms Query memory: 0.026 MB Memory before query: 5.535 MB Rows returned: 0
SELECT *
FROM joom_splms_student_activities
WHERE `course_id`=8
AND `lesson_id`=15
AND `user_id`=0
AND `activity_id` = '1656608990N4s4vI'
AND archive_date IS NULL
ORDER BY completed DESC
LIMIT 1
EXPLAIN not possible on query: SELECT *
FROM joom_splms_student_activities
WHERE `course_id`=8 AND `lesson_id`=15 AND `user_id`=0 AND `activity_id` = '1656608990N4s4vI' AND archive_date IS NULL
ORDER BY completed DESC LIMIT 1
| Status | Duration |
|---|
| starting | 0.05 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.02 ms |
| executing | 0.03 ms |
| end | 0.02 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
Query Time: 0.36 ms After last query: 0.63 ms Query memory: 0.028 MB Memory before query: 5.552 MB Rows returned: 1
SELECT *
FROM accessibility_videos
WHERE `path`='images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/istockphoto-1227495919-640_adpp_is.mp4'
AND enabled= 1
EXPLAIN not possible on query: SELECT *
FROM accessibility_videos
WHERE `path`='images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/istockphoto-1227495919-640_adpp_is.mp4' AND enabled= 1
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.00 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.04 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.00 ms |
Query Time: 0.38 ms After last query: 0.28 ms Query memory: 0.026 MB Memory before query: 5.561 MB Rows returned: 1
SELECT *
FROM `joom_splms_teachers`
WHERE `enabled`=1
AND `splms_teacher_id` IN (1)
ORDER BY ordering DESC
EXPLAIN not possible on query: SELECT *
FROM `joom_splms_teachers`
WHERE `enabled`=1 AND `splms_teacher_id` IN (1)
ORDER BY ordering DESC
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
Query Time: 0.47 ms After last query: 0.22 ms Query memory: 0.025 MB Memory before query: 5.598 MB Rows returned: 0
SELECT parent_id
FROM axs_learning_path_map
WHERE item_id = 8
AND item_type = 'course'
EXPLAIN not possible on query: SELECT parent_id
FROM axs_learning_path_map
WHERE item_id = 8 AND item_type = 'course'
| Status | Duration |
|---|
| starting | 0.05 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.00 ms |
Query Time: 0.78 ms After last query: 1.95 ms Query memory: 0.021 MB Memory before query: 5.521 MB Rows returned: 1
SELECT language,id
FROM `joom_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
EXPLAIN not possible on query: SELECT language,id
FROM `joom_menu`
WHERE home = 1 AND published = 1 AND client_id = 0
| Status | Duration |
|---|
| starting | 0.06 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| executing | 0.28 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
Query Time: 0.55 ms After last query: 4.64 ms Query memory: 0.023 MB Memory before query: 5.644 MB Rows returned: 10
SELECT *
FROM axs_fonts
WHERE enabled = 1
EXPLAIN not possible on query: SELECT * FROM axs_fonts WHERE enabled = 1
| Status | Duration |
|---|
| starting | 0.06 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| executing | 0.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
Query Time: 0.35 ms After last query: 0.20 ms Query memory: 0.022 MB Memory before query: 5.659 MB Rows returned: 0
SELECT *
FROM accessibility_images
WHERE `path`='images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png'
AND enabled= 1
EXPLAIN not possible on query: SELECT *
FROM accessibility_images
WHERE `path`='images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png' AND enabled= 1
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.00 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
Query Time: 0.45 ms After last query: 0.63 ms Query memory: 0.022 MB Memory before query: 5.664 MB Rows returned: 0
SELECT *
FROM axs_notifications
WHERE enabled = 1
AND DATE(start_date) <= NOW()
AND ( DATE(end_date) > NOW() OR end_date = 0 )
AND ( ( access_type = 'access'
AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user'
AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list'
AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' ) )
EXPLAIN not possible on query: SELECT * FROM axs_notifications WHERE enabled = 1 AND DATE(start_date) <= NOW() AND ( DATE(end_date) > NOW() OR end_date = 0 ) AND ( ( access_type = 'access' AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' ) )
| Status | Duration |
|---|
| starting | 0.07 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.05 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| executing | 0.03 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
Query Time: 0.52 ms After last query: 9.81 ms Query memory: 0.026 MB Memory before query: 5.844 MB Rows returned: 0
SELECT *
FROM joom_easyblog_configs
WHERE `name` = 'config'
EXPLAIN not possible on query: SELECT *
FROM joom_easyblog_configs
WHERE `name` = 'config'
| Status | Duration |
|---|
| starting | 0.07 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.03 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.02 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.00 ms |
Query Time: 1.49 ms After last query: 0.14 ms Query memory: 0.027 MB Memory before query: 5.891 MB Rows returned: 1
SELECT *
FROM joom_extensions
WHERE name='com_media'
EXPLAIN not possible on query: SELECT * FROM joom_extensions WHERE name='com_media'
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 1.15 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.00 ms |
Query Time: 0.40 ms After last query: 1.01 ms Query memory: 0.028 MB Memory before query: 5.907 MB Rows returned: 1
SELECT *
FROM joom_kunena_configuration
WHERE id=1
EXPLAIN not possible on query: SELECT * FROM joom_kunena_configuration WHERE id=1
| Status | Duration |
|---|
| starting | 0.04 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.00 ms |
Query Time: 0.55 ms After last query: 4.74 ms Query memory: 0.023 MB Memory before query: 6.065 MB Rows returned: 0
SELECT `c2`.`language`,`c2`.`id`
FROM `joom_menu` AS `c`
INNER JOIN `joom_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `joom_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `joom_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 864
EXPLAIN not possible on query: SELECT `c2`.`language`,`c2`.`id`
FROM `joom_menu` AS `c`
INNER JOIN `joom_associations` AS `a` ON a.id = c.`id` AND a.context='com_menus.item'
INNER JOIN `joom_associations` AS `a2` ON a.key = a2.key
INNER JOIN `joom_menu` AS `c2` ON a2.id = c2.`id`
WHERE c.id = 864
| Status | Duration |
|---|
| starting | 0.08 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.05 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.10 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
5 × SELECT *
FROM joom_splms_lessons
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions`
2 × SELECT *
FROM `joom_splms_courses`
2 × SELECT *
FROM joom_languages
2 × SELECT `id`
FROM `joom_menu`
2 × SELECT *
FROM `joom_splms_teachers`
1 × SELECT *
FROM assessment
LEFT JOIN assessment_quiz
ON assessment_quiz.assessment_id = assessment.id
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM joom_modules AS m
LEFT JOIN joom_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN joom_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT *
FROM `axs_course_purchases`
1 × SELECT `id`
FROM `axs_pay_subscriptions`
1 × SELECT *
FROM `joom_splms_coursescategories`
1 × SELECT *
FROM joom_splms_lesson_status
1 × SELECT params, slug
FROM joom_splms_courses
1 × SELECT *
FROM joom_splms_student_activities
1 × SELECT *
FROM `ratings_post`
1 × SELECT *
FROM accessibility_videos
1 × SELECT parent_id
FROM axs_learning_path_map
1 × SELECT language,id
FROM `joom_menu`
1 × SELECT *
FROM axs_fonts
1 × SELECT *
FROM accessibility_images
1 × SELECT *
FROM axs_notifications
1 × SELECT *
FROM joom_easyblog_configs
1 × SELECT *
FROM joom_extensions
1 × SELECT *
FROM joom_kunena_configuration
1 × SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e
ON e.id = ce.event_id
1 × SELECT sef
FROM joom_languages
1 × SELECT id, rules
FROM `joom_viewlevels`
1 × SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM joom_extensions
1 × SELECT *
FROM `axs_brands`
1 × SELECT *
FROM axs_domains
1 × SELECT *
FROM `axs_homepage_templates`
1 × SELECT *
FROM `axs_dashboard_templates`
1 × SELECT *
FROM axs_email_settings
1 × SELECT *
FROM axs_payment_gateways
1 × SELECT *
FROM axs_integrations
1 × SELECT id, rules
FROM `joom_viewlevels
1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `joom_extensions`
1 × SELECT params
FROM axs_lms_settings
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, 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,e.element as component
FROM joom_menu AS m
LEFT JOIN joom_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `id`,`title`
FROM `joom_usergroups`
1 × SELECT params
FROM axs_user_settings
1 × SELECT *
FROM `joom_users`
1 × SELECT id, home, template, s.params
FROM joom_template_styles as s
LEFT JOIN joom_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT joom_splms_lessons.*
FROM joom_splms_lessons
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `joom_assets`
1 × SELECT *
FROM axs_lms_settings
1 × SELECT b.id
FROM joom_usergroups AS a
LEFT JOIN joom_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `c2`.`language`,`c2`.`id`
FROM `joom_menu` AS `c`
INNER JOIN `joom_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `joom_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `joom_menu` AS `c2`
ON a2.id = c2.`id`