Részletek:
| Megjelent: 2013. július 19.
Miért írunk le ma minden gondolatot, ha tegnap se volt értelme?!.
Joomla! hibakereső konzol
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1771344181,
"last": 1771344181,
"now": 1771344181
},
"token": "WBqUooSszUCBYnK6kgcERFbLSli5B0eu"
},
"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ő: 17.69 ms / 17.69 ms Memória: 0.405 MB / 0.75 MB Application: afterLoad
Idő: 118.30 ms / 135.99 ms Memória: 0.818 MB / 1.57 MB Application: afterInitialise
Idő: 38.52 ms / 174.51 ms Memória: 0.465 MB / 2.03 MB Application: afterRoute
Idő: 81.59 ms / 256.10 ms Memória: 0.048 MB / 2.08 MB Application: beforeRenderComponent com_content
Idő: 5.53 ms / 261.63 ms Memória: 0.051 MB / 2.13 MB Application: Before Access::preloadComponents (all components)
Idő: 4.55 ms / 266.18 ms Memória: 0.057 MB / 2.19 MB Application: After Access::preloadComponents (all components)
Idő: 0.04 ms / 266.22 ms Memória: -0.003 MB / 2.19 MB Application: Before Access::preloadPermissions (com_content)
Idő: 1.24 ms / 267.46 ms Memória: 0.146 MB / 2.33 MB Application: After Access::preloadPermissions (com_content)
Idő: 0.03 ms / 267.50 ms Memória: -0.011 MB / 2.32 MB Application: Before Access::getAssetRules (id:50 name:com_content.article.6)
Idő: 0.85 ms / 268.35 ms Memória: 0.009 MB / 2.33 MB Application: After Access::getAssetRules (id:50 name:com_content.article.6)
Idő: 82.40 ms / 350.75 ms Memória: 0.144 MB / 2.47 MB Application: afterRenderComponent com_content
Idő: 26.18 ms / 376.93 ms Memória: 0.010 MB / 2.48 MB Application: afterDispatch
Idő: 23.69 ms / 400.62 ms Memória: 0.088 MB / 2.57 MB Application: afterRender
Adatbázislekérdezés összesen: 205.28 ms
2,76 MB (2.892.520 Bájtok)
14 naplózott lekérdezés 205.28 ms
- Lekérdezés ideje: 0.76 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 1.029 MB Visszaadott sorok: 0
SELECT `data`
FROM `jos_session`
WHERE `session_id` = X'72356669396c75746a6c6432716938396b76646170626b76616d'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.09 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.11 ms Preparing 0.02 ms Executing 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 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: 0.92 ms Utolsó lekérdezés után: 2.12 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 `jos_session`
WHERE `session_id` = X'72356669396c75746a6c6432716938396b76646170626b76616d'
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.06 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 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/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: 49.71 ms Utolsó lekérdezés után: 0.14 ms Memória lekérdezése: 0.004 MB memória a lekérdezés előtt: 1.048 MB
INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'72356669396c75746a6c6432716938396b76646170626b76616d', 1, 1771344181, 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'72356669396c75746a6c6432716938396b76646170626b76616d', 1, 1771344181, 0, '', 0)Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.03 ms Update 0.11 ms Waiting for query cache lock 0.01 ms Update 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 49.02 ms closing tables 0.03 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.05 ms Reset for next command 0.01 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.29 ms Utolsó lekérdezés után: 6.41 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.119 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.11 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.03 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.04 ms Preparing 0.05 ms Executing 0.02 ms Sending data 0.19 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.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.06 ms Reset for next command 0.02 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: 1.06 ms Utolsó lekérdezés után: 0.15 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.131 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.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.06 ms Optimizing 0.05 ms Statistics 0.15 ms Preparing 0.03 ms Unlocking tables 0.02 ms Preparing 0.06 ms Executing 0.03 ms Sending data 0.11 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.05 ms Reset for next command 0.04 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: 2.63 ms Utolsó lekérdezés után: 54.28 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 1.831 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.12 ms checking permissions 0.03 ms closing tables 0.02 ms Opening tables 1.10 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.04 ms Preparing 0.05 ms Executing 0.02 ms Filling schema table 0.02 ms Opening tables 0.14 ms After opening tables 0.02 ms checking permissions 0.12 ms closing tables 0.04 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.31 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.06 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.86 ms Utolsó lekérdezés után: 0.19 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 1.845 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.08 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.05 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.08 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.13 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.05 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: 3.87 ms Utolsó lekérdezés után: 8.71 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.013 MB Visszaadott sorok: 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)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 6
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.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.63 ms init 1.43 ms Optimizing 0.17 ms Statistics 0.28 ms Preparing 0.03 ms Unlocking tables 0.02 ms Preparing 0.06 ms Sorting result 0.04 ms Executing 0.02 ms Sending data 0.05 ms Creating sort index 0.22 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.03 ms Updating status 0.05 ms Reset for next command 0.04 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/Categories/Categories.php:324 12 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 11 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/helpers/legacyrouter.php:350 10 ContentRouterRulesLegacy->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 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.92 ms Utolsó lekérdezés után: 0.84 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.027 MB Visszaadott sorok: 1
SELECT `alias`,`catid`
FROM `jos_content`
WHERE `id` = 6id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos_content const PRIMARY PRIMARY 4 const 1 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.03 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.02 ms Unlocking tables 0.05 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.12 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/components/com_content/helpers/legacyrouter.php:366 10 ContentRouterRulesLegacy->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 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: 72.44 ms Utolsó lekérdezés után: 2.20 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 2.035 MB
UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"14b9911e1b6a919458b44f25066753f9\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"14b9911e1b6a919458b44f25066753f9\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.11 ms checking permissions 0.02 ms Opening tables 0.08 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init for update 0.25 ms Updating 0.17 ms End of update loop 0.02 ms Waiting for query cache lock 0.01 ms End of update loop 0.02 ms Query end 0.01 ms Commit 71.11 ms closing tables 0.04 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.15 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: 1.83 ms Utolsó lekérdezés után: 15.24 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 2.136 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 188 Using where Status Duration Starting 0.52 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.03 ms Statistics 0.17 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.39 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 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/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 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.90 ms Utolsó lekérdezés után: 0.25 ms Memória lekérdezése: 0.038 MB memória a lekérdezés előtt: 2.186 MB Visszaadott sorok: 141
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 188 Using where Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.28 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 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/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 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.85 ms Utolsó lekérdezés után: 2.00 ms Memória lekérdezése: 0.031 MB memória a lekérdezés előtt: 2.331 MB Visszaadott sorok: 31
SHOW FULL COLUMNS
FROM `jos_content`Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `jos_content`Status Duration Starting 0.18 ms checking permissions 0.02 ms closing tables 0.01 ms Opening tables 0.62 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms checking permissions 0.19 ms closing tables 0.02 ms Executing 0.01 ms Sending data 0.09 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.20 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Hívó Fájl és sorok száma 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 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: 66.23 ms Utolsó lekérdezés után: 4.94 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 2.380 MB
UPDATE jos_content
SET `hits` = (`hits` + 1)
WHERE `id` = '6'Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE jos_content SET `hits` = (`hits` + 1) WHERE `id` = '6'Status Duration Starting 0.08 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.10 ms Updating 0.12 ms End of update loop 0.02 ms Waiting for query cache lock 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 65.44 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.06 ms Reset for next command 0.02 ms # Hívó Fájl és sorok száma 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 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
13 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`1 × SELECT `data`
FROM `jos_session`1 × SELECT `session_id`
FROM `jos_session`1 × SELECT id, rules
FROM `jos_viewlevels1 × 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 *
FROM jos_komento_configs1 × 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 `alias`,`catid`
FROM `jos_content`
EGYÉB táblák:
1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'72356669396c75746a6c6432716938396b76646170626b76616d', 1, 1771344181, 0, '', 01 × SHOW FULL COLUMNS
FROM `jos_komento_configs1 × UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"14b9911e1b6a919458b44f25066753f9\"}'1 × SHOW FULL COLUMNS
FROM `jos_content1 × UPDATE jos_content
SET `hits` = (`hits` + 1)