| Tweet |
2021. szeptember
2021. szeptember - Tartalom
Közéleti programajánló
Kulturális programajánló
Hírlevél
A magyar online kiadásról
A magyar változat
szerkesztőségének
e-mail címe:
info@magyardiplo.hu
A rendszer használata közben bizonyos esetekben Önnel kapcsolatos adatokat kezelünk és adatokat (cookie -kat) tárolunk az Ön gépén. Erreől itt olvashat részletesebben. A vonatkozó rendelkezések értemében (lásd itt) mindehez az Ön hozzájárulása szükséges. Hozzájárulok
Joomla! hibakereső konzol
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1632168057,
"last": 1632168057,
"now": 1632168057
},
"client": {
"forwarded": "3.236.55.22"
},
"token": "35aYXmF9VgTsTAF3IUmnHOd38WxlRh1c"
},
"registry": {
"plg_system_eprivacy_non_eu": false
},
"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ő: 19.03 ms / 19.03 ms Memória: 2.141 MB / 2.38 MB Application: afterLoad
Idő: 67.04 ms / 86.07 ms Memória: 7.760 MB / 10.14 MB Application: afterInitialise
Idő: 11.38 ms / 97.46 ms Memória: 0.930 MB / 11.07 MB Application: afterRoute
Idő: 2.34 ms / 99.80 ms Memória: 0.056 MB / 11.13 MB Application: beforeRenderComponent com_tags
Idő: 67.31 ms / 167.11 ms Memória: 4.777 MB / 15.91 MB Application: Before Access::preloadComponents (all components)
Idő: 0.60 ms / 167.71 ms Memória: 0.101 MB / 16.01 MB Application: After Access::preloadComponents (all components)
Idő: 0.05 ms / 167.75 ms Memória: 0.000 MB / 16.00 MB Application: Before Access::getAssetRules (id:35 name:com_tags)
Idő: 0.57 ms / 168.32 ms Memória: 0.051 MB / 16.05 MB Application: After Access::getAssetRules (id:35 name:com_tags)
Idő: 27.65 ms / 195.98 ms Memória: 0.904 MB / 16.96 MB Application: afterRenderComponent com_tags
Idő: 9.00 ms / 204.98 ms Memória: 0.167 MB / 17.12 MB Application: afterDispatch
Idő: 9.71 ms / 214.69 ms Memória: 0.345 MB / 17.47 MB Application: beforeRenderModule mod_tortags_often_clouds (cimkefelhő)
Idő: 14.16 ms / 228.84 ms Memória: 0.600 MB / 18.07 MB Application: afterRenderModule mod_tortags_often_clouds (cimkefelhő)
Idő: 0.12 ms / 228.96 ms Memória: 0.000 MB / 17.93 MB Application: beforeRenderModule mod_custom (Cimkék fejléc)
Idő: 0.66 ms / 229.62 ms Memória: 0.012 MB / 17.94 MB Application: afterRenderModule mod_custom (Cimkék fejléc)
Idő: 0.04 ms / 229.66 ms Memória: 0.000 MB / 17.94 MB Application: beforeRenderModule mod_custom (alsó menü)
Idő: 0.20 ms / 229.86 ms Memória: 0.007 MB / 17.94 MB Application: afterRenderModule mod_custom (alsó menü)
Idő: 0.03 ms / 229.89 ms Memória: 0.001 MB / 17.94 MB Application: beforeRenderModule mod_itpsocialbuttons (ajánló gombok alul)
Idő: 0.82 ms / 230.70 ms Memória: 0.034 MB / 17.98 MB Application: afterRenderModule mod_itpsocialbuttons (ajánló gombok alul)
Idő: 0.04 ms / 230.74 ms Memória: 0.000 MB / 17.97 MB Application: beforeRenderModule mod_custom (Admin link)
Idő: 0.20 ms / 230.94 ms Memória: 0.007 MB / 17.97 MB Application: afterRenderModule mod_custom (Admin link)
Idő: 0.02 ms / 230.96 ms Memória: 0.000 MB / 17.97 MB Application: beforeRenderModule mod_syndicate (RSS)
Idő: 0.90 ms / 231.87 ms Memória: 0.018 MB / 17.99 MB Application: afterRenderModule mod_syndicate (RSS)
Idő: 0.10 ms / 231.96 ms Memória: 0.000 MB / 17.98 MB Application: beforeRenderModule mod_custom (Ziegler)
Idő: 0.22 ms / 232.18 ms Memória: 0.008 MB / 17.99 MB Application: afterRenderModule mod_custom (Ziegler)
Idő: 0.03 ms / 232.21 ms Memória: 0.000 MB / 17.99 MB Application: beforeRenderModule mod_banners (KÖNYVAJÁNLÓ)
Idő: 4.78 ms / 236.99 ms Memória: 0.117 MB / 18.10 MB Application: afterRenderModule mod_banners (KÖNYVAJÁNLÓ)
Idő: 0.04 ms / 237.03 ms Memória: 0.000 MB / 18.09 MB Application: beforeRenderModule mod_syndicate (RSS hírcsatorna)
Idő: 0.56 ms / 237.59 ms Memória: 0.008 MB / 18.10 MB Application: afterRenderModule mod_syndicate (RSS hírcsatorna)
Idő: 0.10 ms / 237.69 ms Memória: 0.000 MB / 18.10 MB Application: beforeRenderModule mod_jumi (Tartalom)
Idő: 1.58 ms / 239.27 ms Memória: 0.077 MB / 18.17 MB Application: afterRenderModule mod_jumi (Tartalom)
Idő: 0.05 ms / 239.32 ms Memória: 0.000 MB / 18.17 MB Application: beforeRenderModule mod_articles_category (Közéleti programajánló)
Idő: 1.51 ms / 240.82 ms Memória: 0.131 MB / 18.30 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Idő: 0.08 ms / 240.90 ms Memória: 0.010 MB / 18.31 MB Application: After Access::getAssetRules (id:8 name:com_content)
Idő: 10.57 ms / 251.47 ms Memória: 0.064 MB / 18.37 MB Application: afterRenderModule mod_articles_category (Közéleti programajánló)
Idő: 0.09 ms / 251.56 ms Memória: 0.000 MB / 18.33 MB Application: beforeRenderModule mod_articles_category (Kulturális programajánló)
Idő: 6.95 ms / 258.51 ms Memória: 0.111 MB / 18.44 MB Application: afterRenderModule mod_articles_category (Kulturális programajánló)
Idő: 0.10 ms / 258.61 ms Memória: 0.000 MB / 18.40 MB Application: beforeRenderModule mod_acymailing (Hírlevél)
Idő: 7.67 ms / 266.28 ms Memória: 0.722 MB / 19.12 MB Application: afterRenderModule mod_acymailing (Hírlevél)
Idő: 0.08 ms / 266.35 ms Memória: 0.000 MB / 19.08 MB Application: beforeRenderModule mod_custom (Önkénteseket keresünk)
Idő: 0.24 ms / 266.60 ms Memória: 0.007 MB / 19.09 MB Application: afterRenderModule mod_custom (Önkénteseket keresünk)
Idő: 0.03 ms / 266.62 ms Memória: 0.000 MB / 19.08 MB Application: beforeRenderModule mod_custom (Impresszum)
Idő: 0.23 ms / 266.86 ms Memória: 0.007 MB / 19.09 MB Application: afterRenderModule mod_custom (Impresszum)
Idő: 0.15 ms / 267.00 ms Memória: 0.001 MB / 19.09 MB Application: beforeRenderModule mod_menu (Felső menü)
Idő: 8.50 ms / 275.50 ms Memória: 0.465 MB / 19.55 MB Application: afterRenderModule mod_menu (Felső menü)
Idő: 0.11 ms / 275.62 ms Memória: 0.000 MB / 19.55 MB Application: beforeRenderModule mod_itpsocialbuttons (Ajánló gombok felül)
Idő: 0.45 ms / 276.06 ms Memória: 0.016 MB / 19.56 MB Application: afterRenderModule mod_itpsocialbuttons (Ajánló gombok felül)
Idő: 0.03 ms / 276.10 ms Memória: 0.000 MB / 19.55 MB Application: beforeRenderModule mod_search (Keresés)
Idő: 2.09 ms / 278.19 ms Memória: 0.028 MB / 19.58 MB Application: afterRenderModule mod_search (Keresés)
Idő: 6.23 ms / 284.42 ms Memória: 0.227 MB / 19.80 MB Application: afterRender
Adatbázislekérdezés összesen: 64.60 ms
21,08 MB (22.104.488 Bájtok)
75 naplózott lekérdezés 64.60 ms
21 duplikátum található!
- Lekérdezés ideje: 0.61 ms Memória lekérdezése: 0.008 MB memória a lekérdezés előtt: 5.074 MB
DELETE
FROM `j3_session`
WHERE `time` < '1632167157'Az EXPLAIN nem lehetséges a következő lekérdezésen: DELETE FROM `j3_session` WHERE `time` < '1632167157'Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.09 ms updating 0.17 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.04 ms query end 0.09 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Application/CMSApplication.php:824 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:133 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:415 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:48 - Lekérdezés ideje: 0.38 ms Utolsó lekérdezés után: 0.38 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 5.108 MB Visszaadott sorok: 0
SELECT `data`
FROM `j3_session`
WHERE `session_id` = '5koatc7trq8id5ivq98aot14h4'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_session const PRIMARY PRIMARY 766 const 1 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Waiting for query cache lock 0.05 ms init 0.02 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.02 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 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:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:831 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:133 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:415 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:48 - Lekérdezés ideje: 0.47 ms Utolsó lekérdezés után: 1.32 ms Memória lekérdezése: 0.012 MB memória a lekérdezés előtt: 5.294 MB Visszaadott sorok: 0
SELECT `session_id`
FROM `j3_session`
WHERE `session_id` = '5koatc7trq8id5ivq98aot14h4'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_session const PRIMARY PRIMARY 766 const 1 Using index Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Waiting for query cache lock 0.04 ms init 0.02 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.03 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 7 JDatabaseDriver->loadResult() JROOT/libraries/src/Application/CMSApplication.php:178 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:833 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:133 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:415 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:48 - Lekérdezés ideje: 0.37 ms Utolsó lekérdezés után: 0.12 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 5.309 MB
INSERT INTO `j3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('5koatc7trq8id5ivq98aot14h4', 1, '1632168057', 0, '', 0)Az EXPLAIN nem lehetséges a következő lekérdezésen: INSERT INTO `j3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('5koatc7trq8id5ivq98aot14h4', 1, '1632168057', 0, '', 0)Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.03 ms update 0.10 ms Waiting for query cache lock 0.01 ms update 0.02 ms end 0.01 ms query end 0.05 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Application/CMSApplication.php:218 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:833 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:133 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:415 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:48 - Lekérdezés ideje: 1.31 ms Utolsó lekérdezés után: 2.72 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 5.710 MB Visszaadott sorok: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j3_extensions`
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_extensions ref extension extension 82 const 40 Using index condition Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 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 Waiting for query cache lock 0.03 ms init 0.03 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.01 ms Sending data 0.32 ms Waiting for query cache lock 0.01 ms Sending data 0.47 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.02 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.66 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:422 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 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:430 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:496 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:596 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.11 ms Utolsó lekérdezés után: 2.53 ms Memória lekérdezése: 0.015 MB memória a lekérdezés előtt: 6.094 MB Visszaadott sorok: 5
SELECT id, rules
FROM `j3_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_viewlevels ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 5 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 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:310 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:606 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.09 ms Utolsó lekérdezés után: 0.12 ms Memória lekérdezése: 0.015 MB memória a lekérdezés előtt: 6.119 MB Visszaadott sorok: 2
SELECT b.id
FROM j3_usergroups AS a
LEFT JOIN j3_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 3 Using where; Using index Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 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:310 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:606 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 1.63 ms Utolsó lekérdezés után: 0.63 ms Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 6.226 MB Visszaadott sorok: 99
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM j3_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 j3_extensions ref extension extension 82 const 117 Using index condition; Using where; Fájlrendezés használata Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Waiting for query cache lock 0.03 ms init 0.04 ms optimizing 0.06 ms statistics 0.08 ms preparing 0.06 ms executing 0.01 ms Sorting result 0.74 ms Sending data 0.31 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.03 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.43 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:343 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 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:348 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:606 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 2.21 ms Utolsó lekérdezés után: 10.74 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 7.760 MB Visszaadott sorok: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j3_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration starting 0.03 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.07 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 Waiting for query cache lock 0.04 ms init 0.04 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.04 ms executing 0.01 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 1.53 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 17 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 16 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 13 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 12 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 11 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 10 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 9 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 8 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/eprivacy/eprivacy.php:60 7 plgSystemePrivacy->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:272 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:685 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 1.89 ms Utolsó lekérdezés után: 0.19 ms Memória lekérdezése: 0.016 MB memória a lekérdezés előtt: 7.766 MB
UPDATE `j3_extensions`
SET `params` = '{\"mediaversion\":\"7d299ed32f52cf94f79e046f7ec455ff\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE `j3_extensions` SET `params` = '{\"mediaversion\":\"7d299ed32f52cf94f79e046f7ec455ff\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.10 ms updating 0.09 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 1.43 ms query end 0.09 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 12 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 11 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 10 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 9 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 8 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/eprivacy/eprivacy.php:60 7 plgSystemePrivacy->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:272 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:685 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.10 ms Utolsó lekérdezés után: 12.61 ms Memória lekérdezése: 0.016 MB memória a lekérdezés előtt: 8.927 MB Visszaadott sorok: 2
SELECT `component`
FROM `j3_tortags_components`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tortags_components ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2 Status Duration starting 0.02 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.00 ms cleaning up 0.00 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 11 JDatabaseDriver->loadColumn() JROOT/plugins/system/tortags/tortags.php:386 10 plgSystemtortags->getAlloweComponents() JROOT/plugins/system/tortags/tortags.php:159 9 plgSystemtortags->onAfterInitialise() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:686 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 2.76 ms Utolsó lekérdezés után: 3.76 ms Memória lekérdezése: 0.049 MB memória a lekérdezés előtt: 9.471 MB Visszaadott sorok: 104
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 j3_menu AS m
LEFT JOIN j3_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 ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 186 Using index condition; Using where; Fájlrendezés használata 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 diplohu_j25.m.component_id 1 Using where Status Duration starting 0.03 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.12 ms checking permissions 0.01 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 Waiting for query cache lock 0.05 ms init 0.06 ms optimizing 0.04 ms statistics 0.09 ms preparing 0.05 ms executing 0.01 ms Sorting result 1.02 ms Sending data 0.18 ms Waiting for query cache lock 0.01 ms Sending data 0.13 ms Waiting for query cache lock 0.01 ms Sending data 0.14 ms Waiting for query cache lock 0.01 ms Sending data 0.13 ms Waiting for query cache lock 0.01 ms Sending data 0.14 ms Waiting for query cache lock 0.01 ms Sending data 0.14 ms Waiting for query cache lock 0.01 ms Sending data 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms freeing items 0.02 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.02 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 22 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 21 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 20 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 19 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 18 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 17 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 16 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:446 15 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 14 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 13 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 12 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:551 11 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:405 10 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/jumirouter/jumirouter.php:36 9 plgSystemJumiRouter->onAfterInitialise() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:686 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.23 ms Utolsó lekérdezés után: 11.06 ms Memória lekérdezése: 0.017 MB memória a lekérdezés előtt: 10.857 MB Visszaadott sorok: 6
select id, title, alias
from j3_jumi
where published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_jumi ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 6 Using where Status Duration starting 0.04 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.02 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.03 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1801 12 JDatabaseDriver->loadRowList() JROOT/plugins/system/jumirouter/jumirouter.php:57 11 parseJumiRouter() Same as call in the line below. 10 call_user_func_array() JROOT/libraries/src/Router/Router.php:596 9 Joomla\CMS\Router\Router->processParseRules() JROOT/libraries/src/Router/SiteRouter.php:593 8 Joomla\CMS\Router\SiteRouter->processParseRules() JROOT/libraries/src/Router/Router.php:570 7 Joomla\CMS\Router\Router->_processParseRules() JROOT/libraries/src/Router/Router.php:216 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1147 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.56 ms Utolsó lekérdezés után: 1.52 ms Memória lekérdezése: 0.017 MB memória a lekérdezés előtt: 11.059 MB Visszaadott sorok: 1
SELECT id
FROM `j3_tags`
WHERE `alias` = 'haboru'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tags ref idx_alias idx_alias 402 const 1 Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.06 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Waiting for query cache lock 0.03 ms init 0.03 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.03 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.64 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 11 JDatabaseDriver->loadResult() JROOT/components/com_tags/router.php:179 10 TagsRouter->fixSegment() JROOT/components/com_tags/router.php:147 9 TagsRouter->parse() JROOT/libraries/src/Router/SiteRouter.php:437 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:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1147 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.32 ms Utolsó lekérdezés után: 0.41 ms Memória lekérdezése: 0.014 MB memória a lekérdezés előtt: 11.093 MB Visszaadott sorok: 1
SELECT *
FROM j3_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_languages ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 1 Using where; Fájlrendezés használata Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.67 ms Utolsó lekérdezés után: 0.27 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 11.113 MB Visszaadott sorok: 4
SELECT id, home, template, s.params
FROM j3_template_styles as s
LEFT JOIN j3_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 NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 6 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 diplohu_j25.s.template,const 1 Using index condition; Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.07 ms checking permissions 0.01 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 Waiting for query cache lock 0.04 ms init 0.04 ms optimizing 0.04 ms statistics 0.09 ms preparing 0.04 ms executing 0.01 ms Sending data 0.14 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.02 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.24 ms cleaning up 0.01 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:488 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.21 ms Utolsó lekérdezés után: 9.36 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 12.419 MB Visszaadott sorok: 13
SELECT *
FROM `j3_content_types`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_content_types ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 13 Status Duration starting 0.03 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.02 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.04 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 18 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Helper/TagsHelper.php:794 17 Joomla\CMS\Helper\TagsHelper::getTypes() JROOT/libraries/src/Helper/TagsHelper.php:628 16 Joomla\CMS\Helper\TagsHelper->getTagItemsQuery() JROOT/components/com_tags/models/tag.php:148 15 TagsModelTag->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 14 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_tags/models/tag.php:86 12 TagsModelTag->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tags/views/tag/view.html.php:51 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 6.39 ms Utolsó lekérdezés után: 0.27 ms Memória lekérdezése: 0.035 MB memória a lekérdezés előtt: 12.467 MB Visszaadott sorok: 37
SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM j3_contentitem_tag_map AS m
INNER JOIN j3_ucm_content AS c
ON m.type_alias = c.core_type_alias
AND m.core_content_id = c.core_content_id
AND c.core_state IN (1)
AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2021-09-20 20:00:57')
AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2021-09-20 20:00:57')
INNER JOIN j3_content_types AS ct
ON ct.type_alias = m.type_alias
LEFT JOIN j3_categories AS tc
ON tc.id = c.core_catid
LEFT JOIN j3_users AS ua
ON ua.id = c.core_created_user_id
WHERE m.tag_id IN (79)
AND (c.core_catid = 0 OR tc.published = 1)
AND m.type_alias IN ('com_content.article','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category')
AND c.core_access IN (0,1,5)
GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email
ORDER BY MAX(`c`.`core_title`) ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_tag_type,idx_core_content_id idx_tag_type 4 const 37 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c eq_ref PRIMARY,tag_idx,idx_access,idx_content_type PRIMARY 4 diplohu_j25.m.core_content_id 1 Using where 1 SIMPLE tc eq_ref PRIMARY PRIMARY 4 diplohu_j25.c.core_catid 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 diplohu_j25.c.core_created_user_id 1 Using where 1 SIMPLE ct ALL idx_alias NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 13 Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.30 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.20 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms Waiting for query cache lock 0.14 ms init 0.21 ms Waiting for query cache lock 0.01 ms init 0.01 ms storing result in query cache 0.44 ms optimizing 0.09 ms statistics 0.25 ms preparing 0.13 ms executing 0.01 ms Creating tmp table 0.57 ms Copying to tmp table 2.99 ms Sorting result 0.24 ms Sending data 0.33 ms end 0.01 ms removing tmp table 0.22 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.03 ms freeing items 0.03 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:348 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:282 15 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:316 14 Joomla\CMS\MVC\Model\ListModel->getStart() JROOT/libraries/src/MVC/Model/ListModel.php:187 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_tags/models/tag.php:86 12 TagsModelTag->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tags/views/tag/view.html.php:51 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 5.28 ms Utolsó lekérdezés után: 0.15 ms Memória lekérdezése: 0.030 MB memória a lekérdezés előtt: 12.474 MB Visszaadott sorok: 17
SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM j3_contentitem_tag_map AS m
INNER JOIN j3_ucm_content AS c
ON m.type_alias = c.core_type_alias
AND m.core_content_id = c.core_content_id
AND c.core_state IN (1)
AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2021-09-20 20:00:57')
AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2021-09-20 20:00:57')
INNER JOIN j3_content_types AS ct
ON ct.type_alias = m.type_alias
LEFT JOIN j3_categories AS tc
ON tc.id = c.core_catid
LEFT JOIN j3_users AS ua
ON ua.id = c.core_created_user_id
WHERE m.tag_id IN (79)
AND (c.core_catid = 0 OR tc.published = 1)
AND m.type_alias IN ('com_content.article','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category')
AND c.core_access IN (0,1,5)
GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email
ORDER BY MAX(`c`.`core_title`) ASC
LIMIT 20, 20id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_tag_type,idx_core_content_id idx_tag_type 4 const 37 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE c eq_ref PRIMARY,tag_idx,idx_access,idx_content_type PRIMARY 4 diplohu_j25.m.core_content_id 1 Using where 1 SIMPLE tc eq_ref PRIMARY PRIMARY 4 diplohu_j25.c.core_catid 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 diplohu_j25.c.core_created_user_id 1 Using where 1 SIMPLE ct ALL idx_alias NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 13 Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.28 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Waiting for query cache lock 0.16 ms init 0.17 ms Waiting for query cache lock 0.01 ms init 0.01 ms storing result in query cache 0.44 ms optimizing 0.08 ms statistics 0.18 ms preparing 0.11 ms executing 0.01 ms Creating tmp table 0.48 ms Copying to tmp table 2.47 ms Sorting result 0.23 ms Sending data 0.24 ms end 0.01 ms removing tmp table 0.12 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms freeing items 0.03 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_tags/models/tag.php:86 12 TagsModelTag->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tags/views/tag/view.html.php:51 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.91 ms Utolsó lekérdezés után: 2.57 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 13.058 MB Visszaadott sorok: 30
SHOW FULL COLUMNS
FROM `j3_tags`Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `j3_tags`Status Duration starting 0.06 ms checking permissions 0.01 ms closing tables 0.01 ms Opening tables 0.25 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms closing tables 0.01 ms executing 0.00 ms Sending data 0.06 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.06 ms closing tables 0.00 ms Unlocking tables 0.00 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:430 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 15 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_tags/tables/tag.php:29 14 TagsTableTag->__construct() JROOT/libraries/src/Table/Table.php:312 13 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_tags/models/tag.php:271 12 TagsModelTag->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tags/views/tag/view.html.php:52 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.36 ms Utolsó lekérdezés után: 2.63 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 13.257 MB Visszaadott sorok: 1Duplikált lekérdezések: #40
SELECT *
FROM j3_tags
WHERE `id` = '79'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tags const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Waiting for query cache lock 0.02 ms init 0.02 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms Unlocking tables 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.02 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms storing result in query cache 0.22 ms cleaning up 0.00 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 14 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:730 13 Joomla\CMS\Table\Table->load() JROOT/components/com_tags/models/tag.php:280 12 TagsModelTag->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tags/views/tag/view.html.php:52 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.22 ms Utolsó lekérdezés után: 7.99 ms Memória lekérdezése: 0.032 MB memória a lekérdezés előtt: 14.322 MB Visszaadott sorok: 0
SELECT 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
FROM j3_fields AS a
LEFT JOIN `j3_languages` AS l
ON l.lang_code = a.language
LEFT JOIN j3_users AS uc
ON uc.id=a.checked_out
LEFT JOIN j3_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN j3_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN j3_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_tags.tag'
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; Fájlrendezés használata 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 diplohu_j25.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 diplohu_j25.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 diplohu_j25.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 diplohu_j25.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 diplohu_j25.a.group_id 1 Using where Status Duration starting 0.03 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.02 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:327 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 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:400 14 PlgSystemFields->onContentPrepare() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:99 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.14 ms Utolsó lekérdezés után: 2.33 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 14.468 MB Visszaadott sorok: 2
SELECT `component`
FROM `j3_tortags_components`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tortags_components ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2 Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 16 JDatabaseDriver->loadColumn() JROOT/plugins/content/tortags/tortags.php:229 15 plgContentTorTags->getAlloweComponents() JROOT/plugins/content/tortags/tortags.php:181 14 plgContentTorTags->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:104 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.08 ms Utolsó lekérdezés után: 0.78 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 14.493 MB Visszaadott sorok: 2
SELECT `component`
FROM `j3_tortags_components`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tortags_components ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2 Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.01 ms checking privileges on cached 0.02 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.00 ms cleaning up 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 16 JDatabaseDriver->loadColumn() JROOT/plugins/content/tortags/tortags.php:229 15 plgContentTorTags->getAlloweComponents() JROOT/plugins/content/tortags/tortags.php:181 14 plgContentTorTags->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:104 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.06 ms Utolsó lekérdezés után: 0.71 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 14.515 MB Visszaadott sorok: 2
SELECT `component`
FROM `j3_tortags_components`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tortags_components ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2 Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.00 ms sending cached result to clien 0.01 ms updating status 0.00 ms cleaning up 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 16 JDatabaseDriver->loadColumn() JROOT/plugins/content/tortags/tortags.php:229 15 plgContentTorTags->getAlloweComponents() JROOT/plugins/content/tortags/tortags.php:181 14 plgContentTorTags->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:104 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.06 ms Utolsó lekérdezés után: 0.68 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 14.538 MB Visszaadott sorok: 2
SELECT `component`
FROM `j3_tortags_components`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tortags_components ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2 Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.00 ms cleaning up 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 16 JDatabaseDriver->loadColumn() JROOT/plugins/content/tortags/tortags.php:229 15 plgContentTorTags->getAlloweComponents() JROOT/plugins/content/tortags/tortags.php:181 14 plgContentTorTags->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:104 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.06 ms Utolsó lekérdezés után: 0.82 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 14.560 MB Visszaadott sorok: 2
SELECT `component`
FROM `j3_tortags_components`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tortags_components ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.00 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.00 ms sending cached result to clien 0.01 ms updating status 0.00 ms cleaning up 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 16 JDatabaseDriver->loadColumn() JROOT/plugins/content/tortags/tortags.php:229 15 plgContentTorTags->getAlloweComponents() JROOT/plugins/content/tortags/tortags.php:181 14 plgContentTorTags->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:104 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.07 ms Utolsó lekérdezés után: 0.76 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 14.582 MB Visszaadott sorok: 2
SELECT `component`
FROM `j3_tortags_components`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tortags_components ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2 Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.00 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 16 JDatabaseDriver->loadColumn() JROOT/plugins/content/tortags/tortags.php:229 15 plgContentTorTags->getAlloweComponents() JROOT/plugins/content/tortags/tortags.php:181 14 plgContentTorTags->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:104 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.06 ms Utolsó lekérdezés után: 0.74 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 14.605 MB Visszaadott sorok: 2
SELECT `component`
FROM `j3_tortags_components`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tortags_components ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2 Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.00 ms sending cached result to clien 0.01 ms updating status 0.00 ms cleaning up 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 16 JDatabaseDriver->loadColumn() JROOT/plugins/content/tortags/tortags.php:229 15 plgContentTorTags->getAlloweComponents() JROOT/plugins/content/tortags/tortags.php:181 14 plgContentTorTags->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:104 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.06 ms Utolsó lekérdezés után: 0.70 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 14.627 MB Visszaadott sorok: 2
SELECT `component`
FROM `j3_tortags_components`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tortags_components ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.00 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.00 ms sending cached result to clien 0.01 ms updating status 0.00 ms cleaning up 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 16 JDatabaseDriver->loadColumn() JROOT/plugins/content/tortags/tortags.php:229 15 plgContentTorTags->getAlloweComponents() JROOT/plugins/content/tortags/tortags.php:181 14 plgContentTorTags->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:104 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.10 ms Utolsó lekérdezés után: 0.72 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 14.650 MB Visszaadott sorok: 2
SELECT `component`
FROM `j3_tortags_components`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tortags_components ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.03 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 16 JDatabaseDriver->loadColumn() JROOT/plugins/content/tortags/tortags.php:229 15 plgContentTorTags->getAlloweComponents() JROOT/plugins/content/tortags/tortags.php:181 14 plgContentTorTags->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:104 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.06 ms Utolsó lekérdezés után: 0.71 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 14.672 MB Visszaadott sorok: 2
SELECT `component`
FROM `j3_tortags_components`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tortags_components ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2 Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.00 ms sending cached result to clien 0.01 ms updating status 0.00 ms cleaning up 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 16 JDatabaseDriver->loadColumn() JROOT/plugins/content/tortags/tortags.php:229 15 plgContentTorTags->getAlloweComponents() JROOT/plugins/content/tortags/tortags.php:181 14 plgContentTorTags->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:104 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.08 ms Utolsó lekérdezés után: 0.72 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 14.695 MB Visszaadott sorok: 2
SELECT `component`
FROM `j3_tortags_components`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tortags_components ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 16 JDatabaseDriver->loadColumn() JROOT/plugins/content/tortags/tortags.php:229 15 plgContentTorTags->getAlloweComponents() JROOT/plugins/content/tortags/tortags.php:181 14 plgContentTorTags->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:104 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.07 ms Utolsó lekérdezés után: 0.72 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 14.718 MB Visszaadott sorok: 2
SELECT `component`
FROM `j3_tortags_components`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tortags_components ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 16 JDatabaseDriver->loadColumn() JROOT/plugins/content/tortags/tortags.php:229 15 plgContentTorTags->getAlloweComponents() JROOT/plugins/content/tortags/tortags.php:181 14 plgContentTorTags->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:104 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.08 ms Utolsó lekérdezés után: 0.71 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 14.740 MB Visszaadott sorok: 2
SELECT `component`
FROM `j3_tortags_components`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tortags_components ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 16 JDatabaseDriver->loadColumn() JROOT/plugins/content/tortags/tortags.php:229 15 plgContentTorTags->getAlloweComponents() JROOT/plugins/content/tortags/tortags.php:181 14 plgContentTorTags->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:104 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.07 ms Utolsó lekérdezés után: 0.71 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 14.762 MB Visszaadott sorok: 2
SELECT `component`
FROM `j3_tortags_components`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tortags_components ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 16 JDatabaseDriver->loadColumn() JROOT/plugins/content/tortags/tortags.php:229 15 plgContentTorTags->getAlloweComponents() JROOT/plugins/content/tortags/tortags.php:181 14 plgContentTorTags->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:104 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.08 ms Utolsó lekérdezés után: 0.72 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 14.785 MB Visszaadott sorok: 2
SELECT `component`
FROM `j3_tortags_components`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tortags_components ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 16 JDatabaseDriver->loadColumn() JROOT/plugins/content/tortags/tortags.php:229 15 plgContentTorTags->getAlloweComponents() JROOT/plugins/content/tortags/tortags.php:181 14 plgContentTorTags->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:104 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.09 ms Utolsó lekérdezés után: 0.75 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 14.807 MB Visszaadott sorok: 2
SELECT `component`
FROM `j3_tortags_components`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tortags_components ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 16 JDatabaseDriver->loadColumn() JROOT/plugins/content/tortags/tortags.php:229 15 plgContentTorTags->getAlloweComponents() JROOT/plugins/content/tortags/tortags.php:181 14 plgContentTorTags->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:104 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.07 ms Utolsó lekérdezés után: 0.72 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 14.830 MB Visszaadott sorok: 2
SELECT `component`
FROM `j3_tortags_components`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tortags_components ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 16 JDatabaseDriver->loadColumn() JROOT/plugins/content/tortags/tortags.php:229 15 plgContentTorTags->getAlloweComponents() JROOT/plugins/content/tortags/tortags.php:181 14 plgContentTorTags->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:104 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.09 ms Utolsó lekérdezés után: 0.79 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 14.861 MB Visszaadott sorok: 1Duplikált lekérdezések: #21
SELECT *
FROM j3_tags
WHERE `id` = '79'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tags const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 13 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:730 12 Joomla\CMS\Table\Table->load() JROOT/components/com_tags/models/tag.php:335 11 TagsModelTag->hit() JROOT/components/com_tags/views/tag/view.html.php:197 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 2.13 ms Utolsó lekérdezés után: 0.16 ms Memória lekérdezése: 0.016 MB memória a lekérdezés előtt: 14.877 MB
UPDATE j3_tags
SET `hits` = (`hits` + 1)
WHERE `id` = '79'Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE j3_tags SET `hits` = (`hits` + 1) WHERE `id` = '79'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.07 ms updating 0.10 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 1.67 ms query end 0.09 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1241 12 Joomla\CMS\Table\Table->hit() JROOT/components/com_tags/models/tag.php:336 11 TagsModelTag->hit() JROOT/components/com_tags/views/tag/view.html.php:197 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.25 ms Utolsó lekérdezés után: 13.44 ms Memória lekérdezése: 0.031 MB memória a lekérdezés előtt: 15.915 MB Visszaadott sorok: 39
SELECT `id`,`name`,`rules`,`parent_id`
FROM `j3_assets`
WHERE `name` IN ('root.1','com_acymailing','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_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_jumi','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_securitycheck','com_tags','com_templates','com_tortags','com_users','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_assets range idx_asset_name idx_asset_name 202 NULL 40 Using index condition Status Duration starting 0.04 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.02 ms checking privileges on cached 0.01 ms checking permissions 0.02 ms sending cached result to clien 0.03 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 20 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 19 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 18 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 17 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 16 Joomla\CMS\User\User->authorise() JROOT/components/com_tags/views/tag/tmpl/default_items.php:22 15 include JROOT/components/com_tags/views/tag/tmpl/default_items.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_tags/views/tag/tmpl/default.php:50 13 include JROOT/components/com_tags/views/tag/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:695 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_tags/views/tag/view.html.php:201 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 2.34 ms Utolsó lekérdezés után: 3.24 ms Memória lekérdezése: 0.042 MB memória a lekérdezés előtt: 16.240 MB Visszaadott sorok: 4
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 j3_categories as c
LEFT JOIN j3_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.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=249
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 Fájlrendezés használata 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 234 Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.20 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.03 ms System lock 0.01 ms Table lock 0.01 ms Waiting for query cache lock 0.56 ms init 0.10 ms optimizing 0.06 ms statistics 0.24 ms preparing 0.01 ms Unlocking tables 0.05 ms executing 0.01 ms Sorting result 0.59 ms Sending data 0.13 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.03 ms freeing items 0.02 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.03 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 28 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 27 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:305 26 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 25 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 24 ContentRouter->getCategorySegment() Same as call in the line below. 23 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 22 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 21 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 20 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:669 19 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 18 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 17 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 16 Joomla\CMS\Router\Route::_() JROOT/components/com_tags/views/tag/tmpl/default_items.php:82 15 include JROOT/components/com_tags/views/tag/tmpl/default_items.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_tags/views/tag/tmpl/default.php:50 13 include JROOT/components/com_tags/views/tag/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:695 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_tags/views/tag/view.html.php:201 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 1.50 ms Utolsó lekérdezés után: 1.07 ms Memória lekérdezése: 0.042 MB memória a lekérdezés előtt: 16.374 MB Visszaadott sorok: 4
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 j3_categories as c
LEFT JOIN j3_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.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=250
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 Fájlrendezés használata 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 234 Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.15 ms checking permissions 0.01 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 Waiting for query cache lock 0.08 ms init 0.08 ms optimizing 0.05 ms statistics 0.18 ms preparing 0.01 ms Unlocking tables 0.04 ms executing 0.01 ms Sorting result 0.56 ms Sending data 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.02 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.02 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.05 ms cleaning up 0.01 ms # Caller File and line number 28 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 27 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:305 26 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 25 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 24 ContentRouter->getCategorySegment() Same as call in the line below. 23 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 22 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 21 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 20 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:669 19 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 18 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 17 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 16 Joomla\CMS\Router\Route::_() JROOT/components/com_tags/views/tag/tmpl/default_items.php:82 15 include JROOT/components/com_tags/views/tag/tmpl/default_items.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_tags/views/tag/tmpl/default.php:50 13 include JROOT/components/com_tags/views/tag/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:695 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_tags/views/tag/view.html.php:201 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 1.88 ms Utolsó lekérdezés után: 0.51 ms Memória lekérdezése: 0.042 MB memória a lekérdezés előtt: 16.419 MB Visszaadott sorok: 4
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 j3_categories as c
LEFT JOIN j3_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.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=279
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 Fájlrendezés használata 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 234 Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.16 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Waiting for query cache lock