|
Учебно-производственный кластер
«ПОРТ» (Профессия - Образование - Результат - Трудоустройство) |
|
|---|
Учебно-производственный кластер
«ПОРТ»
(Профессия - Образование - Результат - Трудоустройство)
МЕНЮ
Авторизация
© 2024. Кластер "ПОРТ".
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1727977207,
"last": 1727977207,
"now": 1727977207
},
"token": "pnCwaK7JZLEO8TD0OMwk8my0hQp5iFVE"
},
"registry": {
"com_installer": {
"message": "",
"extension_message": ""
}
},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Time
Memory
Time: 74.21 ms / 74.21 ms Memory: 0.701 MB / 1.07 MB Application: afterLoad
Time: 147.45 ms / 221.66 ms Memory: 1.178 MB / 2.25 MB Application: afterInitialise
Time: 33.00 ms / 254.66 ms Memory: 0.308 MB / 2.56 MB Application: afterRoute
Time: 9.78 ms / 264.45 ms Memory: 0.155 MB / 2.72 MB Application: beforeRenderComponent com_content
Time: 15.13 ms / 279.57 ms Memory: 0.129 MB / 2.85 MB Application: Before Access::preloadComponents (all components)
Time: 1.66 ms / 281.23 ms Memory: 0.051 MB / 2.90 MB Application: After Access::preloadComponents (all components)
Time: 0.03 ms / 281.26 ms Memory: 0.000 MB / 2.89 MB Application: Before Access::preloadPermissions (com_content)
Time: 0.59 ms / 281.86 ms Memory: 0.030 MB / 2.92 MB Application: After Access::preloadPermissions (com_content)
Time: 0.02 ms / 281.87 ms Memory: 0.000 MB / 2.92 MB Application: Before Access::getAssetRules (id:65 name:com_content.article.3)
Time: 1.41 ms / 283.29 ms Memory: 0.010 MB / 2.93 MB Application: After Access::getAssetRules (id:65 name:com_content.article.3)
Time: 72.92 ms / 356.21 ms Memory: 0.430 MB / 3.36 MB Application: afterRenderComponent com_content
Time: 1.46 ms / 357.67 ms Memory: 0.006 MB / 3.37 MB Application: afterDispatch
Time: 13.52 ms / 371.19 ms Memory: 0.051 MB / 3.42 MB Application: beforeRenderModule mod_login (Авторизация)
Time: 12.37 ms / 383.56 ms Memory: 0.099 MB / 3.52 MB Application: afterRenderModule mod_login (Авторизация)
Time: 0.19 ms / 383.74 ms Memory: 0.006 MB / 3.52 MB Application: beforeRenderModule mod_stmenu_plus (ST Nav Menu +)
Time: 9.90 ms / 393.64 ms Memory: 0.127 MB / 3.65 MB Application: afterRenderModule mod_stmenu_plus (ST Nav Menu +)
Time: 0.15 ms / 393.79 ms Memory: 0.000 MB / 3.64 MB Application: beforeRenderModule mod_search (Поиск)
Time: 2.71 ms / 396.50 ms Memory: 0.016 MB / 3.66 MB Application: afterRenderModule mod_search (Поиск)
Time: 237.42 ms / 633.92 ms Memory: 0.419 MB / 4.08 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Time: 0.09 ms / 634.01 ms Memory: 0.007 MB / 4.09 MB Application: After Access::getAssetRules (id:1 name:root.1)
Time: 120.33 ms / 754.34 ms Memory: 0.128 MB / 4.21 MB Application: afterRender
Database queries total: 24.43 ms
4.69 MB (4 918 496 Bytes)
41 Queries Logged 24.43 ms
- Query Time: 0.96 ms Query memory: 0.025 MB Memory before query: 1.479 MB Rows returned: 0
SELECT `data`
FROM `nhlwz_session`
WHERE `session_id` = X'6538356265323035663233363430343731613639346332626331393634353739'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE nhlwz_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.11 ms checking permissions 0.01 ms Opening tables 0.58 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms executing 0.02 ms end 0.00 ms query end 0.02 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.16 ms After last query: 2.83 ms Query memory: 0.022 MB Memory before query: 1.557 MB Rows returned: 0
SELECT `session_id`
FROM `nhlwz_session`
WHERE `session_id` = X'6538356265323035663233363430343731613639346332626331393634353739'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE nhlwz_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.40 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 1.563 MB
INSERT INTO `nhlwz_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6538356265323035663233363430343731613639346332626331393634353739', 1, 1727977207, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `nhlwz_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6538356265323035663233363430343731613639346332626331393634353739', 1, 1727977207, 0, '', 0)Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms update 0.12 ms end 0.00 ms query end 0.05 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 1.18 ms After last query: 11.10 ms Query memory: 0.030 MB Memory before query: 1.599 MB Rows returned: 34
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `nhlwz_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE nhlwz_extensions NULL ref extension extension 82 const 34 1.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.46 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms executing 0.00 ms Sending data 0.28 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.47 ms After last query: 6.12 ms Query memory: 0.023 MB Memory before query: 1.695 MB Rows returned: 6
SELECT id, rules
FROM `nhlwz_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE nhlwz_viewlevels NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.27 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.00 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.38 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 1.707 MB Rows returned: 2
SELECT b.id
FROM nhlwz_usergroups AS a
LEFT JOIN nhlwz_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.20 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.67 ms After last query: 2.33 ms Query memory: 0.033 MB Memory before query: 1.729 MB Rows returned: 75
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM nhlwz_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE nhlwz_extensions NULL ref extension extension 82 const 93 0.60 Using index condition; Using where; Using filesort Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.44 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:359 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.88 ms After last query: 62.57 ms Query memory: 0.041 MB Memory before query: 2.345 MB Rows returned: 19
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 nhlwz_menu AS m
LEFT JOIN nhlwz_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.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 20 3.33 Using index condition; Using where; Using filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 cherkasov_prt.m.component_id 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.33 ms init 0.03 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.27 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:491 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1073 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.37 ms After last query: 27.37 ms Query memory: 0.025 MB Memory before query: 2.644 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `nhlwz_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE nhlwz_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.00 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1130 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.31 ms After last query: 0.13 ms Query memory: 0.005 MB Memory before query: 2.634 MB
UPDATE `nhlwz_extensions`
SET `params` = '{\"mediaversion\":\"155493cf2ebc3497a5d0d7266084779c\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE nhlwz_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.07 ms updating 0.07 ms end 0.01 ms query end 0.06 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1130 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.65 ms After last query: 4.74 ms Query memory: 0.024 MB Memory before query: 2.670 MB Rows returned: 2
SELECT *
FROM nhlwz_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE nhlwz_languages NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 50.00 Using where; Using filesort Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.35 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.59 ms After last query: 0.25 ms Query memory: 0.021 MB Memory before query: 2.684 MB Rows returned: 3
SELECT id, home, template, s.params
FROM nhlwz_template_styles as s
LEFT JOIN nhlwz_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 = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ALL idx_template,idx_client_id,idx_client_id_home NO INDEX KEY COULD BE USED NULL NULL 5 60.00 Using where 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 403 cherkasov_prt.s.template,const 1 4.50 Using index condition; Using where Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.23 ms init 0.03 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.00 ms Sending data 0.08 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.43 ms After last query: 16.91 ms Query memory: 0.031 MB Memory before query: 2.849 MB Rows returned: 34
SELECT `id`,`name`,`rules`,`parent_id`
FROM `nhlwz_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE nhlwz_assets NULL ALL idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 87 40.23 Using where Status Duration starting 0.11 ms checking permissions 0.01 ms Opening tables 0.45 ms init 0.08 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.23 ms preparing 0.02 ms executing 0.00 ms Sending data 0.38 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 19 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 14 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:78 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.49 ms After last query: 0.16 ms Query memory: 0.030 MB Memory before query: 2.895 MB Rows returned: 27
SELECT `id`,`name`,`rules`,`parent_id`
FROM `nhlwz_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE nhlwz_assets NULL ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 87 25.71 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 ms executing 0.00 ms Sending data 0.18 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 19 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 14 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:78 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.45 ms After last query: 2.21 ms Query memory: 0.035 MB Memory before query: 2.941 MB Rows returned: 1
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,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as 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, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM nhlwz_content AS a
INNER JOIN nhlwz_categories AS c
on c.id = a.catid
LEFT JOIN nhlwz_users AS u
on u.id = a.created_by
LEFT JOIN nhlwz_categories as parent
ON parent.id = c.parent_id
LEFT JOIN nhlwz_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 3
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-03 17:40:07')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-03 17:40:07')
AND (a.state = 1 OR a.state =2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.23 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 1.47 ms init 0.15 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.19 ms preparing 0.02 ms executing 0.00 ms Sending data 0.07 ms end 0.00 ms query end 0.01 ms closing tables 0.06 ms freeing items 0.06 ms cleaning up 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.79 ms After last query: 8.51 ms Query memory: 0.033 MB Memory before query: 3.057 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `nhlwz_contentitem_tag_map` AS m
INNER JOIN `nhlwz_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 3
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 cherkasov_prt.m.tag_id 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.47 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.62 ms After last query: 18.09 ms Query memory: 0.038 MB Memory before query: 3.168 MB Rows returned: 2
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 `nhlwz_categories` AS `s`
INNER JOIN `nhlwz_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 2
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 2 60.00 Using index condition; Using where Status Duration starting 0.12 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.00 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.69 ms After last query: 1.17 ms Query memory: 0.037 MB Memory before query: 3.190 MB Rows returned: 0
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,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 nhlwz_fields AS a
LEFT JOIN `nhlwz_languages` AS l
ON l.lang_code = a.language
LEFT JOIN nhlwz_users AS uc
ON uc.id=a.checked_out
LEFT JOIN nhlwz_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN nhlwz_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN nhlwz_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `nhlwz_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (2,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; Using filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 cherkasov_prt.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 cherkasov_prt.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 cherkasov_prt.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 cherkasov_prt.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 cherkasov_prt.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 cherkasov_prt.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.13 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.77 ms init 0.07 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.03 ms Creating tmp table 0.05 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.21 ms Creating sort index 0.03 ms end 0.00 ms query end 0.01 ms removing tmp table 0.04 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.62 ms After last query: 7.78 ms Query memory: 0.027 MB Memory before query: 3.295 MB Rows returned: 15
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 nhlwz_content AS a
LEFT JOIN nhlwz_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 2
AND a.state = 1
AND a.access IN (1,1,5)
AND (a.state = 1 OR a.state = -1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-10-03 17:40:07')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-10-03 17:40:07')
ORDER BY
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 15 16.00 Using index condition; Using where; Using filesort 1 SIMPLE cc NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.04 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.23 ms end 0.01 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/plugins/content/pagenavigation/pagenavigation.php:161 14 PlgContentPagenavigation->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:199 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.95 ms After last query: 40.47 ms Query memory: 0.026 MB Memory before query: 3.419 MB Rows returned: 4
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM nhlwz_modules AS m
LEFT JOIN nhlwz_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN nhlwz_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 <= '2024-10-03 17:40:07')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-03 17:40:07')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 104 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref PRIMARY,published,newsfeeds published 1 const 10 4.76 Using index condition; Using where; Using filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 cherkasov_prt.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 cherkasov_prt.m.id 1 40.00 Using where; Using index Status Duration starting 0.07 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.41 ms init 0.04 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.15 ms end 0.00 ms query end 0.00 ms closing tables 0.04 ms freeing items 0.04 ms cleaning up 0.00 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:591 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/si-school-3/index.php:14 7 require JROOT/templates/si-school-3/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.17 ms After last query: 33.47 ms Query memory: 0.005 MB Memory before query: 3.681 MB
LOCK TABLES `nhlwz_extensions` WRITE
EXPLAIN not possible on query: LOCK TABLES `nhlwz_extensions` WRITEStatus Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.08 ms System lock 0.01 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver/mysqli.php:548 9 JDatabaseDriverMysqli->lockTable() JROOT/plugins/system/updatenotification/updatenotification.php:78 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.25 ms After last query: 0.07 ms Query memory: 0.004 MB Memory before query: 3.686 MB
UPDATE `nhlwz_extensions`
SET `params` = '{\"lastrun\":1727977207}'
WHERE `type` = 'plugin'
AND `folder` = 'system'
AND `element` = 'updatenotification'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE nhlwz_extensions NULL range element_clientid,element_folder_clientid,extension element_clientid 402 const 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.00 ms init 0.07 ms updating 0.06 ms end 0.00 ms query end 0.04 ms closing tables 0.00 ms freeing items 0.03 ms cleaning up 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/plugins/system/updatenotification/updatenotification.php:89 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.08 ms After last query: 4.68 ms Query memory: 0.005 MB Memory before query: 3.715 MB
UNLOCK TABLES
EXPLAIN not possible on query: UNLOCK TABLESStatus Duration starting 0.03 ms query end 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver/mysqli.php:923 9 JDatabaseDriverMysqli->unlockTables() JROOT/plugins/system/updatenotification/updatenotification.php:103 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.26 ms After last query: 3.02 ms Query memory: 0.024 MB Memory before query: 3.727 MB Rows returned: 1
SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query
FROM `nhlwz_update_sites` AS `a`
INNER JOIN nhlwz_update_sites_extensions AS b
ON a.update_site_id = b.update_site_id
WHERE a.enabled = 1
AND b.extension_id IN (700)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 3 33.33 Using where; Using temporary 1 SIMPLE b NULL eq_ref PRIMARY PRIMARY 8 cherkasov_prt.a.update_site_id,const 1 100.00 Using index; Distinct Status Duration starting 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.67 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms Creating tmp table 0.03 ms executing 0.00 ms Sending data 0.23 ms end 0.00 ms query end 0.01 ms removing tmp table 0.07 ms query end 0.00 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 11 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Updater/Updater.php:248 10 Joomla\CMS\Updater\Updater->getUpdateSites() JROOT/libraries/src/Updater/Updater.php:127 9 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.74 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 3.735 MB Rows returned: 2
SELECT DISTINCT update_site_id
FROM nhlwz_updates
WHERE `update_site_id` IN ( SELECT update_site_id
FROM nhlwz_update_sites
WHERE `last_check_timestamp` IS NULL OR `last_check_timestamp` <= '1727955607')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE nhlwz_update_sites NULL ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 3 55.56 Using where; Using temporary 1 SIMPLE nhlwz_updates NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 78 10.00 Using where; Using join buffer (Block Nested Loop) Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.29 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms Creating tmp table 0.02 ms executing 0.01 ms Sending data 0.22 ms end 0.00 ms query end 0.01 ms removing tmp table 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/libraries/src/Updater/Updater.php:426 10 Joomla\CMS\Updater\Updater->getSitesWithUpdates() JROOT/libraries/src/Updater/Updater.php:140 9 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.33 ms After last query: 0.09 ms Query memory: 0.005 MB Memory before query: 3.739 MB
DELETE
FROM `nhlwz_updates`
WHERE `update_site_id` = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 DELETE nhlwz_updates NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 78 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms updating 0.16 ms end 0.01 ms query end 0.04 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Updater/Updater.php:165 9 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.31 ms After last query: 4.22 ms Query memory: 0.024 MB Memory before query: 3.815 MB Rows returned: 1
SELECT `name`
FROM `nhlwz_update_sites`
WHERE `update_site_id` = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE nhlwz_update_sites NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/libraries/src/Updater/UpdateAdapter.php:195 13 Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteName() JROOT/libraries/src/Updater/UpdateAdapter.php:222 12 Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse() JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232 11 Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate() JROOT/libraries/src/Updater/Updater.php:286 10 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 9 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.31 ms After last query: 0.11 ms Query memory: 0.006 MB Memory before query: 3.822 MB
UPDATE `nhlwz_update_sites`
SET `enabled` = '0'
WHERE `update_site_id` = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE nhlwz_update_sites NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.03 ms updating 0.07 ms end 0.01 ms query end 0.05 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Updater/UpdateAdapter.php:160 13 Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite() JROOT/libraries/src/Updater/UpdateAdapter.php:245 12 Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse() JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232 11 Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate() JROOT/libraries/src/Updater/Updater.php:286 10 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 9 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.30 ms After last query: 194.97 ms Query memory: 0.006 MB Memory before query: 3.844 MB
UPDATE `nhlwz_update_sites`
SET `enabled` = '1'
WHERE `update_site_id` = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE nhlwz_update_sites NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.03 ms updating 0.08 ms end 0.01 ms query end 0.04 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Updater/UpdateAdapter.php:160 13 Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite() JROOT/libraries/src/Updater/UpdateAdapter.php:265 12 Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse() JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232 11 Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate() JROOT/libraries/src/Updater/Updater.php:286 10 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 9 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.52 ms After last query: 0.93 ms Query memory: 0.030 MB Memory before query: 3.853 MB Rows returned: 14
SHOW FULL COLUMNS
FROM `nhlwz_updates`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `nhlwz_updates`Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.15 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.01 ms checking permissions 0.03 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.00 ms checking permissions 0.01 ms Sending data 0.06 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.04 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 16 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Update.php:32 15 Joomla\CMS\Table\Update->__construct() JROOT/libraries/src/Table/Table.php:312 14 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:126 13 Joomla\CMS\Updater\Adapter\CollectionAdapter->_startElement() Same as call in the line below. 12 xml_parse() JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:243 11 Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate() JROOT/libraries/src/Updater/Updater.php:286 10 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 9 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.89 ms After last query: 4.24 ms Query memory: 0.030 MB Memory before query: 3.883 MB Rows returned: 18
SHOW FULL COLUMNS
FROM `nhlwz_extensions`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `nhlwz_extensions`Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.23 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.01 ms checking permissions 0.05 ms checking permissions 0.02 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.02 ms Sending data 0.13 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.07 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 15 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 14 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 13 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Extension.php:32 12 Joomla\CMS\Table\Extension->__construct() JROOT/libraries/src/Table/Table.php:312 11 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/Updater/Updater.php:330 10 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 9 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.40 ms After last query: 0.18 ms Query memory: 0.023 MB Memory before query: 3.924 MB Rows returned: 0
SELECT `update_id`
FROM `nhlwz_updates`
WHERE element = 'joomla'
AND type = 'file'
AND client_id = '0'
AND folder = ''id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE nhlwz_updates NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 78 1.28 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms executing 0.00 ms Sending data 0.12 ms end 0.00 ms query end 0.01 ms closing tables 0.07 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Update.php:114 11 Joomla\CMS\Table\Update->find() JROOT/libraries/src/Updater/Updater.php:338 10 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 9 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.36 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 3.936 MB Rows returned: 1
SELECT `extension_id`
FROM `nhlwz_extensions`
WHERE element = 'joomla'
AND type = 'file'
AND client_id = '0'
AND folder = ''id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE nhlwz_extensions NULL ref element_clientid,element_folder_clientid,extension extension 887 const,const,const,const 1 100.00 Using index Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 11 Joomla\CMS\Table\Extension->find() JROOT/libraries/src/Updater/Updater.php:348 10 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 9 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.20 ms After last query: 0.12 ms Query memory: 0.028 MB Memory before query: 3.944 MB Rows returned: 1
SELECT *
FROM nhlwz_extensions
WHERE `extension_id` = '700'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE nhlwz_extensions NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 12 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 11 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Updater/Updater.php:358 10 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 9 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.20 ms After last query: 0.19 ms Query memory: 0.005 MB Memory before query: 3.946 MB
INSERT INTO `nhlwz_updates` (`update_site_id`,`extension_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`)
VALUES ('1','700','Joomla','','joomla','file','','0','3.10.12','','https://update.joomla.org/core/extension.xml','','')EXPLAIN not possible on query: INSERT INTO `nhlwz_updates` (`update_site_id`,`extension_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`) VALUES ('1','700','Joomla','','joomla','file','','0','3.10.12','','https://update.joomla.org/core/extension.xml','','')Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms update 0.06 ms end 0.00 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1421 11 JDatabaseDriver->insertObject() JROOT/libraries/src/Table/Table.php:805 10 Joomla\CMS\Table\Table->store() JROOT/libraries/src/Updater/Updater.php:177 9 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.21 ms After last query: 0.09 ms Query memory: 0.005 MB Memory before query: 3.949 MB
UPDATE `nhlwz_update_sites`
SET `last_check_timestamp` = '1727977208'
WHERE `update_site_id` = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE nhlwz_update_sites NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.03 ms updating 0.05 ms end 0.01 ms query end 0.03 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Updater/Updater.php:455 10 Joomla\CMS\Updater\Updater->updateLastCheckTimestamp() JROOT/libraries/src/Updater/Updater.php:182 9 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.41 ms After last query: 4.65 ms Query memory: 0.027 MB Memory before query: 3.960 MB Rows returned: 1
SELECT u.*,`e`.`manifest_cache`
FROM `nhlwz_updates` AS `u`
LEFT JOIN `nhlwz_extensions` AS `e`
ON `e`.`extension_id` = `u`.`extension_id`
WHERE `u`.`extension_id` != '0'
AND `u`.`extension_id` = '700'
ORDER BY `u`.`name` asc
LIMIT 20id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE u NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 78 9.00 Using where; Using filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 cherkasov_prt.u.extension_id 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.12 ms end 0.00 ms query end 0.00 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 11 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_installer/models/update.php:217 10 InstallerModelUpdate->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 9 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/plugins/system/updatenotification/updatenotification.php:136 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.52 ms After last query: 7.64 ms Query memory: 0.027 MB Memory before query: 4.052 MB Rows returned: 8
SHOW FULL COLUMNS
FROM `nhlwz_assets`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `nhlwz_assets`Status Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.15 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.04 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 Sending data 0.05 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.05 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Asset.php:61 11 Joomla\CMS\Table\Asset->__construct() JROOT/libraries/src/Table/Table.php:312 10 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/system/updatenotification/updatenotification.php:297 9 PlgSystemUpdatenotification->getSuperUsers() JROOT/plugins/system/updatenotification/updatenotification.php:186 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.21 ms After last query: 0.16 ms Query memory: 0.023 MB Memory before query: 4.074 MB Rows returned: 1
SELECT id
FROM nhlwz_assets
WHERE parent_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE nhlwz_assets NULL ref idx_parent_id idx_parent_id 4 const 1 100.00 Using index Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/libraries/src/Table/Nested.php:1219 10 Joomla\CMS\Table\Nested->getRootId() JROOT/plugins/system/updatenotification/updatenotification.php:297 9 PlgSystemUpdatenotification->getSuperUsers() JROOT/plugins/system/updatenotification/updatenotification.php:186 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.51 ms After last query: 0.24 ms Query memory: 0.022 MB Memory before query: 4.086 MB Rows returned: 1
SELECT `user_id`
FROM `nhlwz_user_usergroup_map`
WHERE `group_id` IN('8')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE nhlwz_user_usergroup_map NULL index NULL PRIMARY 8 NULL 10 10.00 Using where; Using index Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.35 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/plugins/system/updatenotification/updatenotification.php:333 9 PlgSystemUpdatenotification->getSuperUsers() JROOT/plugins/system/updatenotification/updatenotification.php:186 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.19 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 4.092 MB Rows returned: 1
SELECT `id`,`username`,`email`
FROM `nhlwz_users`
WHERE `id` IN('981')
AND `block` = 0
AND `sendEmail` = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE nhlwz_users NULL const PRIMARY,idx_block PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/updatenotification/updatenotification.php:373 9 PlgSystemUpdatenotification->getSuperUsers() JROOT/plugins/system/updatenotification/updatenotification.php:186 8 PlgSystemUpdatenotification->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
39 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `nhlwz_extensions`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `nhlwz_assets`1 × SELECT `data`
FROM `nhlwz_session`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM nhlwz_modules AS m
LEFT JOIN nhlwz_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN nhlwz_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `user_id`
FROM `nhlwz_user_usergroup_map`1 × SELECT id
FROM nhlwz_assets1 × SELECT u.*,`e`.`manifest_cache`
FROM `nhlwz_updates` AS `u`
LEFT JOIN `nhlwz_extensions` AS `e`
ON `e`.`extension_id` = `u`.`extension_id`1 × SELECT *
FROM nhlwz_extensions1 × SELECT `extension_id`
FROM `nhlwz_extensions`1 × SELECT `update_id`
FROM `nhlwz_updates`1 × SELECT `name`
FROM `nhlwz_update_sites`1 × SELECT DISTINCT update_site_id
FROM nhlwz_updates1 × SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query
FROM `nhlwz_update_sites` AS `a`
INNER JOIN nhlwz_update_sites_extensions AS b
ON a.update_site_id = b.update_site_id1 × 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,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 nhlwz_fields AS a
LEFT JOIN `nhlwz_languages` AS l
ON l.lang_code = a.language
LEFT JOIN nhlwz_users AS uc
ON uc.id=a.checked_out
LEFT JOIN nhlwz_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN nhlwz_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN nhlwz_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `nhlwz_fields_categories` AS fc
ON fc.field_id = a.id1 × 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 nhlwz_content AS a
LEFT JOIN nhlwz_categories AS cc
ON cc.id = a.catid1 × SELECT `session_id`
FROM `nhlwz_session`1 × 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 `nhlwz_categories` AS `s`
INNER JOIN `nhlwz_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)1 × SELECT `m`.`tag_id`,`t`.*
FROM `nhlwz_contentitem_tag_map` AS m
INNER JOIN `nhlwz_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × 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,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as 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, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM nhlwz_content AS a
INNER JOIN nhlwz_categories AS c
on c.id = a.catid
LEFT JOIN nhlwz_users AS u
on u.id = a.created_by
LEFT JOIN nhlwz_categories as parent
ON parent.id = c.parent_id
LEFT JOIN nhlwz_content_rating AS v
ON a.id = v.content_id1 × SELECT id, home, template, s.params
FROM nhlwz_template_styles as s
LEFT JOIN nhlwz_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM nhlwz_languages1 × 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 nhlwz_menu AS m
LEFT JOIN nhlwz_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM nhlwz_extensions1 × SELECT b.id
FROM nhlwz_usergroups AS a
LEFT JOIN nhlwz_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `nhlwz_viewlevels1 × SELECT `id`,`username`,`email`
FROM `nhlwz_users`
OTHER Tables:
1 × INSERT INTO `nhlwz_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6538356265323035663233363430343731613639346332626331393634353739', 1, 1727977207, 0, '', 01 × UPDATE `nhlwz_extensions`
SET `params` = '{\"mediaversion\":\"155493cf2ebc3497a5d0d7266084779c\"}'1 × LOCK TABLES `nhlwz_extensions` WRIT
1 × UPDATE `nhlwz_extensions`
SET `params` = '{\"lastrun\":1727977207}'1 × UNLOCK TABLE
1 × DELETE
FROM `nhlwz_updates`1 × UPDATE `nhlwz_update_sites`
SET `enabled` = '0'1 × UPDATE `nhlwz_update_sites`
SET `enabled` = '1'1 × SHOW FULL COLUMNS
FROM `nhlwz_updates1 × SHOW FULL COLUMNS
FROM `nhlwz_extensions1 × INSERT INTO `nhlwz_updates` (`update_site_id`,`extension_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`)
VALUES ('1','700','Joomla','','joomla','file','','0','3.10.12','','https://update.joomla.org/core/extension.xml','',''1 × UPDATE `nhlwz_update_sites`
SET `last_check_timestamp` = '1727977208'1 × SHOW FULL COLUMNS
FROM `nhlwz_assets