Joomla! hibakereső konzol
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1749194358,
"last": 1749194358,
"now": 1749194358
},
"token": "lAfNpR5cFB1kbKcGiRIM8GFNxYQUihuA"
},
"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
}
}
}
Idő
Memória
Idő: 32.59 ms / 32.59 ms Memória: 0.405 MB / 0.75 MB Application: afterLoad
Idő: 120.96 ms / 153.55 ms Memória: 0.817 MB / 1.57 MB Application: afterInitialise
Idő: 34.57 ms / 188.12 ms Memória: 0.373 MB / 1.94 MB Application: afterRoute
Idő: 95.94 ms / 284.05 ms Memória: 0.125 MB / 2.07 MB Application: beforeRenderComponent com_content
Idő: 22.15 ms / 306.20 ms Memória: 0.109 MB / 2.17 MB Application: Before Access::preloadComponents (all components)
Idő: 1.49 ms / 307.69 ms Memória: 0.057 MB / 2.23 MB Application: After Access::preloadComponents (all components)
Idő: 0.03 ms / 307.72 ms Memória: -0.003 MB / 2.23 MB Application: Before Access::preloadPermissions (com_content)
Idő: 1.33 ms / 309.05 ms Memória: 0.146 MB / 2.38 MB Application: After Access::preloadPermissions (com_content)
Idő: 0.03 ms / 309.09 ms Memória: -0.011 MB / 2.36 MB Application: Before Access::getAssetRules (id:43 name:com_content.category.10)
Idő: 0.94 ms / 310.02 ms Memória: 0.009 MB / 2.37 MB Application: After Access::getAssetRules (id:43 name:com_content.category.10)
Idő: 6.17 ms / 316.19 ms Memória: 0.103 MB / 2.48 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Idő: 0.06 ms / 316.25 ms Memória: 0.007 MB / 2.48 MB Application: After Access::getAssetRules (id:8 name:com_content)
Idő: 134.69 ms / 450.93 ms Memória: 0.427 MB / 2.91 MB Application: afterRenderComponent com_content
Idő: 7.40 ms / 458.33 ms Memória: 0.008 MB / 2.92 MB Application: afterDispatch
Idő: 15.61 ms / 473.94 ms Memória: 0.065 MB / 2.98 MB Application: afterRender
Adatbázislekérdezés összesen: 213.61 ms
3,47 MB (3.640.400 Bájtok)
28 naplózott lekérdezés 213.61 ms
- Lekérdezés ideje: 6.98 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 1.030 MB Visszaadott sorok: 0
SELECT `data`
FROM `jos_session`
WHERE `session_id` = X'6e316e61306b76676b377569653375623770716e763062616865'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.08 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.08 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.04 ms Executing 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.02 ms # Hívó Fájl és sorok száma 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Ugyanaz a hívás, mint egy sorral lejjebb. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Lekérdezés ideje: 13.91 ms Utolsó lekérdezés után: 1.96 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 1.044 MB Visszaadott sorok: 0
SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = X'6e316e61306b76676b377569653375623770716e763062616865'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.02 ms Executing 0.04 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.02 ms # Hívó Fájl és sorok száma 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/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:46 - Lekérdezés ideje: 31.94 ms Utolsó lekérdezés után: 0.18 ms Memória lekérdezése: 0.004 MB memória a lekérdezés előtt: 1.049 MB
INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6e316e61306b76676b377569653375623770716e763062616865', 1, 1749194358, 0, '', 0)Az EXPLAIN nem lehetséges a következő lekérdezésen: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6e316e61306b76676b377569653375623770716e763062616865', 1, 1749194358, 0, '', 0)Status Duration Starting 0.09 ms checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init for update 0.03 ms Update 0.11 ms End of update loop 0.03 ms Query end 0.02 ms Commit 31.10 ms closing tables 0.05 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.02 ms # 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:46 - Lekérdezés ideje: 1.39 ms Utolsó lekérdezés után: 4.49 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 1.088 MB Visszaadott sorok: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_extensions ref extension extension 82 const 40 Using index condition; Using where Status Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.08 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.53 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.05 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.02 ms # Hívó Fájl és sorok száma 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Ugyanaz a hívás, mint egy sorral lejjebb. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.70 ms Utolsó lekérdezés után: 2.85 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.113 MB Visszaadott sorok: 4
SELECT id, rules
FROM `jos_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_viewlevels ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 4 Status Duration Starting 0.05 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.07 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.06 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:49 - Lekérdezés ideje: 0.76 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: 1.125 MB Visszaadott sorok: 2
SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 Using where; Using index Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.03 ms Unlocking tables 0.02 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.05 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 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:49 - Lekérdezés ideje: 1.73 ms Utolsó lekérdezés után: 1.67 ms Memória lekérdezése: 0.030 MB memória a lekérdezés előtt: 1.150 MB Visszaadott sorok: 84
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jos_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_extensions ALL extension NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 223 Using where; Fájlrendezés használata Status Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.02 ms Creating sort index 0.97 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 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:49 - Lekérdezés ideje: 1.95 ms Utolsó lekérdezés után: 39.23 ms Memória lekérdezése: 0.044 MB memória a lekérdezés előtt: 1.598 MB Visszaadott sorok: 11
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 jos_menu AS m
LEFT JOIN jos_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 type possible_keys key key_len ref rows Extra 1 SIMPLE m range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 12 Using index condition; Using where; Fájlrendezés használata 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 c1_dorothysmith.m.component_id 1 Using where Status Duration Starting 0.19 ms checking permissions 0.04 ms Opening tables 0.38 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.15 ms Preparing 0.06 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 0.46 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.05 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.03 ms # Hívó Fájl és sorok száma 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{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/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 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:49 - Lekérdezés ideje: 4.64 ms Utolsó lekérdezés után: 15.61 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 1.829 MB Visszaadott sorok: 2
SHOW FULL COLUMNS
FROM `jos_komento_configs`Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `jos_komento_configs`Status Duration Starting 0.07 ms checking permissions 0.02 ms closing tables 0.02 ms Opening tables 0.56 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.02 ms Filling schema table 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms checking permissions 0.09 ms closing tables 0.03 ms Executing 2.86 ms Sending data 0.13 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Removing tmp table 0.21 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/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:585 11 Joomla\CMS\Table\Table->reset() JROOT/libraries/src/Table/Table.php:724 10 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_komento/includes/komento.php:399 9 KT::config() JROOT/components/com_komento/bootstrap.php:52 8 require_once JROOT/components/com_komento/bootstrap.php JROOT/components/com_komento/router.php:14 7 require_once JROOT/components/com_komento/router.php JROOT/libraries/src/Router/SiteRouter.php:779 6 Joomla\CMS\Router\SiteRouter->getComponentRouter() JROOT/libraries/src/Router/SiteRouter.php:131 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 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:49 - Lekérdezés ideje: 0.74 ms Utolsó lekérdezés után: 0.17 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 1.842 MB Visszaadott sorok: 0
SELECT *
FROM jos_komento_configs
WHERE `name` = 'config'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_komento_configs ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 7 Using where Status Duration Starting 0.05 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.07 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.10 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Hívó Fájl és sorok száma 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 10 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_komento/includes/komento.php:399 9 KT::config() JROOT/components/com_komento/bootstrap.php:52 8 require_once JROOT/components/com_komento/bootstrap.php JROOT/components/com_komento/router.php:14 7 require_once JROOT/components/com_komento/router.php JROOT/libraries/src/Router/SiteRouter.php:779 6 Joomla\CMS\Router\SiteRouter->getComponentRouter() JROOT/libraries/src/Router/SiteRouter.php:131 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 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:49 - Lekérdezés ideje: 1.79 ms Utolsó lekérdezés után: 8.03 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 1.961 MB Visszaadott sorok: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.09 ms checking permissions 0.03 ms Opening tables 0.05 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.03 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.12 ms Preparing 0.06 ms Executing 0.03 ms Sending data 0.88 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.05 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Hívó Fájl és sorok száma 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Ugyanaz a hívás, mint egy sorral lejjebb. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 75.95 ms Utolsó lekérdezés után: 0.89 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 1.951 MB
UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"29af470cb67e3fcf514fe9d4ba56a56b\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"29af470cb67e3fcf514fe9d4ba56a56b\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.07 ms checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init for update 0.13 ms Updating 0.15 ms End of update loop 0.04 ms Query end 0.03 ms Commit 73.82 ms closing tables 0.04 ms Unlocking tables 0.02 ms closing tables 0.05 ms Starting cleanup 0.02 ms Freeing items 0.04 ms Updating status 0.04 ms Reset for next command 0.02 ms # Hívó Fájl és sorok száma 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 5.39 ms Utolsó lekérdezés után: 2.96 ms Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 2.044 MB Visszaadott sorok: 1
SELECT *
FROM jos_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_languages ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 1 Using where; Fájlrendezés használata Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 0.30 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Hívó Fájl és sorok száma 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 2.26 ms Utolsó lekérdezés után: 2.32 ms Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 2.058 MB Visszaadott sorok: 5
SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_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 type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template,idx_client_id,idx_client_id_home NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 7 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 c1_dorothysmith.s.template,const 1 Using index condition; Using where Status Duration Starting 0.09 ms checking permissions 0.03 ms Opening tables 0.05 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.02 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.13 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.14 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.04 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Hívó Fájl és sorok száma 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 1.19 ms Utolsó lekérdezés után: 24.66 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 2.179 MB Visszaadott sorok: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','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_extplorer','com_fields','com_finder','com_installer','com_joomlaupdate','com_komento','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_oneclickregistration','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_assets ALL idx_asset_name NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 186 Using where Status Duration Starting 0.12 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.14 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.31 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.04 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Hívó Fájl és sorok száma 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 19 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 14 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.98 ms Utolsó lekérdezés után: 0.24 ms Memória lekérdezése: 0.039 MB memória a lekérdezés előtt: 2.230 MB Visszaadott sorok: 139
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_assets ALL idx_asset_name,idx_parent_id NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 186 Using where Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.26 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.02 ms # Hívó Fájl és sorok száma 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 19 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 14 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 2.13 ms Utolsó lekérdezés után: 3.85 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 2.443 MB Visszaadott sorok: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `jos_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 10
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 PRIMARY c ALL cat_idx,idx_left_right NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 14 Using where; Fájlrendezés használata 2 DEPENDENT SUBQUERY i ref idx_state,idx_catid idx_catid 4 c1_dorothysmith.c.id 6 Using index condition; Using where Status Duration Starting 0.16 ms checking permissions 0.03 ms Opening tables 0.07 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.09 ms Optimizing 0.05 ms Statistics 0.12 ms Preparing 0.03 ms Unlocking tables 0.02 ms Preparing 0.04 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.06 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.04 ms Creating sort index 0.20 ms Executing 0.03 ms Sending data 0.23 ms Executing 0.02 ms Sending data 0.28 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.05 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Removing tmp table 0.02 ms Freeing items 0.03 ms Updating status 0.03 ms Reset for next command 0.03 ms # Hívó Fájl és sorok száma 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 16 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 15 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/category.php:355 14 ContentModelCategory->getCategory() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:122 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 2.23 ms Utolsó lekérdezés után: 1.57 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 2.482 MB Visszaadott sorok: 1
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid = 10
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-06 07:19:18')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-06 07:19:18')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 35, 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a ref idx_access,idx_state,idx_catid idx_catid 4 const 37 Using where; Fájlrendezés használata 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 c1_dorothysmith.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 c1_dorothysmith.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 const 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 c1_dorothysmith.a.id 1 Using where Status Duration Starting 0.24 ms checking permissions 0.03 ms Opening tables 0.07 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.14 ms Optimizing 0.08 ms Statistics 0.16 ms Preparing 0.03 ms Unlocking tables 0.02 ms Preparing 0.07 ms Sorting result 0.04 ms Executing 0.02 ms Sending data 0.05 ms Creating sort index 0.84 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.04 ms Starting cleanup 0.02 ms Freeing items 0.03 ms Updating status 0.04 ms Reset for next command 0.03 ms # Hívó Fájl és sorok száma 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 14.07 ms Utolsó lekérdezés után: 1.35 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 2.522 MB Visszaadott sorok: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 6
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 c1_dorothysmith.m.tag_id 1 Using where Status Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.10 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.06 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Hívó Fájl és sorok száma 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 16 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 1.42 ms Utolsó lekérdezés után: 1.32 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 2.531 MB Visszaadott sorok: 1
SELECT COUNT(*)
FROM jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid = 10
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-06 07:19:18')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-06 07:19:18')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a ref idx_access,idx_state,idx_catid idx_catid 4 const 37 Using where Status Duration Starting 0.17 ms checking permissions 0.03 ms Opening tables 0.09 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.07 ms Optimizing 0.07 ms Statistics 0.21 ms Preparing 0.03 ms Unlocking tables 0.02 ms Preparing 0.09 ms Executing 0.02 ms Sending data 0.20 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.04 ms # Hívó Fájl és sorok száma 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:289 16 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:239 15 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/components/com_content/models/category.php:265 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.97 ms Utolsó lekérdezés után: 0.29 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 2.533 MB Visszaadott sorok: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 10
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 c1_dorothysmith.m.tag_id 1 Using where Status Duration Starting 0.08 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.09 ms Preparing 0.05 ms Executing 0.02 ms Sending data 0.06 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 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/TagsHelper.php:454 13 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/libraries/src/MVC/View/CategoryView.php:229 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 1.28 ms Utolsó lekérdezés után: 4.39 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 2.578 MB Visszaadott sorok: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 10
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 14 Using where; Fájlrendezés használata Status Duration Starting 0.14 ms checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.07 ms Optimizing 0.05 ms Statistics 0.15 ms Preparing 0.03 ms Unlocking tables 0.02 ms Preparing 0.04 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 0.20 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Hívó Fájl és sorok száma 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 2.61 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: 2.594 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 jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jos_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (10,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 c1_dorothysmith.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 c1_dorothysmith.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 c1_dorothysmith.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 c1_dorothysmith.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 c1_dorothysmith.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 c1_dorothysmith.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.16 ms checking permissions 0.03 ms Opening tables 0.09 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.11 ms Optimizing 0.09 ms Statistics 0.26 ms Preparing 0.10 ms Creating tmp table 0.11 ms Sorting result 0.04 ms Executing 0.02 ms Sending data 0.78 ms Creating sort index 0.16 ms Removing tmp table 0.22 ms Creating sort index 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.03 ms Updating status 0.03 ms Reset for next command 0.03 ms # Hívó Fájl és sorok száma 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.92 ms Utolsó lekérdezés után: 3.74 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 2.696 MB Visszaadott sorok: 1
SELECT a.`id`, a.`title`, a.`alias`, a.`catid`, a.`created_by`, a.`created_by_alias`, a.`hits`, a.`state`, a.`language`, c.`title` AS category_title, c.`alias` AS category_alias, u.`name` AS author, parent.`id` AS parent_id, parent.`alias` AS parent_alias
FROM `jos_content` AS a
LEFT JOIN `jos_categories` AS c
ON c.`id` = a.`catid`
LEFT JOIN `jos_users` AS u
ON u.`id` = a.`created_by`
LEFT JOIN `jos_categories` AS parent
ON parent.`id` = c.`parent_id`
WHERE a.`id` = '6'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.10 ms checking permissions 0.03 ms Opening tables 0.07 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.12 ms Preparing 0.03 ms Unlocking tables 0.02 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Hívó Fájl és sorok száma 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 21 JDatabaseDriver->loadObject() JROOT/administrator/components/com_komento/includes/database/database.php:288 20 KomentoDatabaseJoomla->__call() JROOT/administrator/components/com_komento/includes/database/database.php:35 19 KomentoDatabase->__call() JROOT/components/com_komento/komento_plugins/com_content.php:49 18 KomentoComcontent->load() JROOT/administrator/components/com_komento/includes/commentify/commentify.php:265 17 KomentoCommentify->render() JROOT/administrator/components/com_komento/includes/komento.php:706 16 KT::commentify() JROOT/plugins/content/komento/komento.php:147 15 plgContentKomento->execute() JROOT/plugins/content/komento/komento.php:74 14 plgContentKomento->onContentAfterDisplay() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:124 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 30.05 ms Utolsó lekérdezés után: 40.76 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 2.794 MB Visszaadott sorok: 1
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_content'
AND `cid` = '6'
AND `published` = '1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.10 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Hívó Fájl és sorok száma 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 22 JDatabaseDriver->loadResult() JROOT/administrator/components/com_komento/includes/database/database.php:288 21 KomentoDatabaseJoomla->__call() JROOT/administrator/components/com_komento/includes/database/database.php:35 20 KomentoDatabase->__call() JROOT/administrator/components/com_komento/models/comments.php:100 19 KomentoModelComments->getCount() JROOT/administrator/components/com_komento/includes/commentify/commentify.php:643 18 KomentoCommentify->listings() JROOT/administrator/components/com_komento/includes/commentify/commentify.php:315 17 KomentoCommentify->render() JROOT/administrator/components/com_komento/includes/komento.php:706 16 KT::commentify() JROOT/plugins/content/komento/komento.php:147 15 plgContentKomento->execute() JROOT/plugins/content/komento/komento.php:74 14 plgContentKomento->onContentAfterDisplay() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:124 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 0.86 ms Utolsó lekérdezés után: 0.36 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 2.809 MB Visszaadott sorok: 1
SELECT `template`
FROM `jos_template_styles`
WHERE `home`!='0'
AND `client_id`='0'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_template_styles range idx_client_id,idx_client_id_home idx_client_id_home 29 NULL 2 Using index condition Status Duration Starting 0.09 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.11 ms Preparing 0.05 ms Executing 0.02 ms Sending data 0.07 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.06 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Hívó Fájl és sorok száma 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 23 JDatabaseDriver->loadResult() JROOT/libraries/foundry/helper.php:553 22 FH::getCurrentTemplate() JROOT/administrator/components/com_komento/includes/template/template.php:200 21 KomentoTemplate->resolve() JROOT/administrator/components/com_komento/includes/template/template.php:94 20 KomentoTemplate->getFileStructure() JROOT/administrator/components/com_komento/includes/themes/themes.php:27 19 KomentoThemes->output() JROOT/administrator/components/com_komento/includes/commentify/commentify.php:691 18 KomentoCommentify->listings() JROOT/administrator/components/com_komento/includes/commentify/commentify.php:315 17 KomentoCommentify->render() JROOT/administrator/components/com_komento/includes/komento.php:706 16 KT::commentify() JROOT/plugins/content/komento/komento.php:147 15 plgContentKomento->execute() JROOT/plugins/content/komento/komento.php:74 14 plgContentKomento->onContentAfterDisplay() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:124 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 2.60 ms Utolsó lekérdezés után: 9.85 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 2.915 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 jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.categories'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 c1_dorothysmith.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 c1_dorothysmith.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 c1_dorothysmith.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 c1_dorothysmith.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 c1_dorothysmith.a.group_id 1 Using where Status Duration Starting 0.18 ms checking permissions 0.03 ms Opening tables 0.09 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.08 ms Optimizing 0.06 ms Statistics 0.18 ms Preparing 0.09 ms Creating tmp table 0.15 ms Sorting result 0.05 ms Executing 0.02 ms Sending data 0.77 ms Creating sort index 0.17 ms Removing tmp table 0.21 ms Creating sort index 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.08 ms Updating status 0.03 ms Reset for next command 0.03 ms # Hívó Fájl és sorok száma 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 23 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 22 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 21 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 20 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 19 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 18 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 17 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:19 16 require JROOT/components/com_content/views/category/tmpl/blog.php JROOT/templates/dorothysmith2/html/com_content/category/blog.php:17 15 include JROOT/templates/dorothysmith2/html/com_content/category/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Lekérdezés ideje: 2.17 ms Utolsó lekérdezés után: 1.07 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 2.930 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 jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jos_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.categories'
AND (fc.category_id IS NULL OR fc.category_id IN (10,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 c1_dorothysmith.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 c1_dorothysmith.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 c1_dorothysmith.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 c1_dorothysmith.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 c1_dorothysmith.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 c1_dorothysmith.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.16 ms checking permissions 0.03 ms Opening tables 0.06 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.08 ms Optimizing 0.06 ms Statistics 0.16 ms Preparing 0.08 ms Creating tmp table 0.08 ms Sorting result 0.04 ms Executing 0.02 ms Sending data 0.70 ms Creating sort index 0.10 ms Removing tmp table 0.15 ms Creating sort index 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.03 ms Updating status 0.03 ms Reset for next command 0.03 ms # Hívó Fájl és sorok száma 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 24 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 23 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 22 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 21 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:404 20 PlgSystemFields->display() JROOT/plugins/system/fields/fields.php:324 19 PlgSystemFields->onContentAfterTitle() JROOT/libraries/joomla/event/event.php:70 18 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 17 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:22 16 require JROOT/components/com_content/views/category/tmpl/blog.php JROOT/templates/dorothysmith2/html/com_content/category/blog.php:17 15 include JROOT/templates/dorothysmith2/html/com_content/category/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
24 naplózott lekérdezéstípus, rendezés előfordulás szerint
SELECT táblák:
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`2 × 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 jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jos_fields_categories` AS fc
ON fc.field_id = a.id2 × SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id1 × SELECT `template`
FROM `jos_template_styles`1 × SELECT COUNT(1)
FROM `jos_komento_comments`1 × SELECT a.`id`, a.`title`, a.`alias`, a.`catid`, a.`created_by`, a.`created_by_alias`, a.`hits`, a.`state`, a.`language`, c.`title` AS category_title, c.`alias` AS category_alias, u.`name` AS author, parent.`id` AS parent_id, parent.`alias` AS parent_alias
FROM `jos_content` AS a
LEFT JOIN `jos_categories` AS c
ON c.`id` = a.`catid`
LEFT JOIN `jos_users` AS u
ON u.`id` = a.`created_by`
LEFT JOIN `jos_categories` AS parent
ON parent.`id` = c.`parent_id`1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)1 × SELECT COUNT(*)
FROM jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id1 × SELECT `data`
FROM `jos_session`1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `jos_content` AS `i`1 × SELECT `session_id`
FROM `jos_session`1 × SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM jos_languages1 × SELECT *
FROM jos_komento_configs1 × 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 jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jos_extensions1 × SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `jos_viewlevels1 × 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 jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
EGYÉB táblák:
1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6e316e61306b76676b377569653375623770716e763062616865', 1, 1749194358, 0, '', 01 × SHOW FULL COLUMNS
FROM `jos_komento_configs1 × UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"29af470cb67e3fcf514fe9d4ba56a56b\"}'