Joomla! hibakereső konzol
{
"__default": {
"session": {
"counter": 7,
"timer": {
"start": 1787080958,
"last": 1787080975,
"now": 1787080978
},
"token": "cMp4QBdXBDZzT7GwCXTEuWXTvU2dpReK"
},
"registry": {
"mailto": {
"mailto": {
"form": {
"data": {
"link": "1e1cdf7b143c0adb741ba7f833cf7136693e4ae6",
"sender": "",
"subject": "",
"emailfrom": "",
"emailto": ""
}
}
}
}
},
"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
},
"com_mailto": {
"links": {
"31431a34671f0a6d30245a0dc495653348229c3d": {
"link": "https://www.infokapuvar.hu/helyi/item/390-kapuv%C3%A1ri-l%C3%A1nyok-kiemelten-aranyosak",
"expiry": 1787080958
},
"b2db157ce3a8e9e74d2992e18d0ad832dab08dd8": {
"link": "https://www.infokapuvar.hu/szakmunkaskepzo/item/225-kis-r%C3%A1ba-%C3%A1ruh%C3%A1z",
"expiry": 1787080965
},
"2f9d707ca314f10da9bbb2b42e7370da001428e3": {
"link": "https://www.infokapuvar.hu/sport/item/378-4-fordul%C3%B3-%C3%B6ttev%C3%A9ny-%E2%80%93-kapuv%C3%A1r-4%E2%80%930-1%E2%80%930",
"expiry": 1787080973
},
"da3dae952b9e28134dd1afb3cf4ff5f53918c2f9": {
"link": "https://www.infokapuvar.hu/szakmunkaskepzo/item/134-t%C3%B6rp-h%C3%B6rpint%C5%91?print=1&tmpl=component",
"expiry": 1787080976
},
"692c1cf0dbd0d8ba682176cc9256a77e330b81d1": {
"link": "https://www.infokapuvar.hu/szakmunkaskepzo/item/132-vaddiszn%C3%B3-kocsma?print=1&tmpl=component",
"expiry": 1787080979
}
}
}
}
}
Idő
Memória
Idő: 10.88 ms / 10.88 ms Memória: 0.407 MB / 0.75 MB Application: afterLoad
Idő: 141.39 ms / 152.27 ms Memória: 1.777 MB / 2.53 MB Application: Before Access::preloadComponents (all components)
Idő: 1.89 ms / 154.16 ms Memória: 0.065 MB / 2.59 MB Application: After Access::preloadComponents (all components)
Idő: 0.05 ms / 154.20 ms Memória: -0.004 MB / 2.59 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Idő: 1.15 ms / 155.36 ms Memória: 0.008 MB / 2.59 MB Application: After Access::getAssetRules (id:1 name:root.1)
Idő: 135.54 ms / 290.90 ms Memória: 0.596 MB / 3.19 MB Application: afterInitialise
Idő: 55.25 ms / 346.14 ms Memória: 0.298 MB / 3.49 MB Application: afterRoute
Idő: 1.56 ms / 347.71 ms Memória: 0.064 MB / 3.55 MB Application: beforeRenderComponent com_k2
Idő: 0.96 ms / 348.66 ms Memória: 0.019 MB / 3.57 MB Application: Before Access::getAssetRules (id:213 name:com_k2)
Idő: 0.04 ms / 348.70 ms Memória: 0.002 MB / 3.57 MB Application: After Access::getAssetRules (id:213 name:com_k2)
Idő: 121.95 ms / 470.65 ms Memória: 1.311 MB / 4.89 MB Application: afterRenderComponent com_k2
Idő: 3.04 ms / 473.69 ms Memória: 0.023 MB / 4.91 MB Application: afterDispatch
Idő: 10.10 ms / 483.79 ms Memória: 0.462 MB / 5.37 MB Application: afterRender
Adatbázislekérdezés összesen: 189.30 ms
6,47 MB (6.788.344 Bájtok)
98 naplózott lekérdezés 189.30 ms
38 duplikátum található!
- Lekérdezés ideje: 1.07 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 1.030 MB Visszaadott sorok: 1
SELECT `data`
FROM `slib0_session`
WHERE `session_id` = X'6566303335323738316333373130666564353833306535633365373863333530'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_session NULL const PRIMARY PRIMARY 766 const 1 100.00 NULL Status Duration starting 0.20 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.20 ms init 0.02 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.20 ms preparing 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.07 ms freeing items 0.03 ms cleaning up 0.00 ms # Hívó Fájl és sorok száma 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Ugyanaz a hívás, mint egy sorral lejjebb. 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:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 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:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:54 - Lekérdezés ideje: 1.54 ms Utolsó lekérdezés után: 1.64 ms Memória lekérdezése: 0.040 MB memória a lekérdezés előtt: 1.083 MB Visszaadott sorok: 48
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `slib0_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 slib0_extensions NULL ref extension extension 82 const 48 1.00 Using where Status Duration starting 0.12 ms Executing hook on transaction 0.11 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.16 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.07 ms executing 0.48 ms end 0.01 ms query end 0.03 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Hívó Fájl és sorok száma 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}() Ugyanaz a hívás, mint egy sorral lejjebb. 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.11 ms Utolsó lekérdezés után: 1.72 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.130 MB Visszaadott sorok: 5
SELECT id, rules
FROM `slib0_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_viewlevels NULL ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 5 100.00 NULL Status Duration starting 0.18 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.03 ms executing 0.15 ms end 0.04 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 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:318 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.81 ms Utolsó lekérdezés után: 0.22 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.142 MB Visszaadott sorok: 1
SELECT b.id
FROM slib0_usergroups AS a
LEFT JOIN slib0_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id 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 1 100.00 Using where; Using index Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.16 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.19 ms preparing 0.05 ms executing 0.05 ms end 0.04 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 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:318 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.68 ms Utolsó lekérdezés után: 0.49 ms Memória lekérdezése: 0.035 MB memória a lekérdezés előtt: 1.163 MB Visszaadott sorok: 130
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM slib0_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref extension extension 82 const 154 0.40 Using where; Fájlrendezés használata Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.04 ms executing 1.14 ms end 0.01 ms query end 0.02 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Ugyanaz a hívás, mint egy sorral lejjebb. 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:356 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.23 ms Utolsó lekérdezés után: 5.17 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 1.466 MB Visszaadott sorok: 1
SELECT `storage_value`
FROM `slib0_securitycheckpro_storage`
WHERE `storage_key` = 'pro_plugin'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_storage NULL const PRIMARY PRIMARY 767 const 1 100.00 NULL Status Duration starting 0.16 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.03 ms executing 0.04 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.04 ms freeing items 0.39 ms cleaning up 0.02 ms # Hívó Fájl és sorok száma 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/url_inspector/url_inspector.php:209 8 PlgSystemurl_Inspector->load() JROOT/plugins/system/url_inspector/url_inspector.php:60 7 PlgSystemurl_Inspector->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 2.02 ms Utolsó lekérdezés után: 13.18 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.004 MB Visszaadott sorok: 1Duplikált lekérdezések: #8
SELECT template
FROM slib0_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ref idx_client_id,idx_client_id_home idx_client_id 1 const 11 10.00 Using where Status Duration starting 0.21 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.40 ms init 0.07 ms System lock 0.04 ms optimizing 0.05 ms statistics 0.19 ms preparing 0.04 ms executing 0.27 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.24 ms closing tables 0.05 ms freeing items 0.11 ms cleaning up 0.03 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 12 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 11 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 10 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 9 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:95 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:53 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.25 ms Utolsó lekérdezés után: 0.20 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 2.011 MB Visszaadott sorok: 1Duplikált lekérdezések: #7
SELECT template
FROM slib0_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ref idx_client_id,idx_client_id_home idx_client_id 1 const 11 10.00 Using where Status Duration starting 0.21 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.02 ms Opening tables 0.16 ms init 0.03 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.17 ms preparing 0.05 ms executing 0.12 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.02 ms # Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 13 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 12 RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 11 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 10 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 9 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:95 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:53 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.04 ms Utolsó lekérdezés után: 3.43 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.125 MB Visszaadott sorok: 2
SELECT extension, file, type
FROM slib0_rokcommon_configs
ORDER BY priorityid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_rokcommon_configs NULL ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2 100.00 Fájlrendezés használata Status Duration starting 0.22 ms Executing hook on transaction 0.01 ms starting 0.03 ms checking permissions 0.01 ms Opening tables 0.13 ms init 0.01 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.03 ms preparing 0.04 ms executing 0.09 ms end 0.01 ms query end 0.02 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rokcommon/rokcommon.php:131 8 plgSystemRokCommon->processRegisteredConfigs() JROOT/plugins/system/rokcommon/rokcommon.php:75 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.28 ms Utolsó lekérdezés után: 3.19 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.154 MB Visszaadott sorok: 1
SELECT `storage_value`
FROM `slib0_securitycheckpro_storage`
WHERE `storage_key` = 'pro_plugin'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_storage NULL const PRIMARY PRIMARY 767 const 1 100.00 NULL Status Duration starting 0.32 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.02 ms Opening tables 0.08 ms init 0.02 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.03 ms executing 0.03 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/securitycheck_spam_protection/securitycheck_spam_protection.php:137 8 plgSystemSecuritycheck_spam_protection->load() JROOT/plugins/system/securitycheck_spam_protection/securitycheck_spam_protection.php:46 7 plgSystemSecuritycheck_spam_protection->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.12 ms Utolsó lekérdezés után: 0.42 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.176 MB Visszaadott sorok: 1
SELECT enabled
from `slib0_extensions`
WHERE element='securitycheck_spam_protection'
and type='plugin'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.19 ms Executing hook on transaction 0.02 ms starting 0.02 ms checking permissions 0.03 ms Opening tables 0.12 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.18 ms preparing 0.03 ms executing 0.09 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.03 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.05 ms # Hívó Fájl és sorok száma 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/plugins/system/securitycheck_spam_protection/securitycheck_spam_protection.php:70 7 plgSystemSecuritycheck_spam_protection->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 4.52 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.180 MB Visszaadott sorok: 1
SELECT count(*)
from `slib0_extensions`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL index NULL element_clientid 403 NULL 300 100.00 Using index Status Duration starting 0.06 ms Executing hook on transaction 0.02 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.04 ms executing 3.81 ms end 0.04 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.03 ms freeing items 0.08 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/plugins/system/securitycheck_spam_protection/securitycheck_spam_protection.php:80 7 plgSystemSecuritycheck_spam_protection->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.83 ms Utolsó lekérdezés után: 2.52 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.218 MB Visszaadott sorok: 1
SELECT `storage_value`
FROM `slib0_securitycheckpro_storage`
WHERE `storage_key` = 'pro_plugin'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_storage NULL const PRIMARY PRIMARY 767 const 1 100.00 NULL Status Duration starting 0.23 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Hívó Fájl és sorok száma 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/trackactions/trackactions.php:95 8 PlgSystemTrackActions->load() JROOT/plugins/system/trackactions/trackactions.php:45 7 PlgSystemTrackActions->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.65 ms Utolsó lekérdezés után: 0.27 ms Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 2.239 MB Visszaadott sorok: 1
SELECT extension_id
FROM slib0_extensions
WHERE element="com_securitycheckpro"
and type="component"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index Status Duration starting 0.46 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.03 ms Opening tables 0.10 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.24 ms preparing 0.04 ms executing 0.06 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 8 JDatabaseDriverMysqli->execute() JROOT/plugins/system/trackactions/trackactions.php:58 7 PlgSystemTrackActions->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.80 ms Utolsó lekérdezés után: 0.11 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.243 MB Visszaadott sorok: 1
SELECT extension_id
FROM slib0_extensions
WHERE element="com_securitycheckpro"
and type="component"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.02 ms Opening tables 0.10 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/plugins/system/trackactions/trackactions.php:59 7 PlgSystemTrackActions->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.17 ms Utolsó lekérdezés után: 0.90 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.254 MB Visszaadott sorok: 1
SELECT `storage_value`
FROM `slib0_securitycheckpro_storage`
WHERE `storage_key` = 'pro_plugin'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_storage NULL const PRIMARY PRIMARY 767 const 1 100.00 NULL Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.69 ms cleaning up 0.06 ms # Hívó Fájl és sorok száma 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/trackactions/trackactions.php:95 8 PlgSystemTrackActions->load() JROOT/plugins/system/trackactions/trackactions.php:45 7 PlgSystemTrackActions->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.52 ms Utolsó lekérdezés után: 0.32 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.278 MB Visszaadott sorok: 1
SELECT extension_id
FROM slib0_extensions
WHERE element="com_securitycheckpro"
and type="component"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index Status Duration starting 0.34 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.04 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.26 ms preparing 0.04 ms executing 0.08 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 8 JDatabaseDriverMysqli->execute() JROOT/plugins/system/trackactions/trackactions.php:58 7 PlgSystemTrackActions->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.56 ms Utolsó lekérdezés után: 0.26 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.282 MB Visszaadott sorok: 1
SELECT extension_id
FROM slib0_extensions
WHERE element="com_securitycheckpro"
and type="component"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.03 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.03 ms freeing items 0.16 ms cleaning up 0.02 ms # Hívó Fájl és sorok száma 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/plugins/system/trackactions/trackactions.php:59 7 PlgSystemTrackActions->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.83 ms Utolsó lekérdezés után: 0.71 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.355 MB Visszaadott sorok: 1
SELECT `storage_value`
FROM `slib0_securitycheckpro_storage`
WHERE `storage_key` = 'pro_plugin'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_storage NULL const PRIMARY PRIMARY 767 const 1 100.00 NULL Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/trackactions/trackactions.php:95 8 PlgSystemTrackActions->load() JROOT/plugins/system/trackactions/trackactions.php:45 7 PlgSystemTrackActions->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.74 ms Utolsó lekérdezés után: 0.55 ms Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 2.377 MB Visszaadott sorok: 1
SELECT extension_id
FROM slib0_extensions
WHERE element="com_securitycheckpro"
and type="component"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.15 ms preparing 0.03 ms executing 0.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.93 ms cleaning up 0.02 ms # Hívó Fájl és sorok száma 8 JDatabaseDriverMysqli->execute() JROOT/plugins/system/trackactions/trackactions.php:58 7 PlgSystemTrackActions->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.36 ms Utolsó lekérdezés után: 0.54 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.381 MB Visszaadott sorok: 1
SELECT extension_id
FROM slib0_extensions
WHERE element="com_securitycheckpro"
and type="component"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index Status Duration starting 0.16 ms Executing hook on transaction 0.02 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.28 ms preparing 0.07 ms executing 0.06 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/plugins/system/trackactions/trackactions.php:59 7 PlgSystemTrackActions->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.14 ms Utolsó lekérdezés után: 1.66 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.391 MB Visszaadott sorok: 1
SELECT `storage_value`
FROM `slib0_securitycheckpro_storage`
WHERE `storage_key` = 'pro_plugin'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_storage NULL const PRIMARY PRIMARY 767 const 1 100.00 NULL Status Duration starting 0.17 ms Executing hook on transaction 0.01 ms starting 0.04 ms checking permissions 0.03 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.04 ms executing 0.02 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.03 ms closing tables 0.03 ms freeing items 0.07 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/trackactions/trackactions.php:95 8 PlgSystemTrackActions->load() JROOT/plugins/system/trackactions/trackactions.php:45 7 PlgSystemTrackActions->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.41 ms Utolsó lekérdezés után: 0.70 ms Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 2.413 MB Visszaadott sorok: 1
SELECT extension_id
FROM slib0_extensions
WHERE element="com_securitycheckpro"
and type="component"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index Status Duration starting 0.11 ms Executing hook on transaction 0.04 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.17 ms preparing 0.03 ms executing 0.08 ms end 0.01 ms query end 0.28 ms waiting for handler commit 0.03 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 8 JDatabaseDriverMysqli->execute() JROOT/plugins/system/trackactions/trackactions.php:58 7 PlgSystemTrackActions->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.58 ms Utolsó lekérdezés után: 0.30 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.417 MB Visszaadott sorok: 1
SELECT extension_id
FROM slib0_extensions
WHERE element="com_securitycheckpro"
and type="component"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.03 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/plugins/system/trackactions/trackactions.php:59 7 PlgSystemTrackActions->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 7.19 ms Utolsó lekérdezés után: 12.98 ms Memória lekérdezése: 0.434 MB memória a lekérdezés előtt: 2.473 MB Visszaadott sorok: 8795
SELECT *
FROM slib0_securitycheckpro_blacklistid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_blacklist NULL index NULL PRIMARY 767 NULL 4612 100.00 Using index Status Duration starting 0.27 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.42 ms init 0.07 ms System lock 0.03 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.05 ms executing 5.30 ms end 0.05 ms query end 0.04 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 10 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_securitycheckpro/library/model.php:453 9 SecuritycheckproModel->chequear_ip_en_lista() JROOT/plugins/system/url_inspector/url_inspector.php:95 8 PlgSystemurl_Inspector->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 5.36 ms Utolsó lekérdezés után: 0.33 ms Memória lekérdezése: 0.435 MB memória a lekérdezés előtt: 2.478 MB Visszaadott sorok: 8795
SELECT *
FROM slib0_securitycheckpro_blacklistid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_blacklist NULL index NULL PRIMARY 767 NULL 4612 100.00 Using index Status Duration starting 0.15 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.01 ms System lock 0.04 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.03 ms executing 4.21 ms end 0.06 ms query end 0.01 ms waiting for handler commit 0.03 ms closing tables 0.05 ms freeing items 0.04 ms cleaning up 0.05 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_securitycheckpro/library/model.php:454 9 SecuritycheckproModel->chequear_ip_en_lista() JROOT/plugins/system/url_inspector/url_inspector.php:95 8 PlgSystemurl_Inspector->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.70 ms Utolsó lekérdezés után: 6.21 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.482 MB Visszaadott sorok: 1
SELECT enabled
from slib0_extensions
WHERE element='securitycheckpro'
and type='plugin'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.55 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.07 ms Opening tables 0.12 ms init 0.05 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.22 ms preparing 0.06 ms executing 0.15 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.02 ms # Hívó Fájl és sorok száma 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1931 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.87 ms Utolsó lekérdezés után: 0.14 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.487 MB Visszaadott sorok: 1
SELECT storage_value
from slib0_securitycheckpro_storage
WHERE storage_key = 'locked'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_storage NULL const PRIMARY PRIMARY 767 const 1 100.00 NULL Status Duration starting 0.20 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.02 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.05 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1941 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.81 ms Utolsó lekérdezés után: 0.24 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.494 MB Visszaadott sorok: 1
SELECT `storage_value`
FROM `slib0_securitycheckpro_storage`
WHERE `storage_key` = 'pro_plugin'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_storage NULL const PRIMARY PRIMARY 767 const 1 100.00 NULL Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms end 0.00 ms query end 0.05 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/administrator/components/com_securitycheckpro/library/model.php:247 10 SecuritycheckproModel->load() JROOT/administrator/components/com_securitycheckpro/library/model.php:207 9 SecuritycheckproModel->getValue() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1956 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.86 ms Utolsó lekérdezés után: 0.25 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.521 MB Visszaadott sorok: 1
SELECT `group_id`
FROM `slib0_user_usergroup_map`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_user_usergroup_map NULL index NULL PRIMARY 8 NULL 1 100.00 Using index Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.01 ms System lock 0.03 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.06 ms end 0.00 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.00 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:2565 9 plgSystemSecuritycheckpro->forbid_new_admins() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1978 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.64 ms Utolsó lekérdezés után: 0.26 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 2.533 MB Visszaadott sorok: 47
SELECT `id`,`name`,`rules`,`parent_id`
FROM `slib0_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_advportfoliopro','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_k2','com_k2import','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_quix','com_redirect','com_roksprocket','com_search','com_securitycheckpro','com_securitycheckproanalytics','com_sigpro','com_sppagebuilder','com_tags','com_tcpdf','com_templates','com_users','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_assets NULL range idx_asset_name idx_asset_name 202 NULL 49 100.00 Using index condition Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.31 ms preparing 0.05 ms executing 0.62 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 13 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 12 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 11 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:485 10 Joomla\CMS\Access\Access::checkGroup() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:2571 9 plgSystemSecuritycheckpro->forbid_new_admins() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1978 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 3.54 ms Utolsó lekérdezés után: 1.72 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.594 MB Visszaadott sorok: 1
SELECT count(id)
FROM slib0_usergroupsid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_usergroups NULL index NULL idx_usergroup_adjacency_lookup 4 NULL 9 100.00 Using index Status Duration starting 0.15 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.03 ms executing 2.68 ms end 0.04 ms query end 0.03 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/libraries/src/Helper/UserGroupsHelper.php:207 13 Joomla\CMS\Helper\UserGroupsHelper->total() JROOT/libraries/src/Helper/UserGroupsHelper.php:154 12 Joomla\CMS\Helper\UserGroupsHelper->getAll() JROOT/libraries/src/Access/Access.php:501 11 Joomla\CMS\Access\Access::getGroupPath() JROOT/libraries/src/Access/Access.php:485 10 Joomla\CMS\Access\Access::checkGroup() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:2571 9 plgSystemSecuritycheckpro->forbid_new_admins() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1978 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.12 ms Utolsó lekérdezés után: 0.43 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 2.607 MB Visszaadott sorok: 9
SELECT *
FROM slib0_usergroups
ORDER BY lft ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_usergroups NULL ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 9 100.00 Fájlrendezés használata Status Duration starting 0.15 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.04 ms executing 0.11 ms end 0.03 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.00 ms # Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/UserGroupsHelper.php:263 13 Joomla\CMS\Helper\UserGroupsHelper->loadAll() JROOT/libraries/src/Helper/UserGroupsHelper.php:156 12 Joomla\CMS\Helper\UserGroupsHelper->getAll() JROOT/libraries/src/Access/Access.php:501 11 Joomla\CMS\Access\Access::getGroupPath() JROOT/libraries/src/Access/Access.php:485 10 Joomla\CMS\Access\Access::checkGroup() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:2571 9 plgSystemSecuritycheckpro->forbid_new_admins() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1978 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.07 ms Utolsó lekérdezés után: 0.42 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.620 MB Visszaadott sorok: 1
SELECT COUNT(*)
from slib0_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 slib0_user_usergroup_map NULL index PRIMARY PRIMARY 8 NULL 1 100.00 Using where; Using index Status Duration starting 0.19 ms Executing hook on transaction 0.05 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.02 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.10 ms preparing 0.07 ms executing 0.09 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:2587 9 plgSystemSecuritycheckpro->forbid_new_admins() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1978 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.89 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.625 MB Visszaadott sorok: 1
SELECT contador
from slib0_securitycheckpro_users_control
WHERE id='1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_users_control NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.12 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.03 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:2598 9 plgSystemSecuritycheckpro->forbid_new_admins() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1978 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 4.89 ms Utolsó lekérdezés után: 0.16 ms Memória lekérdezése: 0.434 MB memória a lekérdezés előtt: 2.631 MB Visszaadott sorok: 8795
SELECT *
FROM slib0_securitycheckpro_blacklistid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_blacklist NULL index NULL PRIMARY 767 NULL 4612 100.00 Using index Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.02 ms executing 4.00 ms end 0.04 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.05 ms # Hívó Fájl és sorok száma 10 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_securitycheckpro/library/model.php:453 9 SecuritycheckproModel->chequear_ip_en_lista() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1985 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 8.02 ms Utolsó lekérdezés után: 0.27 ms Memória lekérdezése: 0.435 MB memória a lekérdezés előtt: 2.636 MB Visszaadott sorok: 8795
SELECT *
FROM slib0_securitycheckpro_blacklistid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_blacklist NULL index NULL PRIMARY 767 NULL 4612 100.00 Using index Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.03 ms executing 6.62 ms end 0.04 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.03 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_securitycheckpro/library/model.php:454 9 SecuritycheckproModel->chequear_ip_en_lista() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1985 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.10 ms Utolsó lekérdezés után: 7.47 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.641 MB Visszaadott sorok: 1Duplikált lekérdezések: #39
SELECT *
FROM slib0_securitycheckpro_whitelistid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_whitelist NULL index NULL PRIMARY 767 NULL 1 100.00 Using index Status Duration starting 0.24 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.03 ms executing 0.11 ms end 0.01 ms query end 0.03 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.03 ms # Hívó Fájl és sorok száma 10 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_securitycheckpro/library/model.php:453 9 SecuritycheckproModel->chequear_ip_en_lista() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1986 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.10 ms Utolsó lekérdezés után: 0.20 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.645 MB Visszaadott sorok: 1Duplikált lekérdezések: #38
SELECT *
FROM slib0_securitycheckpro_whitelistid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_whitelist NULL index NULL PRIMARY 767 NULL 1 100.00 Using index Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.04 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.64 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_securitycheckpro/library/model.php:454 9 SecuritycheckproModel->chequear_ip_en_lista() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1986 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.51 ms Utolsó lekérdezés után: 0.28 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 2.650 MB
DELETE
FROM slib0_securitycheckpro_dynamic_blacklist
WHERE (DATE_ADD(timeattempt, INTERVAL 600 SECOND)) < NOW();Az EXPLAIN nem lehetséges a következő lekérdezésen: DELETE FROM slib0_securitycheckpro_dynamic_blacklist WHERE (DATE_ADD(timeattempt, INTERVAL 600 SECOND)) < NOW();Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.01 ms System lock 0.06 ms updating 0.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:903 10 plgSystemSecuritycheckpro->pasar_a_historico() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1182 9 plgSystemSecuritycheckpro->acciones_lista_negra_dinamica() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:2018 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.60 ms Utolsó lekérdezés után: 0.09 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.655 MB Visszaadott sorok: 1
SELECT COUNT(*)
from slib0_securitycheckpro_dynamic_blacklist
WHERE (ip = '216.73.216.145'
AND counter >= 5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL NULL NULL no matching row in const table Status Duration starting 0.19 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms executing 0.02 ms end 0.05 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:867 10 plgSystemSecuritycheckpro->chequear_ip_en_lista_dinamica() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1184 9 plgSystemSecuritycheckpro->acciones_lista_negra_dinamica() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:2018 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 2.07 ms Utolsó lekérdezés után: 1.36 ms Memória lekérdezése: 0.053 MB memória a lekérdezés előtt: 2.690 MB Visszaadott sorok: 35
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 slib0_menu AS m
LEFT JOIN slib0_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 ALL idx_client_id_parent_id_alias_language NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 177 6.21 Using where; Fájlrendezés használata 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 oyabun_info.m.component_id 1 100.00 Using where Status Duration starting 0.20 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.22 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.19 ms preparing 0.07 ms executing 0.85 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 19 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Ugyanaz a hívás, mint egy sorral lejjebb. 18 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 17 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 16 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 15 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 14 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 13 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 12 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 11 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:2135 10 plgSystemSecuritycheckpro->get_component() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1333 9 plgSystemSecuritycheckpro->acciones_no_listas() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:2046 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.43 ms Utolsó lekérdezés után: 1.35 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.809 MB Visszaadott sorok: 1
SELECT COUNT(*)
from slib0_securitycheckpro_db
WHERE (vuln_type = 'com_k2')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_db NULL ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 531 10.00 Using where Status Duration starting 0.15 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.02 ms Opening tables 0.10 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.24 ms executing 0.56 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.04 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:269 12 plgSystemSecuritycheckpro->check_extension_vulnerable() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:321 11 plgSystemSecuritycheckpro->apply_filters() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:675 10 plgSystemSecuritycheckpro->cleanQuery() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1335 9 plgSystemSecuritycheckpro->acciones_no_listas() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:2046 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.78 ms Utolsó lekérdezés után: 1.12 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.815 MB Visszaadott sorok: 1
SELECT COUNT(*)
from slib0_securitycheckpro_db
WHERE (vuln_type = 'com_k2')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_db NULL ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 531 10.00 Using where Status Duration starting 0.41 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.06 ms executing 0.48 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.09 ms cleaning up 0.02 ms # Hívó Fájl és sorok száma 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:269 11 plgSystemSecuritycheckpro->check_extension_vulnerable() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:795 10 plgSystemSecuritycheckpro->second_level() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1350 9 plgSystemSecuritycheckpro->acciones_no_listas() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:2046 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.96 ms Utolsó lekérdezés után: 0.67 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.821 MB Visszaadott sorok: 1
SELECT COUNT(*)
from slib0_securitycheckpro_db
WHERE (vuln_type = 'com_k2')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_db NULL ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 531 10.00 Using where Status Duration starting 0.20 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 0.08 ms statistics 0.04 ms preparing 0.07 ms executing 0.55 ms end 0.07 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.10 ms cleaning up 0.02 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:269 12 plgSystemSecuritycheckpro->check_extension_vulnerable() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:321 11 plgSystemSecuritycheckpro->apply_filters() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:675 10 plgSystemSecuritycheckpro->cleanQuery() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1335 9 plgSystemSecuritycheckpro->acciones_no_listas() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:2046 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.74 ms Utolsó lekérdezés után: 1.51 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.827 MB Visszaadott sorok: 1
SELECT COUNT(*)
from slib0_securitycheckpro_db
WHERE (vuln_type = 'com_k2')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_db NULL ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 531 10.00 Using where Status Duration starting 0.52 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.12 ms executing 0.42 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.02 ms # Hívó Fájl és sorok száma 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:269 11 plgSystemSecuritycheckpro->check_extension_vulnerable() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:795 10 plgSystemSecuritycheckpro->second_level() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1350 9 plgSystemSecuritycheckpro->acciones_no_listas() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:2046 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.90 ms Utolsó lekérdezés után: 0.39 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.833 MB Visszaadott sorok: 1
SELECT `template`
FROM `slib0_template_styles`
WHERE `client_id` = 0
AND `home` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_template_styles NULL ref idx_client_id,idx_client_id_home idx_client_id 1 const 11 10.00 Using where Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.09 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.04 ms executing 0.08 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 10 JDatabaseDriver->loadObject() JROOT/plugins/system/helix3/helix3.php:247 9 plgSystemHelix3->getTemplateName() JROOT/plugins/system/helix3/helix3.php:41 8 plgSystemHelix3->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.94 ms Utolsó lekérdezés után: 3.21 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.855 MB Visszaadott sorok: 0Duplikált lekérdezések: #49
SELECT storage_value
FROM slib0_securitycheckpro_storage
WHERE storage_key='remote_task'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL NULL NULL no matching row in const table Status Duration starting 0.18 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 10 JDatabaseDriverMysqli->execute() JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:175 9 plgSystemSecuritycheckpro_cron->look_for_remote_tasks() JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:209 8 plgSystemSecuritycheckpro_cron->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.33 ms Utolsó lekérdezés után: 0.11 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.860 MB Visszaadott sorok: 0Duplikált lekérdezések: #48
SELECT storage_value
FROM slib0_securitycheckpro_storage
WHERE storage_key='remote_task'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL NULL NULL no matching row in const table Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:176 9 plgSystemSecuritycheckpro_cron->look_for_remote_tasks() JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:209 8 plgSystemSecuritycheckpro_cron->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.84 ms Utolsó lekérdezés után: 0.69 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.883 MB Visszaadott sorok: 1
SELECT `storage_value`
FROM `slib0_securitycheckpro_storage`
WHERE `storage_key` = 'filemanager_resume'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_storage NULL const PRIMARY PRIMARY 767 const 1 100.00 NULL Status Duration starting 0.17 ms Executing hook on transaction 0.01 ms starting 0.03 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:320 10 SecuritycheckprosModelFileManager->__construct() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213 9 Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance() JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:213 8 plgSystemSecuritycheckpro_cron->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.54 ms Utolsó lekérdezés után: 0.20 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.889 MB Visszaadott sorok: 1
SELECT `storage_value`
FROM `slib0_securitycheckpro_storage`
WHERE `storage_key` = 'fileintegrity_resume'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_storage NULL const PRIMARY PRIMARY 767 const 1 100.00 NULL Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.17 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:330 10 SecuritycheckprosModelFileManager->__construct() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213 9 Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance() JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:213 8 plgSystemSecuritycheckpro_cron->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.42 ms Utolsó lekérdezés után: 0.12 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.896 MB Visszaadott sorok: 1
SELECT `storage_value`
FROM `slib0_securitycheckpro_storage`
WHERE `storage_key` = 'malwarescan_resume'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_storage NULL const PRIMARY PRIMARY 767 const 1 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:341 10 SecuritycheckprosModelFileManager->__construct() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213 9 Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance() JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:213 8 plgSystemSecuritycheckpro_cron->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.79 ms Utolsó lekérdezés után: 0.11 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.904 MB Visszaadott sorok: 1
SELECT `storage_value`
FROM `slib0_securitycheckpro_storage`
WHERE `storage_key` = 'filepermissions_log'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_storage NULL const PRIMARY PRIMARY 767 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 1.30 ms cleaning up 0.07 ms # Hívó Fájl és sorok száma 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:1280 11 SecuritycheckprosModelFileManager->get_log_filename() JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:348 10 SecuritycheckprosModelFileManager->__construct() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213 9 Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance() JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:213 8 plgSystemSecuritycheckpro_cron->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.97 ms Utolsó lekérdezés után: 0.36 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.910 MB Visszaadott sorok: 1
SELECT `storage_value`
FROM `slib0_securitycheckpro_storage`
WHERE `storage_key` = 'fileintegrity_log'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_storage NULL const PRIMARY PRIMARY 767 const 1 100.00 NULL Status Duration starting 0.14 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.01 ms System lock 0.06 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.03 ms executing 0.02 ms end 0.00 ms query end 0.03 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:1280 11 SecuritycheckprosModelFileManager->get_log_filename() JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:349 10 SecuritycheckprosModelFileManager->__construct() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213 9 Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance() JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:213 8 plgSystemSecuritycheckpro_cron->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.80 ms Utolsó lekérdezés után: 0.38 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.916 MB Visszaadott sorok: 1
SELECT `storage_value`
FROM `slib0_securitycheckpro_storage`
WHERE `storage_key` = 'filemalware_log'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_storage NULL const PRIMARY PRIMARY 767 const 1 100.00 NULL Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.24 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Hívó Fájl és sorok száma 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:1280 11 SecuritycheckprosModelFileManager->get_log_filename() JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:350 10 SecuritycheckprosModelFileManager->__construct() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213 9 Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance() JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:213 8 plgSystemSecuritycheckpro_cron->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.19 ms Utolsó lekérdezés után: 0.14 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.921 MB Visszaadott sorok: 1
SELECT last_online_check_malwarescan
FROM slib0_securitycheckpro_file_manager
WHERE id=1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_file_manager NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.12 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.01 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.76 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:2093 12 SecuritycheckprosModelFileManager->get_campo_filemanager() JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:3665 11 SecuritycheckprosModelFileManager->check_last_onlinecheck() JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:371 10 SecuritycheckprosModelFileManager->__construct() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213 9 Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance() JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:213 8 plgSystemSecuritycheckpro_cron->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.31 ms Utolsó lekérdezés után: 0.33 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.922 MB Visszaadott sorok: 0
SELECT `storage_value`
FROM `slib0_securitycheckpro_storage`
WHERE `storage_key` = 'cron_plugin'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL NULL NULL no matching row in const table Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Hívó Fájl és sorok száma 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/administrator/components/com_securitycheckpro/library/model.php:247 10 SecuritycheckproModel->load() JROOT/administrator/components/com_securitycheckpro/library/model.php:207 9 SecuritycheckproModel->getValue() JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:221 8 plgSystemSecuritycheckpro_cron->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.05 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.927 MB Visszaadott sorok: 1
SELECT `last_task`
FROM `slib0_securitycheckpro_file_manager`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_file_manager NULL ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 1 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.02 ms preparing 0.06 ms executing 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:107 9 plgSystemSecuritycheckpro_cron->check_timestamp() JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:226 8 plgSystemSecuritycheckpro_cron->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.62 ms Utolsó lekérdezés után: 0.15 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.933 MB Visszaadott sorok: 1
SELECT `last_check_integrity`
FROM `slib0_securitycheckpro_file_manager`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_file_manager NULL ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.32 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:118 9 plgSystemSecuritycheckpro_cron->check_timestamp() JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:226 8 plgSystemSecuritycheckpro_cron->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 4.80 ms Utolsó lekérdezés után: 1.76 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 3.002 MB Visszaadott sorok: 18
SHOW FULL COLUMNS
FROM `slib0_extensions`Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `slib0_extensions`Status Duration starting 0.18 ms Executing hook on transaction 0.01 ms starting 0.18 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.60 ms init 0.02 ms System lock 0.02 ms optimizing 0.06 ms statistics 0.28 ms preparing 0.07 ms Creating tmp table 0.17 ms executing 0.27 ms checking permissions 0.22 ms checking permissions 0.07 ms checking permissions 0.03 ms checking permissions 0.06 ms checking permissions 0.03 ms checking permissions 0.18 ms checking permissions 0.05 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.06 ms checking permissions 0.05 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.07 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.03 ms closing tables 0.05 ms freeing items 0.12 ms cleaning up 0.05 ms # Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 11 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Extension.php:32 10 Joomla\CMS\Table\Extension->__construct() JROOT/libraries/src/Table/Table.php:328 9 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/system/roksprocket/roksprocket.php:45 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.12 ms Utolsó lekérdezés után: 1.36 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 3.032 MB Visszaadott sorok: 1
SELECT `extension_id`
FROM `slib0_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index Status Duration starting 0.14 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.17 ms preparing 0.03 ms executing 0.08 ms end 0.07 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 9 Joomla\CMS\Table\Extension->find() JROOT/plugins/system/roksprocket/roksprocket.php:47 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.87 ms Utolsó lekérdezés után: 0.51 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 3.038 MB Visszaadott sorok: 1Duplikált lekérdezések: #64
SELECT *
FROM slib0_extensions
WHERE `extension_id` = '10034'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.29 ms Executing hook on transaction 0.01 ms starting 0.05 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.04 ms executing 0.03 ms end 0.00 ms query end 0.04 ms waiting for handler commit 0.02 ms closing tables 0.03 ms freeing items 0.70 ms cleaning up 0.04 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 9 Joomla\CMS\Table\Table->load() JROOT/plugins/system/roksprocket/roksprocket.php:54 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.80 ms Utolsó lekérdezés után: 0.48 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 3.042 MB Visszaadott sorok: 1
SELECT `extension_id`
FROM `slib0_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index Status Duration starting 0.14 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.17 ms preparing 0.04 ms executing 0.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 9 Joomla\CMS\Table\Extension->find() JROOT/plugins/system/roksprocket/roksprocket.php:70 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.41 ms Utolsó lekérdezés után: 0.20 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 3.048 MB Visszaadott sorok: 1Duplikált lekérdezések: #62
SELECT *
FROM slib0_extensions
WHERE `extension_id` = '10034'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 9 Joomla\CMS\Table\Table->load() JROOT/plugins/system/roksprocket/roksprocket.php:76 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.85 ms Utolsó lekérdezés után: 87.36 ms Memória lekérdezése: 0.030 MB memória a lekérdezés előtt: 3.309 MB Visszaadott sorok: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `slib0_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.33 ms Executing hook on transaction 0.01 ms starting 0.04 ms checking permissions 0.02 ms Opening tables 0.14 ms init 0.01 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.31 ms preparing 0.06 ms executing 0.17 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.05 ms freeing items 0.09 ms cleaning up 0.04 ms # Hívó Fájl és sorok száma 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Ugyanaz a hívás, mint egy sorral lejjebb. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/k2/k2.php:374 8 plgSystemK2->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 7.50 ms Utolsó lekérdezés után: 1.56 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 3.369 MB
UPDATE `slib0_extensions`
SET `params` = '{\"mediaversion\":\"25c2b23ecf00af5f51eb09fdb26843bc\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE `slib0_extensions` SET `params` = '{\"mediaversion\":\"25c2b23ecf00af5f51eb09fdb26843bc\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.25 ms Executing hook on transaction 0.01 ms starting 0.06 ms checking permissions 0.01 ms Opening tables 0.96 ms init 0.02 ms System lock 0.29 ms updating 0.33 ms end 0.01 ms query end 0.01 ms waiting for handler commit 4.88 ms closing tables 0.10 ms freeing items 0.10 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/k2/k2.php:374 8 plgSystemK2->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.22 ms Utolsó lekérdezés után: 5.44 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 3.430 MB Visszaadott sorok: 1
SELECT *
FROM slib0_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_languages NULL ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2 50.00 Using where; Fájlrendezés használata Status Duration starting 0.20 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.21 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.06 ms executing 0.24 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 12 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 11 Joomla\CMS\Application\SiteApplication->getParams() JROOT/components/com_k2/helpers/utilities.php:248 10 K2HelperUtilities::getParams() JROOT/administrator/components/com_k2/helpers/html.php:244 9 K2HelperHTML::loadHeadIncludes() JROOT/plugins/system/k2/k2.php:390 8 plgSystemK2->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.79 ms Utolsó lekérdezés után: 1.64 ms Memória lekérdezése: 0.151 MB memória a lekérdezés előtt: 3.447 MB Visszaadott sorok: 11
SELECT id, home, template, s.params
FROM slib0_template_styles as s
LEFT JOIN slib0_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 e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 5 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 oyabun_info.e.element 2 84.62 Using index condition; Using where Status Duration starting 0.18 ms Executing hook on transaction 0.12 ms starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.26 ms init 0.02 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.21 ms preparing 0.05 ms executing 0.45 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 19 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/HTML/HTMLHelper.php:365 18 Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() JROOT/libraries/src/HTML/HTMLHelper.php:712 17 Joomla\CMS\HTML\HTMLHelper::script() Ugyanaz a hívás, mint egy sorral lejjebb. 16 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 15 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 14 Joomla\CMS\HTML\HTMLHelper::_() JROOT/libraries/cms/html/jquery.php:52 13 JHtmlJquery::framework() Ugyanaz a hívás, mint egy sorral lejjebb. 12 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 11 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 10 Joomla\CMS\HTML\HTMLHelper::_() JROOT/administrator/components/com_k2/helpers/html.php:268 9 K2HelperHTML::loadHeadIncludes() JROOT/plugins/system/k2/k2.php:390 8 plgSystemK2->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.73 ms Utolsó lekérdezés után: 12.11 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 3.682 MB Visszaadott sorok: 93
SELECT id
FROM slib0_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_k2_categories NULL ref category,published,access,trash,idx_category trash 2 const 92 96.86 Using where Status Duration starting 0.20 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.25 ms init 0.01 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.28 ms preparing 0.05 ms executing 0.46 ms end 0.01 ms query end 0.01 ms closing tables 0.05 ms freeing items 0.06 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 13 JDatabaseDriver->loadColumn() JROOT/components/com_k2/helpers/permissions.php:225 12 K2HelperPermissions::canAddItem() JROOT/components/com_k2/views/item/view.html.php:37 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.79 ms Utolsó lekérdezés után: 0.73 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.688 MB Visszaadott sorok: 1
SELECT *
FROM slib0_k2_items
WHERE id=132
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_k2_items NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.45 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.04 ms Opening tables 0.34 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.17 ms preparing 0.06 ms executing 0.04 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:33 12 K2ModelItem->getData() JROOT/components/com_k2/views/item/view.html.php:44 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 3.14 ms Utolsó lekérdezés után: 1.23 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 3.709 MB Visszaadott sorok: 14
SHOW FULL COLUMNS
FROM `slib0_k2_categories`Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `slib0_k2_categories`Status Duration starting 0.24 ms Executing hook on transaction 0.06 ms starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.98 ms init 0.02 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.16 ms preparing 0.05 ms Creating tmp table 0.08 ms executing 0.18 ms checking permissions 0.13 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.04 ms checking permissions 0.10 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.08 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.03 ms closing tables 0.04 ms freeing items 0.12 ms cleaning up 0.02 ms # Hívó Fájl és sorok száma 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 15 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_k2/tables/k2category.php:34 14 TableK2Category->__construct() JROOT/libraries/src/Table/Table.php:328 13 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_k2/models/item.php:64 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.78 ms Utolsó lekérdezés után: 0.68 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.731 MB Visszaadott sorok: 1
SELECT *
FROM slib0_k2_categories
WHERE id = '32'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_k2_categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.02 ms executing 0.02 ms end 0.00 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.06 ms # Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:61 13 TableK2Category->load() JROOT/components/com_k2/models/item.php:65 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.45 ms Utolsó lekérdezés után: 1.64 ms Memória lekérdezése: 0.033 MB memória a lekérdezés előtt: 3.772 MB Visszaadott sorok: 93
SELECT id, name, parent
FROM slib0_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1)
ORDER BY parentid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_k2_categories NULL ref category,published,access,trash,idx_category trash 2 const 92 96.86 Using where; Fájlrendezés használata Status Duration starting 0.15 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.30 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.15 ms preparing 0.06 ms executing 0.44 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:932 15 K2ModelItemlist->getCategoriesTree() JROOT/components/com_k2/helpers/route.php:261 14 K2HelperRoute::findMenuItem() JROOT/components/com_k2/helpers/route.php:56 13 K2HelperRoute::getCategoryRoute() JROOT/components/com_k2/models/item.php:68 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.61 ms Utolsó lekérdezés után: 2.27 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.883 MB Visszaadott sorok: 1
SELECT *
FROM slib0_k2_categories
WHERE id = '9'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_k2_categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.13 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.08 ms preparing 0.02 ms executing 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:61 13 TableK2Category->load() JROOT/components/com_k2/models/item.php:87 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.35 ms Utolsó lekérdezés után: 0.38 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.908 MB Visszaadott sorok: 0
SELECT tag.*
FROM slib0_k2_tags AS tag JOIN slib0_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 132
ORDER BY xref.id ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xref NULL ref tagID,itemID itemID 4 const 1 100.00 NULL 1 SIMPLE tag NULL eq_ref PRIMARY,published PRIMARY 4 oyabun_info.xref.tagID 1 99.74 Using where Status Duration starting 0.22 ms Executing hook on transaction 0.02 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.40 ms init 0.01 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.20 ms preparing 0.04 ms executing 0.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1201 13 K2ModelItem->getItemTags() JROOT/components/com_k2/models/item.php:111 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.84 ms Utolsó lekérdezés után: 0.41 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.917 MB Visszaadott sorok: 0
SELECT *
FROM slib0_k2_attachments
WHERE itemID=132id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_k2_attachments NULL ref itemID itemID 4 const 1 100.00 NULL Status Duration starting 0.12 ms Executing hook on transaction 0.01 ms starting 0.03 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.03 ms executing 0.07 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1429 13 K2ModelItem->getItemAttachments() JROOT/components/com_k2/models/item.php:163 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 3.36 ms Utolsó lekérdezés után: 0.86 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 3.929 MB Visszaadott sorok: 17
SHOW FULL COLUMNS
FROM `slib0_users`Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `slib0_users`Status Duration starting 0.23 ms Executing hook on transaction 0.01 ms starting 0.17 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 1.03 ms init 0.03 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.03 ms Creating tmp table 0.07 ms executing 0.37 ms checking permissions 0.09 ms checking permissions 0.12 ms checking permissions 0.05 ms checking permissions 0.03 ms checking permissions 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.02 ms checking permissions 0.01 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.03 ms closing tables 0.06 ms freeing items 0.13 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 22 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 21 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 20 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41 19 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:328 18 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 17 Joomla\CMS\User\User::getTable() JROOT/libraries/src/User/User.php:877 16 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 15 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 14 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 13 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:208 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.20 ms Utolsó lekérdezés után: 0.47 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 3.960 MB Visszaadott sorok: 1
SELECT *
FROM `slib0_users`
WHERE `id` = 800id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_users NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.13 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.20 ms init 0.02 ms System lock 0.02 ms optimizing 0.07 ms statistics 0.27 ms preparing 0.03 ms executing 0.02 ms end 0.00 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 18 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 17 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 16 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 15 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 14 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 13 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:208 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.09 ms Utolsó lekérdezés után: 1.41 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 3.972 MB Visszaadott sorok: 1
SELECT `g`.`id`,`g`.`title`
FROM `slib0_usergroups` AS g
INNER JOIN `slib0_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 800id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref PRIMARY PRIMARY 4 const 1 100.00 Using index 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 oyabun_info.m.group_id 1 100.00 NULL Status Duration starting 0.18 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.28 ms preparing 0.09 ms executing 0.10 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 18 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:112 17 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 16 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 15 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 14 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 13 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:208 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.62 ms Utolsó lekérdezés után: 1.47 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.980 MB Visszaadott sorok: 1
SELECT id, gender, description, image, url, `
group`, plugins
FROM slib0_k2_users
WHERE userID=800id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_k2_users NULL ref userID userID 4 const 1 100.00 NULL Status Duration starting 0.19 ms Executing hook on transaction 0.01 ms starting 0.08 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.02 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.15 ms preparing 0.03 ms executing 0.11 ms end 0.01 ms query end 0.15 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1681 14 K2ModelItem->getUserProfile() JROOT/components/com_k2/helpers/utilities.php:45 13 K2HelperUtilities::getAvatar() JROOT/components/com_k2/models/item.php:211 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.98 ms Utolsó lekérdezés után: 3.29 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 4.018 MB Visszaadott sorok: 1
SELECT enabled
FROM slib0_extensions
WHERE element = 'com_sppagebuilder'
AND type = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.14 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.26 ms preparing 0.04 ms executing 0.08 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:172 16 PlgContentSppagebuilder->isSppagebuilderEnabled() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:36 15 PlgContentSppagebuilder->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 14 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 13 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/components/com_k2/models/item.php:488 12 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php:87 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.94 ms Utolsó lekérdezés után: 3.55 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 4.127 MB Visszaadott sorok: 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 slib0_fields AS a
LEFT JOIN `slib0_languages` AS l
ON l.lang_code = a.language
LEFT JOIN slib0_users AS uc
ON uc.id=a.checked_out
LEFT JOIN slib0_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN slib0_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN slib0_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_k2.item-media'
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
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 where; Using temporary; Fájlrendezés használata 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 oyabun_info.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 oyabun_info.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 oyabun_info.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 oyabun_info.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 oyabun_info.a.group_id 1 100.00 Using where Status Duration starting 0.26 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.02 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.42 ms init 0.02 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.30 ms preparing 0.03 ms Creating tmp table 0.34 ms executing 0.11 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 19 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 18 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 17 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 16 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 15 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:596 12 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php:87 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.65 ms Utolsó lekérdezés után: 3.53 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 4.168 MB Visszaadott sorok: 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 slib0_fields AS a
LEFT JOIN `slib0_languages` AS l
ON l.lang_code = a.language
LEFT JOIN slib0_users AS uc
ON uc.id=a.checked_out
LEFT JOIN slib0_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN slib0_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN slib0_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `slib0_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.item'
AND (fc.category_id IS NULL OR fc.category_id IN (32,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
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 where; Using temporary; Fájlrendezés használata 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 oyabun_info.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 oyabun_info.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 oyabun_info.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 oyabun_info.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 oyabun_info.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 oyabun_info.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.25 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.04 ms Opening tables 0.24 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.32 ms preparing 0.04 ms Creating tmp table 0.13 ms executing 0.07 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 19 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 18 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 17 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 16 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 15 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:667 12 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php:87 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 7.37 ms Utolsó lekérdezés után: 3.14 ms Memória lekérdezése: 0.457 MB memória a lekérdezés előtt: 4.222 MB Visszaadott sorok: 51
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM slib0_modules AS m
LEFT JOIN slib0_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN slib0_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 <= '2026-08-18 19:22:59')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-08-18 19:22:59')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 761 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 e NULL ALL element_clientid,element_folder_clientid NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 300 1.00 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE m NULL ref PRIMARY,published,newsfeeds newsfeeds 204 oyabun_info.e.element,const 2 2.27 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 oyabun_info.m.id 2 40.00 Using where; Using index Status Duration starting 0.27 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.26 ms init 0.01 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.21 ms preparing 0.04 ms Creating tmp table 0.08 ms executing 5.92 ms end 0.04 ms query end 0.01 ms waiting for handler commit 0.05 ms closing tables 0.04 ms freeing items 0.05 ms cleaning up 0.03 ms # Hívó Fájl és sorok száma 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() Ugyanaz a hívás, mint egy sorral lejjebb. 21 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 20 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 19 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 18 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 17 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/plugins/content/loadmodule/loadmodule.php:169 16 PlgContentLoadmodule->_load() JROOT/plugins/content/loadmodule/loadmodule.php:81 15 PlgContentLoadmodule->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:667 12 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php:87 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.68 ms Utolsó lekérdezés után: 2.57 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 4.612 MB Visszaadott sorok: 1
SELECT enabled
FROM slib0_extensions
WHERE element = 'com_sppagebuilder'
AND type = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.20 ms preparing 0.03 ms executing 0.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/plugins/k2/sppagebuilder/sppagebuilder.php:99 16 plgK2Sppagebuilder->isSppagebuilderEnabled() JROOT/plugins/k2/sppagebuilder/sppagebuilder.php:84 15 plgK2Sppagebuilder->onK2PrepareContent() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:792 12 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php:87 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 2.32 ms Utolsó lekérdezés után: 0.45 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 4.623 MB Visszaadott sorok: 0Duplikált lekérdezések: #87
SELECT *
FROM `slib0_sppagebuilder`
WHERE `extension` = 'com_k2'
AND `extension_view` = 'item'
AND `view_id` = '132'
AND `active` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_sppagebuilder NULL ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 384 0.26 Using where Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.14 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.03 ms executing 1.74 ms end 0.02 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:291 17 SppagebuilderHelper::getPageContent() JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:248 16 SppagebuilderHelper::onIntegrationPrepareContent() JROOT/plugins/k2/sppagebuilder/sppagebuilder.php:87 15 plgK2Sppagebuilder->onK2PrepareContent() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:792 12 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php:87 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 2.00 ms Utolsó lekérdezés után: 0.28 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 4.632 MB Visszaadott sorok: 0Duplikált lekérdezések: #86
SELECT *
FROM `slib0_sppagebuilder`
WHERE `extension` = 'com_k2'
AND `extension_view` = 'item'
AND `view_id` = '132'
AND `active` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_sppagebuilder NULL ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 384 0.26 Using where Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 1.41 ms end 0.02 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:291 17 SppagebuilderHelper::getPageContent() JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:248 16 SppagebuilderHelper::onIntegrationPrepareContent() JROOT/plugins/k2/sppagebuilder/sppagebuilder.php:89 15 plgK2Sppagebuilder->onK2PrepareContent() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:792 12 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php:87 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 3.42 ms Utolsó lekérdezés után: 0.73 ms Memória lekérdezése: 0.033 MB memória a lekérdezés előtt: 4.645 MB Visszaadott sorok: 36
SHOW FULL COLUMNS
FROM `slib0_k2_items`Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `slib0_k2_items`Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.11 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.80 ms init 0.02 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.03 ms Creating tmp table 0.07 ms executing 0.18 ms checking permissions 0.10 ms checking permissions 0.03 ms checking permissions 0.25 ms checking permissions 0.06 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.24 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.04 ms closing tables 0.04 ms freeing items 0.10 ms cleaning up 0.02 ms # Hívó Fájl és sorok száma 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 15 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_k2/tables/k2item.php:56 14 TableK2Item->__construct() JROOT/libraries/src/Table/Table.php:328 13 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_k2/models/item.php:839 12 K2ModelItem->hit() JROOT/components/com_k2/views/item/view.html.php:146 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.70 ms Utolsó lekérdezés után: 0.37 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 4.691 MB
UPDATE slib0_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '132'Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE slib0_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '132'Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.07 ms updating 0.27 ms end 0.01 ms query end 0.00 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 13 Joomla\CMS\Table\Table->hit() JROOT/components/com_k2/models/item.php:840 12 K2ModelItem->hit() JROOT/components/com_k2/views/item/view.html.php:146 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.46 ms Utolsó lekérdezés után: 0.40 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 4.694 MB Visszaadott sorok: 0
SELECT *
FROM slib0_k2_comments
WHERE itemID=132
AND published=1
ORDER BY commentDate DESC
LIMIT 0, 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_k2_comments NULL ref itemID,published,latestComments,countComments itemID 4 const 1 100.00 Using where; Fájlrendezés használata Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.56 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.03 ms executing 0.07 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1450 12 K2ModelItem->getItemComments() JROOT/components/com_k2/views/item/view.html.php:227 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.02 ms Utolsó lekérdezés után: 1.17 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 4.765 MB Visszaadott sorok: 0
SELECT *
FROM slib0_k2_items
WHERE id < 132
AND catid = 32
AND published = 1
AND trash = 0
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-08-18 19:22:59')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-08-18 19:22:59')
AND access IN (1,1)
ORDER BY id DESC
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_k2_items NULL ref PRIMARY,catid,idx_item catid 4 const 9 0.56 Using where; Fájlrendezés használata Status Duration starting 0.17 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.13 ms init 0.01 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.13 ms preparing 0.05 ms executing 0.15 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1604 12 K2ModelItem->getPreviousItem() JROOT/components/com_k2/views/item/view.html.php:290 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 2.40 ms Utolsó lekérdezés után: 0.18 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 4.772 MB Visszaadott sorok: 1
SELECT *
FROM slib0_k2_items
WHERE id > 132
AND catid = 32
AND published = 1
AND trash = 0
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-08-18 19:22:59')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-08-18 19:22:59')
AND access IN (1,1)
ORDER BY id ASC
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_k2_items NULL ref PRIMARY,catid,idx_item catid 4 const 9 0.73 Using where; Fájlrendezés használata Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.00 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.08 ms preparing 0.74 ms executing 0.18 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.78 ms cleaning up 0.02 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1663 12 K2ModelItem->getNextItem() JROOT/components/com_k2/views/item/view.html.php:331 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 20.41 ms Utolsó lekérdezés után: 1.96 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 4.847 MB Visszaadott sorok: 0
SELECT tag.*
FROM slib0_k2_tags AS tag JOIN slib0_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 133
ORDER BY xref.id ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xref NULL ref tagID,itemID itemID 4 const 1 100.00 NULL 1 SIMPLE tag NULL eq_ref PRIMARY,published PRIMARY 4 oyabun_info.xref.tagID 1 99.74 Using where Status Duration starting 0.22 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.01 ms System lock 0.04 ms optimizing 0.02 ms statistics 0.16 ms preparing 15.63 ms executing 0.12 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.54 ms closing tables 0.29 ms freeing items 0.05 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1201 13 K2ModelItem->getItemTags() JROOT/components/com_k2/models/item.php:111 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:333 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 2.19 ms Utolsó lekérdezés után: 0.47 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 4.855 MB Visszaadott sorok: 0
SELECT *
FROM slib0_k2_attachments
WHERE itemID=133id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_k2_attachments NULL ref itemID itemID 4 const 1 100.00 NULL Status Duration starting 0.47 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.09 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.03 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.61 ms cleaning up 0.02 ms # Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1429 13 K2ModelItem->getItemAttachments() JROOT/components/com_k2/models/item.php:163 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:333 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.17 ms Utolsó lekérdezés után: 5.44 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 4.842 MB Visszaadott sorok: 1
SELECT enabled
FROM slib0_extensions
WHERE element = 'com_sppagebuilder'
AND type = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.16 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.17 ms preparing 0.04 ms executing 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.08 ms # Hívó Fájl és sorok száma 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/plugins/k2/sppagebuilder/sppagebuilder.php:99 16 plgK2Sppagebuilder->isSppagebuilderEnabled() JROOT/plugins/k2/sppagebuilder/sppagebuilder.php:84 15 plgK2Sppagebuilder->onK2PrepareContent() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:792 12 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php:334 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.77 ms Utolsó lekérdezés után: 0.26 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 4.853 MB Visszaadott sorok: 0Duplikált lekérdezések: #97
SELECT *
FROM `slib0_sppagebuilder`
WHERE `extension` = 'com_k2'
AND `extension_view` = 'item'
AND `view_id` = '133'
AND `active` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_sppagebuilder NULL ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 384 0.26 Using where Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms executing 1.13 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:291 17 SppagebuilderHelper::getPageContent() JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:248 16 SppagebuilderHelper::onIntegrationPrepareContent() JROOT/plugins/k2/sppagebuilder/sppagebuilder.php:87 15 plgK2Sppagebuilder->onK2PrepareContent() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:792 12 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php:334 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 2.16 ms Utolsó lekérdezés után: 0.35 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 4.862 MB Visszaadott sorok: 0Duplikált lekérdezések: #96
SELECT *
FROM `slib0_sppagebuilder`
WHERE `extension` = 'com_k2'
AND `extension_view` = 'item'
AND `view_id` = '133'
AND `active` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_sppagebuilder NULL ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 384 0.26 Using where Status Duration starting 0.21 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.04 ms preparing 0.04 ms executing 1.17 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.03 ms freeing items 0.08 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:291 17 SppagebuilderHelper::getPageContent() JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:248 16 SppagebuilderHelper::onIntegrationPrepareContent() JROOT/plugins/k2/sppagebuilder/sppagebuilder.php:89 15 plgK2Sppagebuilder->onK2PrepareContent() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:792 12 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php:334 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.13 ms Utolsó lekérdezés után: 13.30 ms Memória lekérdezése: 0.033 MB memória a lekérdezés előtt: 4.981 MB Visszaadott sorok: 135
SELECT *
FROM slib0_acymailing_configid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_acymailing_config NULL ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 135 100.00 NULL Status Duration starting 0.24 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.03 ms executing 0.21 ms end 0.01 ms query end 0.07 ms waiting for handler commit 0.01 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:481 13 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:17 12 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:438 11 acymailing_config() JROOT/administrator/components/com_acymailing/compat/joomla.php:822 10 include_once JROOT/administrator/components/com_acymailing/compat/joomla.php JROOT/administrator/components/com_acymailing/helpers/helper.php:22 9 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/plugins/system/regacymailing/regacymailing.php:22 8 plgSystemRegacymailing->initAcy() JROOT/plugins/system/regacymailing/regacymailing.php:146 7 plgSystemRegacymailing->onAfterRender() 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:1118 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57
57 naplózott lekérdezéstípus, rendezés előfordulás szerint
SELECT táblák:
14 × SELECT `storage_value`
FROM `slib0_securitycheckpro_storage`8 × SELECT extension_id
FROM slib0_extensions4 × SELECT COUNT(*)
from slib0_securitycheckpro_db4 × SELECT *
FROM `slib0_sppagebuilder`4 × SELECT *
FROM slib0_securitycheckpro_blacklis3 × SELECT enabled
FROM slib0_extensions2 × SELECT storage_value
FROM slib0_securitycheckpro_storage2 × SELECT `extension_id`
FROM `slib0_extensions`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `slib0_extensions`2 × SELECT *
FROM slib0_securitycheckpro_whitelis2 × SELECT *
FROM slib0_k2_categories2 × SELECT tag.*
FROM slib0_k2_tags AS tag JOIN slib0_k2_tags_xref AS xref
ON tag.id = xref.tagID2 × SELECT *
FROM slib0_k2_attachments2 × SELECT *
FROM slib0_extensions2 × SELECT template
FROM slib0_template_styles as s2 × SELECT *
FROM slib0_k2_items1 × SELECT id, gender, description, image, url, `
group`, plugins
FROM slib0_k2_users1 × SELECT *
FROM `slib0_users`1 × 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 slib0_fields AS a
LEFT JOIN `slib0_languages` AS l
ON l.lang_code = a.language
LEFT JOIN slib0_users AS uc
ON uc.id=a.checked_out
LEFT JOIN slib0_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN slib0_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN slib0_fields_groups AS g
ON g.id = a.group_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 slib0_fields AS a
LEFT JOIN `slib0_languages` AS l
ON l.lang_code = a.language
LEFT JOIN slib0_users AS uc
ON uc.id=a.checked_out
LEFT JOIN slib0_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN slib0_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN slib0_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `slib0_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT id, name, parent
FROM slib0_k2_categories1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM slib0_modules AS m
LEFT JOIN slib0_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN slib0_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM slib0_k2_items1 × SELECT id
FROM slib0_k2_categories1 × SELECT *
FROM slib0_k2_comments1 × SELECT id, home, template, s.params
FROM slib0_template_styles as s
LEFT JOIN slib0_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM slib0_languages1 × SELECT `g`.`id`,`g`.`title`
FROM `slib0_usergroups` AS g
INNER JOIN `slib0_user_usergroup_map` AS m
ON m.group_id = g.id1 × SELECT `data`
FROM `slib0_session`1 × SELECT `last_check_integrity`
FROM `slib0_securitycheckpro_file_manager1 × SELECT `group_id`
FROM `slib0_user_usergroup_map1 × SELECT id, rules
FROM `slib0_viewlevels1 × SELECT b.id
FROM slib0_usergroups AS a
LEFT JOIN slib0_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM slib0_extensions1 × SELECT extension, file, type
FROM slib0_rokcommon_configs1 × SELECT enabled
from `slib0_extensions`1 × SELECT count(*)
from `slib0_extensions1 × SELECT enabled
from slib0_extensions1 × SELECT storage_value
from slib0_securitycheckpro_storage1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `slib0_assets`1 × SELECT `last_task`
FROM `slib0_securitycheckpro_file_manager1 × SELECT count(id)
FROM slib0_usergroup1 × SELECT *
FROM slib0_usergroups1 × SELECT COUNT(*)
from slib0_user_usergroup_map1 × SELECT contador
from slib0_securitycheckpro_users_control1 × SELECT COUNT(*)
from slib0_securitycheckpro_dynamic_blacklist1 × 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 slib0_menu AS m
LEFT JOIN slib0_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `template`
FROM `slib0_template_styles`1 × SELECT last_online_check_malwarescan
FROM slib0_securitycheckpro_file_manager1 × SELECT *
FROM slib0_acymailing_confi
EGYÉB táblák:
1 × DELETE
FROM slib0_securitycheckpro_dynamic_blacklist1 × SHOW FULL COLUMNS
FROM `slib0_extensions1 × UPDATE `slib0_extensions`
SET `params` = '{\"mediaversion\":\"25c2b23ecf00af5f51eb09fdb26843bc\"}'1 × SHOW FULL COLUMNS
FROM `slib0_k2_categories1 × SHOW FULL COLUMNS
FROM `slib0_users1 × SHOW FULL COLUMNS
FROM `slib0_k2_items1 × UPDATE slib0_k2_items
SET `hits` = (`hits` + 1)