Query Time: 1.24 ms Query memory: 0.016 MB Memory before query: 0.660 MB Rows returned: 1
SELECT `data`
FROM `fmt_session`
WHERE `session_id` = 'p718m0bqhuptltfeioi85l5i57'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fmt_session | const | PRIMARY | PRIMARY | 602 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| After opening tables | 0.0 ms |
| System lock | 0.0 ms |
| table lock | 0.0 ms |
| init | 0.0 ms |
| Optimizing | 0.0 ms |
| Statistics | 0.1 ms |
| Preparing | 0.0 ms |
| Unlocking tables | 0.1 ms |
| Preparing | 0.0 ms |
| Executing | 0.0 ms |
| Sending data | 0.0 ms |
| End of update loop | 0.0 ms |
| Query end | 0.0 ms |
| Commit | 0.0 ms |
| Query end | 0.0 ms |
| closing tables | 0.0 ms |
| Unlocking tables | 0.0 ms |
| closing tables | 0.0 ms |
| Query end | 0.0 ms |
| Starting cleanup | 0.0 ms |
| Freeing items | 0.0 ms |
| Updating status | 0.1 ms |
| Reset for next command | 0.0 ms |
JROOT/libraries/joomla/session/storage/database.php:46
JROOT/libraries/joomla/session/session.php:654
JROOT/libraries/joomla/session/session.php:592
JROOT/libraries/legacy/application/application.php:982
JROOT/libraries/legacy/application/application.php:140
JROOT/includes/application.php:47
JROOT/libraries/legacy/application/application.php:175
JROOT/libraries/joomla/factory.php:104
JROOT/index.php:37
Query Time: 1.76 ms After last query: 6.13 ms Query memory: 0.012 MB Memory before query: 0.772 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM fmt_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fmt_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.2 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| After opening tables | 0.0 ms |
| System lock | 0.0 ms |
| table lock | 0.0 ms |
| init | 0.1 ms |
| Optimizing | 0.1 ms |
| Statistics | 0.2 ms |
| Preparing | 0.1 ms |
| Executing | 0.0 ms |
| Sending data | 0.1 ms |
| End of update loop | 0.1 ms |
| Query end | 0.0 ms |
| Commit | 0.0 ms |
| Query end | 0.0 ms |
| closing tables | 0.0 ms |
| Unlocking tables | 0.0 ms |
| closing tables | 0.0 ms |
| Query end | 0.0 ms |
| Starting cleanup | 0.0 ms |
| Freeing items | 0.0 ms |
| Updating status | 0.1 ms |
| Reset for next command | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/legacy/component/helper.php:384
JROOT/libraries/legacy/component/helper.php:43
JROOT/libraries/legacy/component/helper.php:91
JROOT/includes/application.php:63
JROOT/index.php:40
Query Time: 2.06 ms After last query: 3.41 ms Query memory: 0.010 MB Memory before query: 0.785 MB Rows returned: 39
SELECT folder AS type, element AS name, params
FROM fmt_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fmt_extensions | ALL | extension | NO INDEX KEY COULD BE USED | NULL | NULL | 131 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| After opening tables | 0.0 ms |
| System lock | 0.0 ms |
| table lock | 0.0 ms |
| init | 0.1 ms |
| Optimizing | 0.1 ms |
| Statistics | 0.1 ms |
| Preparing | 0.1 ms |
| Sorting result | 0.0 ms |
| Executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.6 ms |
| End of update loop | 0.0 ms |
| Query end | 0.0 ms |
| Commit | 0.1 ms |
| Query end | 0.0 ms |
| closing tables | 0.0 ms |
| Unlocking tables | 0.0 ms |
| closing tables | 0.0 ms |
| Query end | 0.0 ms |
| Starting cleanup | 0.0 ms |
| Freeing items | 0.0 ms |
| Updating status | 0.1 ms |
| Reset for next command | 0.0 ms |
JROOT/libraries/joomla/plugin/helper.php:280
JROOT/libraries/joomla/plugin/helper.php:165
JROOT/includes/application.php:69
JROOT/index.php:40
Query Time: 1.59 ms After last query: 1.56 ms Query memory: 0.012 MB Memory before query: 0.844 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM fmt_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fmt_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| After opening tables | 0.1 ms |
| System lock | 0.0 ms |
| table lock | 0.0 ms |
| init | 0.1 ms |
| Optimizing | 0.1 ms |
| Statistics | 0.2 ms |
| Preparing | 0.1 ms |
| Executing | 0.0 ms |
| Sending data | 0.1 ms |
| End of update loop | 0.0 ms |
| Query end | 0.0 ms |
| Commit | 0.0 ms |
| Query end | 0.0 ms |
| closing tables | 0.0 ms |
| Unlocking tables | 0.0 ms |
| closing tables | 0.0 ms |
| Query end | 0.0 ms |
| Starting cleanup | 0.0 ms |
| Freeing items | 0.0 ms |
| Updating status | 0.1 ms |
| Reset for next command | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/legacy/component/helper.php:384
JROOT/libraries/legacy/component/helper.php:43
JROOT/libraries/legacy/component/helper.php:91
JROOT/includes/application.php:116
JROOT/index.php:40
Query Time: 4.72 ms After last query: 23.41 ms Query memory: 0.028 MB Memory before query: 1.292 MB Rows returned: 44
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 fmt_menu AS m
LEFT JOIN fmt_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
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 48 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | fibermin_user.m.component_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| After opening tables | 0.0 ms |
| System lock | 0.0 ms |
| table lock | 0.0 ms |
| init | 0.1 ms |
| Optimizing | 0.1 ms |
| Statistics | 0.2 ms |
| Preparing | 0.1 ms |
| Sorting result | 0.0 ms |
| Executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 3.0 ms |
| End of update loop | 0.0 ms |
| Query end | 0.0 ms |
| Commit | 0.0 ms |
| Query end | 0.0 ms |
| closing tables | 0.0 ms |
| Unlocking tables | 0.0 ms |
| closing tables | 0.0 ms |
| Query end | 0.0 ms |
| Starting cleanup | 0.0 ms |
| Freeing items | 0.0 ms |
| Updating status | 0.1 ms |
| Reset for next command | 0.0 ms |
JROOT/libraries/cms/menu/site.php:45
JROOT/libraries/legacy/menu/menu.php:61
JROOT/libraries/legacy/menu/menu.php:113
JROOT/libraries/legacy/application/application.php:893
JROOT/includes/application.php:593
JROOT/libraries/cms/router/site.php:203
JROOT/libraries/joomla/application/router.php:182
JROOT/libraries/cms/router/site.php:83
JROOT/libraries/legacy/application/application.php:246
JROOT/includes/application.php:155
JROOT/index.php:46
Query Time: 1.25 ms After last query: 19.45 ms Query memory: 0.013 MB Memory before query: 2.061 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM fmt_extensions
WHERE `type` = 'component'
AND `element` = 'com_mailto'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fmt_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| After opening tables | 0.0 ms |
| System lock | 0.1 ms |
| table lock | 0.0 ms |
| init | 0.1 ms |
| Optimizing | 0.0 ms |
| Statistics | 0.1 ms |
| Preparing | 0.1 ms |
| Executing | 0.0 ms |
| Sending data | 0.1 ms |
| End of update loop | 0.1 ms |
| Query end | 0.0 ms |
| Commit | 0.0 ms |
| Query end | 0.0 ms |
| closing tables | 0.0 ms |
| Unlocking tables | 0.0 ms |
| closing tables | 0.0 ms |
| Query end | 0.0 ms |
| Starting cleanup | 0.0 ms |
| Freeing items | 0.0 ms |
| Updating status | 0.1 ms |
| Reset for next command | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/legacy/component/helper.php:384
JROOT/libraries/legacy/component/helper.php:43
JROOT/libraries/legacy/component/helper.php:91
JROOT/includes/application.php:373
JROOT/includes/application.php:177
JROOT/index.php:52
Query Time: 1.43 ms After last query: 1.83 ms Query memory: 0.011 MB Memory before query: 2.066 MB Rows returned: 1
SELECT *
FROM fmt_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fmt_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| After opening tables | 0.0 ms |
| System lock | 0.0 ms |
| table lock | 0.0 ms |
| init | 0.1 ms |
| Optimizing | 0.0 ms |
| Statistics | 0.0 ms |
| Preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| Executing | 0.0 ms |
| Sending data | 0.1 ms |
| Creating sort index | 0.2 ms |
| End of update loop | 0.0 ms |
| Query end | 0.0 ms |
| Commit | 0.1 ms |
| Query end | 0.0 ms |
| closing tables | 0.0 ms |
| Unlocking tables | 0.0 ms |
| closing tables | 0.0 ms |
| Query end | 0.0 ms |
| Starting cleanup | 0.0 ms |
| Freeing items | 0.0 ms |
| Updating status | 0.1 ms |
| Reset for next command | 0.0 ms |
JROOT/libraries/joomla/language/helper.php:159
JROOT/includes/application.php:381
JROOT/includes/application.php:177
JROOT/index.php:52
Query Time: 1.40 ms After last query: 0.78 ms Query memory: 0.013 MB Memory before query: 2.095 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM fmt_extensions
WHERE `type` = 'component'
AND `element` = 'com_menus'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fmt_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| After opening tables | 0.0 ms |
| System lock | 0.0 ms |
| table lock | 0.0 ms |
| init | 0.1 ms |
| Optimizing | 0.1 ms |
| Statistics | 0.1 ms |
| Preparing | 0.1 ms |
| Executing | 0.0 ms |
| Sending data | 0.1 ms |
| End of update loop | 0.0 ms |
| Query end | 0.0 ms |
| Commit | 0.0 ms |
| Query end | 0.1 ms |
| closing tables | 0.0 ms |
| Unlocking tables | 0.0 ms |
| closing tables | 0.0 ms |
| Query end | 0.0 ms |
| Starting cleanup | 0.0 ms |
| Freeing items | 0.0 ms |
| Updating status | 0.1 ms |
| Reset for next command | 0.1 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/legacy/component/helper.php:384
JROOT/libraries/legacy/component/helper.php:43
JROOT/libraries/legacy/component/helper.php:91
JROOT/includes/application.php:405
JROOT/includes/application.php:177
JROOT/index.php:52
Query Time: 1.52 ms After last query: 1.32 ms Query memory: 0.009 MB Memory before query: 2.098 MB Rows returned: 3
SELECT id, home, template, s.params
FROM fmt_template_styles as s
LEFT JOIN fmt_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
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | extension | 62 | const | 5 | Using index condition; Using where |
| 1 | SIMPLE | s | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| After opening tables | 0.0 ms |
| System lock | 0.0 ms |
| table lock | 0.0 ms |
| init | 0.1 ms |
| Optimizing | 0.1 ms |
| Statistics | 0.1 ms |
| Preparing | 0.1 ms |
| Executing | 0.0 ms |
| Sending data | 0.2 ms |
| End of update loop | 0.0 ms |
| Query end | 0.0 ms |
| Commit | 0.0 ms |
| Query end | 0.0 ms |
| closing tables | 0.0 ms |
| Unlocking tables | 0.0 ms |
| closing tables | 0.0 ms |
| Query end | 0.0 ms |
| Starting cleanup | 0.0 ms |
| Freeing items | 0.0 ms |
| Updating status | 0.1 ms |
| Reset for next command | 0.0 ms |
JROOT/includes/application.php:495
JROOT/libraries/legacy/component/helper.php:291
JROOT/includes/application.php:220
JROOT/index.php:52
Query Time: 5.54 ms After last query: 20.44 ms Query memory: 0.003 MB Memory before query: 2.340 MB
UPDATE `fmt_session`
SET `data` = '__default|a:10:{s:15:\"session.counter\";i:26;s:19:\"session.timer.start\";i:1761382147;s:18:\"session.timer.last\";i:1761382160;s:17:\"session.timer.now\";i:1761382160;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:1:{s:40:\"2e3bfdf3c9006f78aecce08aec131dd7093cd72b\";O:8:\"stdClass\":2:{s:4:\"link\";s:86:\"https://www.fibermind.com/index.php/brochures/fiber-optic/11-fiber-patch-cord-assembly\";s:6:\"expiry\";i:1761382150;}}s:19:\"com_mailto.formtime\";i:1761382160;s:13:\"session.token\";s:32:\"782f07a15f2413f348c1318dd8fdfaa7\";}'
, `time` = '1761382160'
WHERE `session_id` = 'p718m0bqhuptltfeioi85l5i57'
EXPLAIN not possible on query: UPDATE `fmt_session`
SET `data` = '__default|a:10:{s:15:\"session.counter\";i:26;s:19:\"session.timer.start\";i:1761382147;s:18:\"session.timer.last\";i:1761382160;s:17:\"session.timer.now\";i:1761382160;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:1:{s:40:\"2e3bfdf3c9006f78aecce08aec131dd7093cd72b\";O:8:\"stdClass\":2:{s:4:\"link\";s:86:\"https://www.fibermind.com/index.php/brochures/fiber-optic/11-fiber-patch-cord-assembly\";s:6:\"expiry\";i:1761382150;}}s:19:\"com_mailto.formtime\";i:1761382160;s:13:\"session.token\";s:32:\"782f07a15f2413f348c1318dd8fdfaa7\";}'
, `time` = '1761382160'
WHERE `session_id` = 'p718m0bqhuptltfeioi85l5i57'
| Status | Duration |
|---|
| Starting | 0.2 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| After opening tables | 0.0 ms |
| System lock | 0.0 ms |
| table lock | 0.0 ms |
| init for update | 0.1 ms |
| Updating | 0.4 ms |
| End of update loop | 0.0 ms |
| Query end | 0.0 ms |
| Commit | 4.1 ms |
| Query end | 0.0 ms |
| closing tables | 0.0 ms |
| Unlocking tables | 0.0 ms |
| closing tables | 0.0 ms |
| Query end | 0.0 ms |
| Starting cleanup | 0.0 ms |
| Freeing items | 0.1 ms |
| Updating status | 0.1 ms |
| Reset for next command | 0.0 ms |
JROOT/libraries/joomla/session/storage/database.php:85
4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM fmt_extensions
1 × SELECT id, home, template, s.params
FROM fmt_template_styles as s
LEFT JOIN fmt_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM fmt_languages
1 × SELECT folder AS type, element AS name, params
FROM fmt_extensions
1 × SELECT `data`
FROM `fmt_session`
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 fmt_menu AS m
LEFT JOIN fmt_extensions AS e
ON m.component_id = e.extension_id