Szeretnél többet megmutatni a cégedről?
|
- Nézzed meg az árát! ............................... - Mekkora a hirdetési felület? ............................... - Próbáltál már "Hangot adni" hirdetésednek? .............................. |
Saját weblap? Semmi gond. Mutassd be céged, Mondhatod, hogy neked van már saját weboldalad.
- A kapuváriak ismerik az oldalad elérhetőségét? A Világháló hatalmas. Könnyen elveszhet benne az érdeklődő. Mi segítünk. Írjad be a Google keresőbe a Kapuvár szót... - Igen! Érdemes az Infókapuváron jelen lenni. Ha többre vágysz, mint egy "mini-site", azt is megoldjuk! Webáruházak, html,php, flash oldalak stb... |
|
- Minőségi oldalt szeretnél?- Semmi akadály
|
|
|
|
Saját weboldal kell?Semmi akadálya!Domain regisztráció .hu = 3750 Ft/2 év Tárhely szolgáltatás, karbantartás.
|
|
|
|
|
Ez az e-mail-cím a szpemrobotok elleni védelem alatt áll. Megtekintéséhez engedélyeznie kell a JavaScript használatát. |
|
|
|
|
|
Joomla! hibakereső konzol
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1786734498,
"last": 1786734498,
"now": 1786734498
}
},
"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": {
"98799ab4c61feeaa7f1b858aec8521b8aa5c8783": {
"link": "https://www.infokapuvar.hu/kultura/item/330-katona-gumiszerv%C3%ADz?print=1&tmpl=component",
"expiry": 1786734499
}
}
}
}
}
Idő
Memória
103 naplózott lekérdezés 437.78 ms
41 duplikátum található!
- Lekérdezés ideje: 0.76 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 1.028 MB Visszaadott sorok: 0
SELECT `data`
FROM `slib0_session`
WHERE `session_id` = X'3437373835366432633066353130613562633363616661666235623731356664'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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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: 6.47 ms Utolsó lekérdezés után: 1.43 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 1.043 MB Visszaadott sorok: 0
SELECT `session_id`
FROM `slib0_session`
WHERE `session_id` = X'3437373835366432633066353130613562633363616661666235623731356664'
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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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: 20.20 ms Utolsó lekérdezés után: 0.29 ms Memória lekérdezése: 0.004 MB memória a lekérdezés előtt: 1.048 MB
INSERT INTO `slib0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3437373835366432633066353130613562633363616661666235623731356664', 1, 1786734498, 0, '', 0)Az EXPLAIN nem lehetséges a következő lekérdezésen: INSERT INTO `slib0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3437373835366432633066353130613562633363616661666235623731356664', 1, 1786734498, 0, '', 0)Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# Hívó Fájl és sorok száma 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 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: 2.17 ms Utolsó lekérdezés után: 2.91 ms Memória lekérdezése: 0.040 MB memória a lekérdezés előtt: 1.079 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 Nincs SHOW PROFILE (lehet azért, mert több mint 100 lekérdezés van)# 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: 0.90 ms Utolsó lekérdezés után: 2.52 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.126 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.01 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.03 ms executing 0.10 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.05 ms # Hívó Fájl és sorok száma 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.95 ms Utolsó lekérdezés után: 0.25 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.138 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.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.18 ms preparing 0.04 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.06 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: 4.56 ms Utolsó lekérdezés után: 1.14 ms Memória lekérdezése: 0.035 MB memória a lekérdezés előtt: 1.159 MB Visszaadott sorok: 130
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM slib0_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref extension extension 82 const 154 0.40 Using where; Fájlrendezés használata Status Duration starting 0.08 ms Executing hook on transaction 0.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.02 ms statistics 0.09 ms preparing 0.03 ms executing 1.22 ms end 0.02 ms query end 0.56 ms waiting for handler commit 0.03 ms closing tables 0.04 ms freeing items 0.55 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.82 ms Utolsó lekérdezés után: 6.71 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 1.466 MB Visszaadott sorok: 1
SELECT `storage_value`
FROM `slib0_securitycheckpro_storage`
WHERE `storage_key` = 'pro_plugin'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_securitycheckpro_storage NULL const PRIMARY PRIMARY 767 const 1 100.00 NULL Status Duration starting 0.24 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.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.03 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.24 ms Utolsó lekérdezés után: 10.36 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 2.001 MB Visszaadott sorok: 1Duplikált lekérdezések: #10
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.18 ms Executing hook on transaction 0.01 ms starting 0.03 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.04 ms executing 0.26 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.07 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php: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: 0.63 ms Utolsó lekérdezés után: 0.18 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 2.009 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.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 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.03 ms cleaning up 0.05 ms # Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 13 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 12 RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 11 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 10 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 9 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:95 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:53 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.11 ms Utolsó lekérdezés után: 3.07 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.121 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.06 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.37 ms Utolsó lekérdezés után: 2.59 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.150 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.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.04 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: 3.03 ms Utolsó lekérdezés után: 0.21 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.172 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 1.98 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.02 ms statistics 0.16 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.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/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: 5.67 ms Utolsó lekérdezés után: 0.14 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.176 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.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 4.29 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/plugins/system/securitycheck_spam_protection/securitycheck_spam_protection.php:80 7 plgSystemSecuritycheck_spam_protection->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.82 ms Utolsó lekérdezés után: 2.55 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.214 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.11 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.05 ms preparing 0.01 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.03 ms cleaning up 0.04 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: 0.66 ms Utolsó lekérdezés után: 0.26 ms Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 2.235 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.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 8 JDatabaseDriverMysqli->execute() JROOT/plugins/system/trackactions/trackactions.php:58 7 PlgSystemTrackActions->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.28 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.241 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.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.05 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.03 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.71 ms Utolsó lekérdezés után: 0.37 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.252 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.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 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.03 ms cleaning up 0.00 ms # Hívó Fájl és sorok száma 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/trackactions/trackactions.php:95 8 PlgSystemTrackActions->load() JROOT/plugins/system/trackactions/trackactions.php:45 7 PlgSystemTrackActions->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.03 ms Utolsó lekérdezés után: 0.21 ms Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 2.274 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.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 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.33 ms cleaning up 0.03 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.68 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.278 MB Visszaadott sorok: 1
SELECT extension_id
FROM slib0_extensions
WHERE element="com_securitycheckpro"
and type="component"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 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/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.37 ms Utolsó lekérdezés után: 0.39 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.351 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.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.02 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.02 ms # Hívó Fájl és sorok száma 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/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: 0.31 ms Utolsó lekérdezés után: 0.22 ms Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 2.373 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.03 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.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 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.34 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.377 MB Visszaadott sorok: 1
SELECT extension_id
FROM slib0_extensions
WHERE element="com_securitycheckpro"
and type="component"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index Status Duration starting 0.03 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.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.03 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.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.44 ms Utolsó lekérdezés után: 0.33 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.387 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.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.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.10 ms Utolsó lekérdezés után: 0.36 ms Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 2.409 MB Visszaadott sorok: 1
SELECT extension_id
FROM slib0_extensions
WHERE element="com_securitycheckpro"
and type="component"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.12 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.67 ms cleaning up 0.04 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.54 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.413 MB Visszaadott sorok: 1
SELECT extension_id
FROM slib0_extensions
WHERE element="com_securitycheckpro"
and type="component"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index Status Duration starting 0.05 ms Executing hook on transaction 0.00 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.08 ms preparing 0.02 ms executing 0.48 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: 6.06 ms Utolsó lekérdezés után: 10.34 ms Memória lekérdezése: 0.434 MB memória a lekérdezés előtt: 2.469 MB Visszaadott sorok: 8782
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 4613 100.00 Using index Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 5.31 ms end 0.05 ms query end 0.04 ms waiting for handler commit 0.03 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.07 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: 19.48 ms Utolsó lekérdezés után: 0.40 ms Memória lekérdezése: 0.435 MB memória a lekérdezés előtt: 2.474 MB Visszaadott sorok: 8782
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 4613 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.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.03 ms executing 4.15 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.06 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.30 ms Utolsó lekérdezés után: 11.49 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.478 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.21 ms preparing 0.04 ms executing 0.08 ms end 0.01 ms query end 0.08 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.05 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.96 ms Utolsó lekérdezés után: 0.24 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.483 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.12 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.04 ms Opening tables 0.08 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.13 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.03 ms freeing items 0.03 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/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.32 ms Utolsó lekérdezés után: 0.32 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.490 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.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.04 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.26 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.517 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.00 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.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # 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.96 ms Utolsó lekérdezés után: 0.23 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 2.536 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.08 ms Executing hook on transaction 0.01 ms starting 0.00 ms checking permissions 0.01 ms Opening tables 0.13 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.32 ms preparing 0.03 ms executing 0.57 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.04 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: 2.33 ms Utolsó lekérdezés után: 1.58 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.598 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.13 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.03 ms preparing 0.02 ms executing 1.80 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: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.70 ms Utolsó lekérdezés után: 0.18 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 2.605 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.09 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.00 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.03 ms executing 0.16 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.21 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.03 ms # Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/UserGroupsHelper.php:263 13 Joomla\CMS\Helper\UserGroupsHelper->loadAll() JROOT/libraries/src/Helper/UserGroupsHelper.php:156 12 Joomla\CMS\Helper\UserGroupsHelper->getAll() JROOT/libraries/src/Access/Access.php:501 11 Joomla\CMS\Access\Access::getGroupPath() JROOT/libraries/src/Access/Access.php:485 10 Joomla\CMS\Access\Access::checkGroup() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:2571 9 plgSystemSecuritycheckpro->forbid_new_admins() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1978 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.20 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.616 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.05 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.55 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: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.75 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.621 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.06 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.02 ms statistics 0.12 ms preparing 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.02 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/plugins/system/securitycheckpro/securitycheckpro.php:2598 9 plgSystemSecuritycheckpro->forbid_new_admins() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1978 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 4.19 ms Utolsó lekérdezés után: 0.29 ms Memória lekérdezése: 0.434 MB memória a lekérdezés előtt: 2.627 MB Visszaadott sorok: 8782
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 4613 100.00 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.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 3.69 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.04 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/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: 4.64 ms Utolsó lekérdezés után: 0.14 ms Memória lekérdezése: 0.435 MB memória a lekérdezés előtt: 2.632 MB Visszaadott sorok: 8782
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 4613 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.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 4.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.02 ms cleaning up 0.06 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: 0.38 ms Utolsó lekérdezés után: 5.90 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.637 MB Visszaadott sorok: 1Duplikált lekérdezések: #41
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.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.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.01 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 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:1986 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.28 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.642 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.02 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.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.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.03 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_securitycheckpro/library/model.php:454 9 SecuritycheckproModel->chequear_ip_en_lista() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1986 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.43 ms Utolsó lekérdezés után: 0.11 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 2.646 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.14 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.03 ms updating 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.04 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: 1.42 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.651 MB Visszaadott sorok: 1
SELECT COUNT(*)
from slib0_securitycheckpro_dynamic_blacklist
WHERE (ip = '216.73.216.10'
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.24 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.04 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.02 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:867 10 plgSystemSecuritycheckpro->chequear_ip_en_lista_dinamica() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1184 9 plgSystemSecuritycheckpro->acciones_lista_negra_dinamica() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:2018 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 2.50 ms Utolsó lekérdezés után: 3.30 ms Memória lekérdezése: 0.053 MB memória a lekérdezés előtt: 2.686 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.14 ms Executing hook on transaction 0.01 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.12 ms preparing 0.05 ms executing 0.96 ms end 0.01 ms query end 0.64 ms waiting for handler commit 0.04 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.05 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: 2.16 ms Utolsó lekérdezés után: 1.26 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.805 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.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 1.01 ms executing 0.33 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.05 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:269 12 plgSystemSecuritycheckpro->check_extension_vulnerable() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:321 11 plgSystemSecuritycheckpro->apply_filters() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:675 10 plgSystemSecuritycheckpro->cleanQuery() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1335 9 plgSystemSecuritycheckpro->acciones_no_listas() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:2046 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.37 ms Utolsó lekérdezés után: 0.46 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.811 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.09 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.04 ms preparing 0.10 ms executing 0.41 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.04 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.39 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: 2.817 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.42 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.03 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.03 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:269 12 plgSystemSecuritycheckpro->check_extension_vulnerable() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:321 11 plgSystemSecuritycheckpro->apply_filters() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:675 10 plgSystemSecuritycheckpro->cleanQuery() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1335 9 plgSystemSecuritycheckpro->acciones_no_listas() JROOT/plugins/system/securitycheckpro/securitycheckpro.php:2046 8 plgSystemSecuritycheckpro->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.47 ms Utolsó lekérdezés után: 0.48 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.823 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.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.05 ms executing 0.41 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.05 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: 7.22 ms Utolsó lekérdezés után: 1.23 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.829 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.22 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.20 ms preparing 0.04 ms executing 0.13 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 1.48 ms cleaning up 0.05 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.16 ms Utolsó lekérdezés után: 2.61 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 2.851 MB Visszaadott sorok: 0Duplikált lekérdezések: #51
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.06 ms Executing hook on transaction 0.00 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.12 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.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.70 ms Utolsó lekérdezés után: 0.14 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.856 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.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.09 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.04 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.43 ms Utolsó lekérdezés után: 0.65 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.879 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.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.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.04 ms freeing items 0.03 ms cleaning up 0.00 ms # Hívó Fájl és sorok száma 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/administrator/components/com_securitycheckpro/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: 2.87 ms Utolsó lekérdezés után: 0.40 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.885 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.26 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.17 ms init 0.02 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.17 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.10 ms cleaning up 0.05 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: 1.01 ms Utolsó lekérdezés után: 0.37 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.892 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.20 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.02 ms Opening tables 0.09 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.00 ms # Hívó Fájl és sorok száma 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:341 10 SecuritycheckprosModelFileManager->__construct() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213 9 Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance() JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:213 8 plgSystemSecuritycheckpro_cron->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.88 ms Utolsó lekérdezés után: 0.61 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.900 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.22 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.01 ms statistics 0.12 ms preparing 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.04 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.69 ms Utolsó lekérdezés után: 0.34 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.906 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.16 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.09 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 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: 2.81 ms Utolsó lekérdezés után: 0.09 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.912 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 1.58 ms Executing hook on transaction 0.03 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.17 ms preparing 0.03 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.03 ms closing tables 0.03 ms freeing items 0.07 ms cleaning up 0.06 ms # Hívó Fájl és sorok száma 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:1280 11 SecuritycheckprosModelFileManager->get_log_filename() JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:350 10 SecuritycheckprosModelFileManager->__construct() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213 9 Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance() JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:213 8 plgSystemSecuritycheckpro_cron->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.11 ms Utolsó lekérdezés után: 1.01 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.917 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.14 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.02 ms Opening tables 0.09 ms init 0.01 ms System lock 0.36 ms optimizing 0.05 ms statistics 0.16 ms preparing 0.04 ms executing 0.02 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.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/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.39 ms Utolsó lekérdezés után: 0.50 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.918 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.09 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 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.05 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.21 ms Utolsó lekérdezés után: 0.13 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.923 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.00 ms starting 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.02 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.01 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.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.929 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.00 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.19 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.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: 3.47 ms Utolsó lekérdezés után: 2.10 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 2.998 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.15 ms Executing hook on transaction 0.00 ms starting 0.12 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 1.22 ms init 0.02 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.14 ms preparing 0.03 ms Creating tmp table 0.09 ms executing 0.17 ms checking permissions 0.10 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.07 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.07 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.05 ms freeing items 0.11 ms cleaning up 0.04 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: 0.60 ms Utolsó lekérdezés után: 1.04 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 3.028 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.13 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.02 ms statistics 0.14 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.02 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: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: 0.23 ms Utolsó lekérdezés után: 0.13 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 3.034 MB Visszaadott sorok: 1Duplikált lekérdezések: #66
SELECT *
FROM slib0_extensions
WHERE `extension_id` = '10034'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.00 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.01 ms cleaning up 0.00 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 9 Joomla\CMS\Table\Table->load() JROOT/plugins/system/roksprocket/roksprocket.php:54 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.24 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.048 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.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 9 Joomla\CMS\Table\Extension->find() JROOT/plugins/system/roksprocket/roksprocket.php:70 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.17 ms Utolsó lekérdezés után: 0.09 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 3.059 MB Visszaadott sorok: 1Duplikált lekérdezések: #64
SELECT *
FROM slib0_extensions
WHERE `extension_id` = '10034'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_extensions NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 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.02 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 9 Joomla\CMS\Table\Table->load() JROOT/plugins/system/roksprocket/roksprocket.php:76 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 1.34 ms Utolsó lekérdezés után: 72.14 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 3.310 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.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.18 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.02 ms freeing items 0.03 ms cleaning up 0.04 ms # Hívó Fájl és sorok száma 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Ugyanaz a hívás, mint egy sorral lejjebb. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/k2/k2.php:374 8 plgSystemK2->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 5.19 ms Utolsó lekérdezés után: 0.23 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 3.365 MB
UPDATE `slib0_extensions`
SET `params` = '{\"mediaversion\":\"4bfc8e3ed8a54dcb7e477dfb45a95ed1\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE `slib0_extensions` SET `params` = '{\"mediaversion\":\"4bfc8e3ed8a54dcb7e477dfb45a95ed1\"}' WHERE `type` = 'library' AND `element` = 'joomla'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.01 ms System lock 0.06 ms updating 0.10 ms end 0.00 ms query end 0.00 ms waiting for handler commit 4.05 ms closing tables 0.17 ms freeing items 0.06 ms cleaning up 0.00 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.60 ms Utolsó lekérdezés után: 5.83 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 3.424 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.16 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.03 ms preparing 0.06 ms executing 0.12 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.00 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: 6.78 ms Utolsó lekérdezés után: 1.21 ms Memória lekérdezése: 0.151 MB memória a lekérdezés előtt: 3.443 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.12 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.37 ms init 0.01 ms System lock 0.50 ms optimizing 0.95 ms statistics 0.32 ms preparing 0.05 ms executing 0.24 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 6.15 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: 4.32 ms Utolsó lekérdezés után: 30.33 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 3.676 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.45 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.21 ms preparing 0.04 ms executing 0.34 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.04 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php: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.74 ms Utolsó lekérdezés után: 1.10 ms Memória lekérdezése: 0.038 MB memória a lekérdezés előtt: 3.683 MB Visszaadott sorok: 1
SELECT *
FROM slib0_k2_items
WHERE id=330
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.08 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.10 ms preparing 0.02 ms executing 0.21 ms end 0.01 ms query end 0.01 ms closing tables 0.73 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: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.36 ms Utolsó lekérdezés után: 0.79 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 3.712 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.09 ms Executing hook on transaction 0.00 ms starting 0.08 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 1.36 ms init 0.04 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.15 ms preparing 0.04 ms Creating tmp table 0.10 ms executing 0.18 ms checking permissions 0.11 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.08 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.03 ms closing tables 0.04 ms freeing items 0.10 ms cleaning up 0.07 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: 1.90 ms Utolsó lekérdezés után: 0.47 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.734 MB Visszaadott sorok: 1
SELECT *
FROM slib0_k2_categories
WHERE id = '80'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_k2_categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.02 ms executing 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.03 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: 5.89 ms Utolsó lekérdezés után: 1.69 ms Memória lekérdezése: 0.033 MB memória a lekérdezés előtt: 3.775 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.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.04 ms executing 4.45 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:932 15 K2ModelItemlist->getCategoriesTree() JROOT/components/com_k2/helpers/route.php:261 14 K2HelperRoute::findMenuItem() JROOT/components/com_k2/helpers/route.php:56 13 K2HelperRoute::getCategoryRoute() JROOT/components/com_k2/models/item.php:68 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.43 ms Utolsó lekérdezés után: 3.83 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.877 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.07 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.00 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.05 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: 0.39 ms Utolsó lekérdezés után: 0.42 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.902 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 = 330
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.07 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.07 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.01 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.24 ms Utolsó lekérdezés után: 0.20 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.911 MB Visszaadott sorok: 0
SELECT *
FROM slib0_k2_attachments
WHERE itemID=330id 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.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.29 ms init 0.07 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.85 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.04 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.14 ms Utolsó lekérdezés után: 0.72 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 3.931 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.28 ms Executing hook on transaction 0.01 ms starting 0.13 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.64 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms Creating tmp table 0.25 ms executing 0.14 ms checking permissions 0.08 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.04 ms checking permissions 0.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.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.09 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.03 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.80 ms Utolsó lekérdezés után: 0.75 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 3.962 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.75 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.03 ms optimizing 0.02 ms statistics 0.16 ms preparing 0.03 ms executing 0.03 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.07 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: 2.42 ms Utolsó lekérdezés után: 1.94 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 3.974 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.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.62 ms statistics 1.07 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.03 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: 4.16 ms Utolsó lekérdezés után: 2.45 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.982 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.17 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 3.06 ms init 0.03 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.04 ms executing 0.06 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.05 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: 5.72 ms Utolsó lekérdezés után: 3.64 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 4.027 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.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 1.80 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.13 ms preparing 0.02 ms executing 0.07 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 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: 3.04 ms Utolsó lekérdezés után: 18.87 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 4.136 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 1.02 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.23 ms init 0.01 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.49 ms preparing 0.05 ms Creating tmp table 0.12 ms executing 0.37 ms end 0.08 ms query end 0.02 ms waiting for handler commit 0.04 ms closing tables 0.04 ms freeing items 0.09 ms cleaning up 0.12 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: 33.10 ms Utolsó lekérdezés után: 36.44 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 4.185 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 (80,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.48 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 0.55 ms init 0.02 ms System lock 0.02 ms optimizing 0.04 ms statistics 17.44 ms preparing 0.07 ms Creating tmp table 0.15 ms executing 0.13 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.03 ms closing tables 0.04 ms freeing items 0.09 ms cleaning up 0.07 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: 43.95 ms Utolsó lekérdezés után: 162.23 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 4.239 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 43.05 ms Executing hook on transaction 0.04 ms starting 0.02 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.21 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.08 ms cleaning up 0.05 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: 16.00 ms Utolsó lekérdezés után: 0.68 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 4.249 MB Visszaadott sorok: 0Duplikált lekérdezések: #88
SELECT *
FROM `slib0_sppagebuilder`
WHERE `extension` = 'com_k2'
AND `extension_view` = 'item'
AND `view_id` = '330'
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 13.60 ms Executing hook on transaction 0.03 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.64 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.04 ms executing 1.26 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 84.83 ms cleaning up 0.06 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: 54.76 ms Utolsó lekérdezés után: 85.16 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 4.258 MB Visszaadott sorok: 0Duplikált lekérdezések: #87
SELECT *
FROM `slib0_sppagebuilder`
WHERE `extension` = 'com_k2'
AND `extension_view` = 'item'
AND `view_id` = '330'
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.16 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.31 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.08 ms preparing 0.04 ms executing 53.64 ms end 0.04 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.05 ms freeing items 0.07 ms cleaning up 0.05 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: 28.56 ms Utolsó lekérdezés után: 0.89 ms Memória lekérdezése: 0.033 MB memória a lekérdezés előtt: 4.273 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.14 ms Executing hook on transaction 0.00 ms starting 25.13 ms checking permissions 0.04 ms checking permissions 0.01 ms Opening tables 1.06 ms init 0.02 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.16 ms preparing 0.05 ms Creating tmp table 0.10 ms executing 0.19 ms checking permissions 0.12 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.06 ms checking permissions 0.03 ms checking permissions 0.06 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.03 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.04 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.10 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.04 ms closing tables 0.05 ms freeing items 0.13 ms cleaning up 0.04 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.78 ms Utolsó lekérdezés után: 0.68 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 4.319 MB
UPDATE slib0_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '330'Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE slib0_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '330'Status Duration starting 0.12 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.12 ms updating 0.22 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 13 Joomla\CMS\Table\Table->hit() JROOT/components/com_k2/models/item.php:840 12 K2ModelItem->hit() JROOT/components/com_k2/views/item/view.html.php:146 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:57 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57 - Lekérdezés ideje: 0.97 ms Utolsó lekérdezés után: 0.25 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 4.323 MB Visszaadott sorok: 1
SELECT *
FROM slib0_k2_items
WHERE id != 330
AND catid = 80
AND ordering < 3
AND published = 1
AND trash = 0
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-08-14 19:08:18')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-08-14 19:08:18')
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 ref PRIMARY,catid,ordering,idx_item catid 4 const 8 0.62 Using where; Fájlrendezés használata Status Duration starting 0.12 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.17 ms preparing 0.06 ms executing 0.12 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.06 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: 1.05 ms Utolsó lekérdezés után: 1.69 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 4.398 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 = 185
ORDER BY xref.id ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xref NULL ref tagID,itemID itemID 4 const 1 100.00 NULL 1 SIMPLE tag NULL eq_ref PRIMARY,published PRIMARY 4 oyabun_info.xref.tagID 1 99.74 Using where Status Duration starting 0.22 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.17 ms preparing 0.06 ms executing 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.40 ms cleaning up 0.05 ms # Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/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:292 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.37 ms Utolsó lekérdezés után: 0.27 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 4.405 MB Visszaadott sorok: 0
SELECT *
FROM slib0_k2_attachments
WHERE itemID=185id 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.06 ms Executing hook on transaction 0.00 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.06 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 3.22 ms cleaning up 0.06 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:292 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.49 ms Utolsó lekérdezés után: 3.15 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 4.391 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.05 ms Executing hook on transaction 0.00 ms starting 0.00 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.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.01 ms # Hívó Fájl és sorok száma 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/plugins/k2/sppagebuilder/sppagebuilder.php:99 16 plgK2Sppagebuilder->isSppagebuilderEnabled() JROOT/plugins/k2/sppagebuilder/sppagebuilder.php:84 15 plgK2Sppagebuilder->onK2PrepareContent() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:792 12 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php:293 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: 13.93 ms Utolsó lekérdezés után: 0.15 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 4.402 MB Visszaadott sorok: 0Duplikált lekérdezések: #96
SELECT *
FROM `slib0_sppagebuilder`
WHERE `extension` = 'com_k2'
AND `extension_view` = 'item'
AND `view_id` = '185'
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.19 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.13 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.04 ms preparing 0.04 ms executing 1.09 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.05 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:293 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: 19.55 ms Utolsó lekérdezés után: 0.36 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 4.411 MB Visszaadott sorok: 0Duplikált lekérdezések: #95
SELECT *
FROM `slib0_sppagebuilder`
WHERE `extension` = 'com_k2'
AND `extension_view` = 'item'
AND `view_id` = '185'
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.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 11.42 ms init 0.02 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.04 ms preparing 0.04 ms executing 7.55 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.74 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:293 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.14 ms Utolsó lekérdezés után: 0.52 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 4.419 MB Visszaadott sorok: 1
SELECT *
FROM slib0_k2_items
WHERE id != 330
AND catid = 80
AND ordering > 3
AND published = 1
AND trash = 0
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-08-14 19:08:18')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-08-14 19:08:18')
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 8 0.70 Using where; Fájlrendezés használata 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.04 ms statistics 0.17 ms preparing 0.06 ms executing 0.15 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 3.36 ms cleaning up 0.11 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: 1.42 ms Utolsó lekérdezés után: 1.95 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 4.493 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 = 329
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.16 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.05 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.14 ms preparing 0.05 ms executing 0.49 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.57 ms cleaning up 0.06 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: 13.21 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: 4.501 MB Visszaadott sorok: 0
SELECT *
FROM slib0_k2_attachments
WHERE itemID=329id 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.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.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.04 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1429 13 K2ModelItem->getItemAttachments() JROOT/components/com_k2/models/item.php:163 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php: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: 4.61 ms Utolsó lekérdezés után: 37.89 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 4.492 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.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.03 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.05 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/plugins/k2/sppagebuilder/sppagebuilder.php:99 16 plgK2Sppagebuilder->isSppagebuilderEnabled() JROOT/plugins/k2/sppagebuilder/sppagebuilder.php:84 15 plgK2Sppagebuilder->onK2PrepareContent() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:792 12 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php: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.52 ms Utolsó lekérdezés után: 0.22 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 4.503 MB Visszaadott sorok: 0Duplikált lekérdezések: #102
SELECT *
FROM `slib0_sppagebuilder`
WHERE `extension` = 'com_k2'
AND `extension_view` = 'item'
AND `view_id` = '329'
AND `active` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_sppagebuilder NULL ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 384 0.26 Using where Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.00 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.02 ms preparing 0.02 ms executing 1.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.02 ms cleaning up 0.04 ms # Hívó Fájl és sorok száma 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/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: 4.68 ms Utolsó lekérdezés után: 0.20 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 4.512 MB Visszaadott sorok: 0Duplikált lekérdezések: #101
SELECT *
FROM `slib0_sppagebuilder`
WHERE `extension` = 'com_k2'
AND `extension_view` = 'item'
AND `view_id` = '329'
AND `active` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE slib0_sppagebuilder NULL ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 384 0.26 Using where Status Duration starting 0.07 ms Executing hook on transaction 0.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.02 ms preparing 0.03 ms executing 2.08 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.05 ms cleaning up 0.01 ms # Hívó Fájl és sorok száma 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:291 17 SppagebuilderHelper::getPageContent() JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:248 16 SppagebuilderHelper::onIntegrationPrepareContent() JROOT/plugins/k2/sppagebuilder/sppagebuilder.php: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: 0.93 ms Utolsó lekérdezés után: 93.87 ms Memória lekérdezése: 0.033 MB memória a lekérdezés előtt: 4.722 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.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.22 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.03 ms freeing items 0.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/administrator/components/com_acymailing/compat/joomla.php:481 13 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:17 12 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:438 11 acymailing_config() JROOT/administrator/components/com_acymailing/compat/joomla.php:822 10 include_once JROOT/administrator/components/com_acymailing/compat/joomla.php JROOT/administrator/components/com_acymailing/helpers/helper.php:22 9 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/plugins/system/regacymailing/regacymailing.php:22 8 plgSystemRegacymailing->initAcy() JROOT/plugins/system/regacymailing/regacymailing.php:146 7 plgSystemRegacymailing->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:57
57 naplózott lekérdezéstípus, rendezés előfordulás szerint
SELECT táblák:
14 × SELECT `storage_value`
FROM `slib0_securitycheckpro_storage`8 × SELECT extension_id
FROM slib0_extensions6 × SELECT *
FROM `slib0_sppagebuilder`4 × SELECT COUNT(*)
from slib0_securitycheckpro_db4 × SELECT *
FROM slib0_securitycheckpro_blacklis4 × SELECT enabled
FROM slib0_extensions3 × SELECT tag.*
FROM slib0_k2_tags AS tag JOIN slib0_k2_tags_xref AS xref
ON tag.id = xref.tagID3 × SELECT *
FROM slib0_k2_attachments2 × SELECT `extension_id`
FROM `slib0_extensions`2 × SELECT *
FROM slib0_extensions2 × SELECT *
FROM slib0_securitycheckpro_whitelis2 × SELECT *
FROM slib0_k2_categories2 × 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 × INSERT INTO `slib0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3437373835366432633066353130613562633363616661666235623731356664', 1, 1786734498, 0, '', 01 × DELETE
FROM slib0_securitycheckpro_dynamic_blacklist1 × SHOW FULL COLUMNS
FROM `slib0_extensions1 × UPDATE `slib0_extensions`
SET `params` = '{\"mediaversion\":\"4bfc8e3ed8a54dcb7e477dfb45a95ed1\"}'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)
Amennyiben úgy