Joomla! hibakereső konzol
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1786985660,
"last": 1786985660,
"now": 1786985660
}
},
"registry": {},
"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": {
"3a8d80093085d0efabfc252b66e57c097d7907f6": {
"link": "https://www.infokapuvar.hu/szakmunkaskepzo/item/223-%C3%A9va-konyh%C3%A1ja?print=1&tmpl=component",
"expiry": 1786985660
}
}
}
}
}
Idő
Memória
Idő: 8.89 ms / 8.89 ms Memória: 0.407 MB / 0.75 MB Application: afterLoad
Idő: 183.63 ms / 192.52 ms Memória: 1.771 MB / 2.52 MB Application: Before Access::preloadComponents (all components)
Idő: 1.69 ms / 194.20 ms Memória: 0.065 MB / 2.58 MB Application: After Access::preloadComponents (all components)
Idő: 0.06 ms / 194.26 ms Memória: -0.004 MB / 2.58 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Idő: 1.37 ms / 195.63 ms Memória: 0.008 MB / 2.59 MB Application: After Access::getAssetRules (id:1 name:root.1)
Idő: 210.94 ms / 406.57 ms Memória: 0.611 MB / 3.20 MB Application: afterInitialise
Idő: 45.67 ms / 452.24 ms Memória: 0.283 MB / 3.48 MB Application: afterRoute
Idő: 1.49 ms / 453.73 ms Memória: 0.063 MB / 3.54 MB Application: beforeRenderComponent com_k2
Idő: 0.38 ms / 454.11 ms Memória: 0.019 MB / 3.56 MB Application: Before Access::getAssetRules (id:213 name:com_k2)
Idő: 0.02 ms / 454.14 ms Memória: 0.002 MB / 3.57 MB Application: After Access::getAssetRules (id:213 name:com_k2)
Idő: 125.76 ms / 579.90 ms Memória: 0.922 MB / 4.49 MB Application: afterRenderComponent com_k2
Idő: 3.45 ms / 583.35 ms Memória: 0.023 MB / 4.51 MB Application: afterDispatch
Idő: 10.24 ms / 593.59 ms Memória: 0.463 MB / 4.97 MB Application: afterRender
Adatbázislekérdezés összesen: 278.22 ms
6,06 MB (6.359.384 Bájtok)
97 naplózott lekérdezés 278.22 ms
38 duplikátum található!
- Lekérdezés ideje: 2.38 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'6361313932653666353834343434353065656332623830346464356538613930'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.16 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.05 ms Opening tables 0.09 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.13 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.02 ms freeing items 0.05 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: 2.72 ms Utolsó lekérdezés után: 1.40 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 1.044 MB Visszaadott sorok: 1
SELECT `session_id`
FROM `slib0_session`
WHERE `session_id` = X'6361313932653666353834343434353065656332623830346464356538613930'
LIMIT 1id 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 Using index 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.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.03 ms executing 0.01 ms end 0.00 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 2.12 ms cleaning up 0.07 ms # Hívó Fájl és sorok száma 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 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.53 ms Utolsó lekérdezés után: 1.86 ms Memória lekérdezése: 0.040 MB memória a lekérdezés előtt: 1.077 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.18 ms Executing hook on transaction 0.01 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.03 ms statistics 0.15 ms preparing 0.05 ms executing 0.38 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.02 ms cleaning up 0.01 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.98 ms Utolsó lekérdezés után: 1.78 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.123 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.14 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.02 ms Opening tables 0.08 ms init 0.01 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.03 ms executing 0.09 ms end 0.03 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 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: 1.77 ms Utolsó lekérdezés után: 0.38 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.135 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.47 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 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.18 ms preparing 0.05 ms executing 0.06 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.05 ms cleaning up 0.02 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.90 ms Utolsó lekérdezés után: 0.89 ms Memória lekérdezése: 0.035 MB memória a lekérdezés előtt: 1.157 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.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.03 ms statistics 0.12 ms preparing 0.05 ms executing 1.08 ms end 0.02 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 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: 0.89 ms Utolsó lekérdezés után: 5.23 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 1.463 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.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.12 ms preparing 0.04 ms executing 0.02 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 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/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: 1.03 ms Utolsó lekérdezés után: 11.37 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 1.998 MB Visszaadott sorok: 1Duplikált lekérdezések: #9
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.17 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.02 ms statistics 0.15 ms preparing 0.05 ms executing 0.09 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 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.08 ms Utolsó lekérdezés után: 0.16 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 2.006 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.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.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.70 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/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: 0.89 ms Utolsó lekérdezés után: 2.45 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.119 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.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.01 ms statistics 0.03 ms preparing 0.04 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.03 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: 0.78 ms Utolsó lekérdezés után: 2.19 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.147 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.13 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.11 ms preparing 0.03 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.03 ms closing tables 0.02 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: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.23 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.169 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.06 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.01 ms statistics 0.13 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.73 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: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: 14.97 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.174 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.00 ms starting 0.08 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.01 ms executing 13.77 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.09 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: 2.41 ms Utolsó lekérdezés után: 14.66 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.211 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.45 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.65 ms init 0.02 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.13 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.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.49 ms Utolsó lekérdezés után: 6.87 ms Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 2.233 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.22 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.02 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.22 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.02 ms freeing items 0.04 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: 1.03 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.237 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.18 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.05 ms statistics 0.18 ms preparing 0.04 ms executing 0.07 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.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: 0.69 ms Utolsó lekérdezés után: 0.74 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.249 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.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 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.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/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.33 ms Utolsó lekérdezés után: 2.15 ms Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 2.272 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.20 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.15 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.22 ms preparing 0.04 ms executing 0.07 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.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: 1.10 ms Utolsó lekérdezés után: 0.22 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.275 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.10 ms Executing hook on transaction 0.04 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.09 ms preparing 0.02 ms executing 0.08 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # 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.77 ms Utolsó lekérdezés után: 0.97 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.348 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.14 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.09 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.10 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: 2.56 ms Utolsó lekérdezés után: 0.47 ms Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 2.370 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.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.16 ms preparing 0.03 ms executing 0.06 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.05 ms cleaning up 1.15 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: 3.18 ms Utolsó lekérdezés után: 0.23 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.374 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.72 ms Executing hook on transaction 0.02 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.17 ms preparing 0.03 ms executing 0.11 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 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: 3.64 ms Utolsó lekérdezés után: 4.05 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.385 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.13 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.02 ms optimizing 0.02 ms statistics 1.43 ms preparing 0.05 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.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/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.97 ms Utolsó lekérdezés után: 1.44 ms Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 2.406 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.18 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.04 ms statistics 0.24 ms preparing 0.03 ms executing 0.06 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.03 ms closing tables 0.40 ms freeing items 0.10 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: 0.77 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.410 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.10 ms Executing hook on transaction 0.00 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.02 ms statistics 0.16 ms preparing 0.03 ms executing 0.05 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # 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: 6.91 ms Utolsó lekérdezés után: 13.18 ms Memória lekérdezése: 0.434 MB memória a lekérdezés előtt: 2.467 MB Visszaadott sorok: 8784
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.02 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.04 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.03 ms preparing 0.03 ms executing 5.44 ms end 0.11 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.16 ms cleaning up 0.02 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: 6.73 ms Utolsó lekérdezés után: 0.35 ms Memória lekérdezése: 0.435 MB memória a lekérdezés előtt: 2.471 MB Visszaadott sorok: 8784
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.14 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.03 ms preparing 0.04 ms executing 4.16 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.02 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/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.06 ms Utolsó lekérdezés után: 9.75 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.476 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.17 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.19 ms preparing 0.04 ms executing 0.08 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.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: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: 0.79 ms Utolsó lekérdezés után: 0.25 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.480 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.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.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.34 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.65 ms Utolsó lekérdezés után: 0.16 ms Memória lekérdezése: 0.021 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` = '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.06 ms Executing hook on transaction 0.01 ms starting 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.23 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.34 ms Utolsó lekérdezés után: 0.30 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.514 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.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.02 ms executing 0.04 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: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.32 ms Utolsó lekérdezés után: 0.24 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 2.526 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.09 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.22 ms preparing 0.03 ms executing 0.67 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 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: 13.73 ms Utolsó lekérdezés után: 2.10 ms Memória lekérdezése: 0.023 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.03 ms preparing 0.03 ms executing 11.93 ms end 0.03 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 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: 0.57 ms Utolsó lekérdezés után: 0.30 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 2.602 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.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.03 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 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.02 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/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: 0.65 ms Utolsó lekérdezés után: 0.18 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.614 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.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 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.01 ms freeing items 0.28 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.40 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.619 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.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.00 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.01 ms freeing items 0.03 ms cleaning up 0.02 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: 6.66 ms Utolsó lekérdezés után: 0.20 ms Memória lekérdezése: 0.434 MB memória a lekérdezés előtt: 2.624 MB Visszaadott sorok: 8784
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.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.02 ms executing 4.67 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.04 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/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: 5.27 ms Utolsó lekérdezés után: 0.26 ms Memória lekérdezése: 0.435 MB memória a lekérdezés előtt: 2.629 MB Visszaadott sorok: 8784
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.24 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.13 ms preparing 0.04 ms executing 3.98 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.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: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.26 ms Utolsó lekérdezés után: 16.07 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.634 MB Visszaadott sorok: 1Duplikált lekérdezések: #40
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.16 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.01 ms statistics 0.03 ms preparing 0.03 ms executing 0.08 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 5.95 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: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: 3.10 ms Utolsó lekérdezés után: 0.28 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.639 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.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.03 ms executing 0.07 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 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: 8.64 ms Utolsó lekérdezés után: 0.36 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 2.644 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.17 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.06 ms updating 0.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.03 ms closing tables 0.01 ms freeing items 0.05 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: 16.74 ms Utolsó lekérdezés után: 0.28 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.649 MB Visszaadott sorok: 1
SELECT COUNT(*)
from slib0_securitycheckpro_dynamic_blacklist
WHERE (ip = '216.73.217.128'
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.18 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.12 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.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/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: 3.03 ms Utolsó lekérdezés után: 2.22 ms Memória lekérdezése: 0.053 MB memória a lekérdezés előtt: 2.683 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.22 ms Executing hook on transaction 0.37 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.09 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.05 ms executing 1.28 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 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.83 ms Utolsó lekérdezés után: 1.33 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.802 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.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.03 ms executing 0.29 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 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: 2.02 ms Utolsó lekérdezés után: 0.60 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.808 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.18 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.05 ms Opening tables 0.11 ms init 0.10 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.05 ms executing 0.34 ms end 0.34 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.43 ms cleaning up 0.08 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.34 ms Utolsó lekérdezés után: 0.51 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.814 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.13 ms Executing hook on transaction 0.02 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.04 ms preparing 0.04 ms executing 0.51 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # 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: 0.78 ms Utolsó lekérdezés után: 0.68 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.820 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.11 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.03 ms preparing 0.04 ms executing 0.26 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 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.76 ms Utolsó lekérdezés után: 0.27 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.826 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.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.02 ms executing 0.09 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # 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: 1.27 ms Utolsó lekérdezés után: 2.76 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.849 MB Visszaadott sorok: 0Duplikált lekérdezések: #50
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.15 ms Executing hook on transaction 0.01 ms starting 0.03 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.13 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.26 ms closing tables 0.02 ms freeing items 0.04 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: 1.97 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.853 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.92 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.09 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.04 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: 1.39 ms Utolsó lekérdezés után: 1.85 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.876 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.19 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.12 ms preparing 0.02 ms executing 0.01 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.06 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: 3.77 ms Utolsó lekérdezés után: 0.74 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.882 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.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.10 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 2.81 ms cleaning up 0.06 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: 6.81 ms Utolsó lekérdezés után: 0.36 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` = '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.19 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 1.17 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 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.02 ms freeing items 0.83 ms cleaning up 0.02 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: 3.22 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.897 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.17 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.03 ms Opening tables 0.09 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.02 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.61 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: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.46 ms Utolsó lekérdezés után: 0.35 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.903 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.09 ms Executing hook on transaction 0.00 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.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.02 ms cleaning up 0.00 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.28 ms Utolsó lekérdezés után: 0.13 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.909 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.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 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.04 ms closing tables 0.01 ms freeing items 0.02 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: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: 0.33 ms Utolsó lekérdezés után: 0.12 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.915 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.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.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.03 ms cleaning up 0.00 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.37 ms Utolsó lekérdezés után: 0.44 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.916 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.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.03 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.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_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: 0.36 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.921 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.03 ms Executing hook on transaction 0.01 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.02 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # 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.21 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.926 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.02 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 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.00 ms closing tables 0.00 ms freeing items 0.02 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: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: 2.87 ms Utolsó lekérdezés után: 1.57 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 2.995 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.10 ms Executing hook on transaction 0.00 ms starting 0.10 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.88 ms init 0.02 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.17 ms preparing 0.04 ms Creating tmp table 0.12 ms executing 0.20 ms checking permissions 0.11 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.03 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.03 ms freeing items 0.09 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/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: 3.74 ms Utolsó lekérdezés után: 3.21 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 3.025 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.17 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.18 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.02 ms freeing items 1.34 ms cleaning up 0.03 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: 3.09 ms Utolsó lekérdezés után: 0.45 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 3.032 MB Visszaadott sorok: 1Duplikált lekérdezések: #65
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.17 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.03 ms statistics 0.13 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.02 ms freeing items 1.53 ms cleaning up 0.02 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: 4.91 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: 3.036 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.17 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.18 ms preparing 0.04 ms executing 0.07 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 1.71 ms cleaning up 0.04 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: 7.50 ms Utolsó lekérdezés után: 0.41 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.051 MB Visszaadott sorok: 1Duplikált lekérdezések: #63
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.18 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.01 ms optimizing 0.03 ms statistics 0.13 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.02 ms freeing items 2.60 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: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.24 ms Utolsó lekérdezés után: 69.92 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 3.308 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.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.05 ms statistics 0.22 ms preparing 0.04 ms executing 0.09 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.06 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/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: 13.70 ms Utolsó lekérdezés után: 0.56 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 3.363 MB
UPDATE `slib0_extensions`
SET `params` = '{\"mediaversion\":\"03390299d8ddab5d85898922bafbbdde\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE `slib0_extensions` SET `params` = '{\"mediaversion\":\"03390299d8ddab5d85898922bafbbdde\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.23 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.23 ms updating 0.17 ms end 0.01 ms query end 0.01 ms waiting for handler commit 12.34 ms closing tables 0.09 ms freeing items 0.09 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.82 ms Utolsó lekérdezés után: 3.72 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 3.422 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.22 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.63 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.05 ms executing 0.27 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.07 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: 2.89 ms Utolsó lekérdezés után: 1.48 ms Memória lekérdezése: 0.151 MB memória a lekérdezés előtt: 3.440 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.23 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.14 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.22 ms preparing 0.05 ms executing 1.18 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.06 ms cleaning up 0.02 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.79 ms Utolsó lekérdezés után: 13.63 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 3.673 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.22 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.49 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.04 ms executing 0.35 ms end 0.07 ms query end 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 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.25 ms Utolsó lekérdezés után: 0.39 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.680 MB Visszaadott sorok: 1
SELECT *
FROM slib0_k2_items
WHERE id=223
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.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.38 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.04 ms end 0.00 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: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.86 ms Utolsó lekérdezés után: 1.00 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 3.701 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.17 ms Executing hook on transaction 0.01 ms starting 0.23 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.94 ms init 0.02 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.15 ms preparing 0.04 ms Creating tmp table 0.09 ms executing 0.37 ms checking permissions 0.12 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 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.03 ms freeing items 0.82 ms cleaning up 0.03 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.64 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.724 MB Visszaadott sorok: 1
SELECT *
FROM slib0_k2_categories
WHERE id = '78'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.17 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.07 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.05 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: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: 2.39 ms Utolsó lekérdezés után: 1.88 ms Memória lekérdezése: 0.033 MB memória a lekérdezés előtt: 3.764 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.48 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.03 ms statistics 0.15 ms preparing 0.07 ms executing 0.53 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.38 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: 2.74 ms Utolsó lekérdezés után: 2.80 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.866 MB Visszaadott sorok: 1
SELECT *
FROM slib0_k2_categories
WHERE id = '50'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.21 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.01 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.03 ms executing 0.03 ms end 0.01 ms query end 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: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: 2.94 ms Utolsó lekérdezés után: 0.78 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.891 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 = 223
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.10 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 2.19 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.07 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # 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: 2.58 ms Utolsó lekérdezés után: 0.40 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.900 MB Visszaadott sorok: 0
SELECT *
FROM slib0_k2_attachments
WHERE itemID=223id 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.30 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 1.52 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 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.01 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: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.42 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.921 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.13 ms Executing hook on transaction 0.01 ms starting 0.09 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 1.33 ms init 0.03 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.20 ms preparing 0.05 ms Creating tmp table 0.10 ms executing 0.26 ms checking permissions 0.11 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.08 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.10 ms cleaning up 0.02 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.63 ms Utolsó lekérdezés után: 0.49 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 3.952 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.14 ms Executing hook on transaction 0.00 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.11 ms preparing 0.02 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.06 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.69 ms Utolsó lekérdezés után: 1.21 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 3.964 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.21 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 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.14 ms preparing 0.04 ms executing 0.08 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.07 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: 5.93 ms Utolsó lekérdezés után: 3.31 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.971 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.18 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 2.07 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.04 ms executing 0.05 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.06 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: 2.91 ms Utolsó lekérdezés után: 3.95 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 4.009 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.23 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.20 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.50 ms preparing 0.06 ms executing 1.18 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.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: 2.01 ms Utolsó lekérdezés után: 4.96 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 4.118 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.68 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.20 ms init 0.01 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.28 ms preparing 0.04 ms Creating tmp table 0.11 ms executing 0.12 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.07 ms cleaning up 0.02 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: 5.89 ms Utolsó lekérdezés után: 3.40 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 4.160 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 (78,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.31 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 2.19 ms init 0.05 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.25 ms preparing 0.04 ms Creating tmp table 1.34 ms executing 0.63 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.04 ms closing tables 0.04 ms freeing items 0.40 ms cleaning up 0.03 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: 2.59 ms Utolsó lekérdezés után: 8.77 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 4.210 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.19 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.20 ms preparing 0.04 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.88 ms cleaning up 0.02 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: 7.39 ms Utolsó lekérdezés után: 2.19 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 4.221 MB Visszaadott sorok: 0Duplikált lekérdezések: #87
SELECT *
FROM `slib0_sppagebuilder`
WHERE `extension` = 'com_k2'
AND `extension_view` = 'item'
AND `view_id` = '223'
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.17 ms Executing hook on transaction 0.01 ms starting 0.09 ms checking permissions 0.01 ms Opening tables 4.81 ms init 0.04 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.04 ms preparing 0.11 ms executing 1.21 ms end 0.02 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 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.32 ms Utolsó lekérdezés után: 1.99 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 4.230 MB Visszaadott sorok: 0Duplikált lekérdezések: #86
SELECT *
FROM `slib0_sppagebuilder`
WHERE `extension` = 'com_k2'
AND `extension_view` = 'item'
AND `view_id` = '223'
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.17 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.01 ms optimizing 0.03 ms statistics 0.04 ms preparing 0.04 ms executing 1.02 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.45 ms cleaning up 0.03 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: 4.16 ms Utolsó lekérdezés után: 1.07 ms Memória lekérdezése: 0.033 MB memória a lekérdezés előtt: 4.243 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.17 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.99 ms init 0.05 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.17 ms preparing 0.06 ms Creating tmp table 0.10 ms executing 0.19 ms checking permissions 0.13 ms checking permissions 0.06 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.05 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.08 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.06 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.14 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.05 ms closing tables 0.05 ms freeing items 0.34 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.91 ms Utolsó lekérdezés után: 0.47 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 4.289 MB
UPDATE slib0_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '223'Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE slib0_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '223'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.08 ms init 0.01 ms System lock 0.09 ms updating 0.33 ms end 0.01 ms query end 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 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: 0.95 ms Utolsó lekérdezés után: 0.32 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 4.293 MB Visszaadott sorok: 0
SELECT *
FROM slib0_k2_items
WHERE id != 223
AND catid = 78
AND ordering < 1
AND published = 1
AND trash = 0
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-08-17 16:54:20')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-08-17 16:54:20')
AND access IN (1,1)
ORDER BY ordering DESC
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_k2_items NULL range PRIMARY,catid,ordering,idx_item ordering 4 NULL 2 2.50 Using index condition; Using where; Backward index scan Status Duration starting 0.28 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.04 ms statistics 0.12 ms preparing 0.06 ms executing 0.07 ms end 0.00 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: 0.84 ms Utolsó lekérdezés után: 0.25 ms Memória lekérdezése: 0.038 MB memória a lekérdezés előtt: 4.300 MB Visszaadott sorok: 1
SELECT *
FROM slib0_k2_items
WHERE id != 223
AND catid = 78
AND ordering > 1
AND published = 1
AND trash = 0
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-08-17 16:54:20')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-08-17 16:54:20')
AND access IN (1,1)
ORDER BY ordering 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,ordering,idx_item catid 4 const 5 1.00 Using where; Fájlrendezés használata Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.00 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.05 ms executing 0.17 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.05 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: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: 0.94 ms Utolsó lekérdezés után: 2.06 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 4.379 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 = 1152
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.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.09 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.05 ms executing 0.05 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 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: 0.63 ms Utolsó lekérdezés után: 0.33 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 4.387 MB Visszaadott sorok: 0
SELECT *
FROM slib0_k2_attachments
WHERE itemID=1152id 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.07 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.06 ms preparing 0.02 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.02 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: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.11 ms Utolsó lekérdezés után: 3.75 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 4.379 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.31 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.18 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.01 ms freeing items 0.66 ms cleaning up 0.02 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: 2.31 ms Utolsó lekérdezés után: 0.48 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 4.390 MB Visszaadott sorok: 0Duplikált lekérdezések: #96
SELECT *
FROM `slib0_sppagebuilder`
WHERE `extension` = 'com_k2'
AND `extension_view` = 'item'
AND `view_id` = '1152'
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.13 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.03 ms preparing 0.04 ms executing 1.03 ms end 0.02 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.07 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.20 ms Utolsó lekérdezés után: 0.51 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 4.399 MB Visszaadott sorok: 0Duplikált lekérdezések: #95
SELECT *
FROM `slib0_sppagebuilder`
WHERE `extension` = 'com_k2'
AND `extension_view` = 'item'
AND `view_id` = '1152'
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.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.02 ms statistics 0.03 ms preparing 0.03 ms executing 0.97 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.75 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.37 ms Utolsó lekérdezés után: 13.39 ms Memória lekérdezése: 0.033 MB memória a lekérdezés előtt: 4.584 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.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.03 ms preparing 0.03 ms executing 0.23 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 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
56 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_securitycheckpro_blacklis4 × SELECT *
FROM `slib0_sppagebuilder`3 × SELECT enabled
FROM slib0_extensions2 × SELECT `extension_id`
FROM `slib0_extensions`2 × SELECT *
FROM slib0_extensions2 × 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 storage_value
FROM slib0_securitycheckpro_storage2 × SELECT template
FROM slib0_template_styles as s2 × SELECT *
FROM slib0_k2_items2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `slib0_extensions`1 × SELECT `last_check_integrity`
FROM `slib0_securitycheckpro_file_manager1 × SELECT *
FROM `slib0_users`1 × SELECT id, gender, description, image, url, `
group`, plugins
FROM slib0_k2_users1 × 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 id, name, parent
FROM slib0_k2_categories1 × SELECT *
FROM slib0_k2_items1 × SELECT id
FROM slib0_k2_categories1 × 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, 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_task`
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_online_check_malwarescan
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 `session_id`
FROM `slib0_session`1 × SELECT `template`
FROM `slib0_template_styles`1 × 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\":\"03390299d8ddab5d85898922bafbbdde\"}'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)