Államadósság vizualizáció
- Részletek
- Kategória: VIDEO - gazdaság
- Írta: Utopszkij
- Találatok: 4759
Államadósság-vizualizációk, az első az amerikai a második a magyar államadósságról.
http://allamadossag.net78.net/?honnan=Nemzeti_Hirhalo
adósság| Tweet |
2021. február
VIDEO - gazdaság - 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
Támogasson bennünket adója 1%-val!
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": 1614407732,
"last": 1614407732,
"now": 1614407732
},
"token": "Yc8yKo8K8t0Ni4IHQYGVsz8QoPIFiYig"
},
"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
},
"com_mailto": {
"links": {
"e15ce57cf2ff8df0e85c2025dacdf7a29fefc5e5": {
"link": "http:\/\/www.magyardiplo.hu\/video-konyvtar-gazdasag\/674-allamadossag-vizualizacio.html",
"expiry": 1614407734
}
}
}
}
}
Idő
Memória
Idő: 7.98 ms / 7.98 ms Memória: 0.758 MB / 0.98 MB Application: afterLoad
Idő: 1990.03 ms / 1998.01 ms Memória: 2.440 MB / 3.42 MB Application: afterInitialise
Idő: 10.57 ms / 2008.58 ms Memória: 0.293 MB / 3.71 MB Application: afterRoute
Idő: 8.25 ms / 2016.83 ms Memória: 0.068 MB / 3.78 MB Application: beforeRenderComponent com_content
Idő: 4.59 ms / 2021.42 ms Memória: 0.247 MB / 4.03 MB Application: Before Access::preloadComponents (all components)
Idő: 0.78 ms / 2022.19 ms Memória: 0.095 MB / 4.12 MB Application: After Access::preloadComponents (all components)
Idő: 0.07 ms / 2022.26 ms Memória: 0.000 MB / 4.12 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Idő: 0.47 ms / 2022.73 ms Memória: 0.019 MB / 4.14 MB Application: After Access::getAssetRules (id:8 name:com_content)
Idő: 67.65 ms / 2090.38 ms Memória: 2.918 MB / 7.05 MB Application: Before Access::preloadPermissions (com_content)
Idő: 9.24 ms / 2099.62 ms Memória: 2.048 MB / 9.10 MB Application: After Access::preloadPermissions (com_content)
Idő: 30.27 ms / 2129.89 ms Memória: 0.411 MB / 9.51 MB Application: afterRenderComponent com_content
Idő: 3.63 ms / 2133.53 ms Memória: 0.024 MB / 9.54 MB Application: afterDispatch
Idő: 11.85 ms / 2145.38 ms Memória: 0.236 MB / 9.77 MB Application: beforeRenderModule mod_tortags_often_clouds (cimkefelhő)
Idő: 19.95 ms / 2165.33 ms Memória: 0.681 MB / 10.45 MB Application: afterRenderModule mod_tortags_often_clouds (cimkefelhő)
Idő: 0.16 ms / 2165.48 ms Memória: 0.000 MB / 10.32 MB Application: beforeRenderModule mod_custom (Cimkék fejléc)
Idő: 0.97 ms / 2166.45 ms Memória: 0.011 MB / 10.33 MB Application: afterRenderModule mod_custom (Cimkék fejléc)
Idő: 0.07 ms / 2166.52 ms Memória: 0.000 MB / 10.32 MB Application: beforeRenderModule mod_custom (alsó menü)
Idő: 0.30 ms / 2166.83 ms Memória: 0.007 MB / 10.33 MB Application: afterRenderModule mod_custom (alsó menü)
Idő: 0.05 ms / 2166.87 ms Memória: 0.001 MB / 10.33 MB Application: beforeRenderModule mod_itpsocialbuttons (ajánló gombok alul)
Idő: 1.25 ms / 2168.12 ms Memória: 0.034 MB / 10.37 MB Application: afterRenderModule mod_itpsocialbuttons (ajánló gombok alul)
Idő: 0.07 ms / 2168.19 ms Memória: 0.000 MB / 10.35 MB Application: beforeRenderModule mod_custom (Admin link)
Idő: 0.30 ms / 2168.49 ms Memória: 0.007 MB / 10.36 MB Application: afterRenderModule mod_custom (Admin link)
Idő: 0.04 ms / 2168.52 ms Memória: 0.000 MB / 10.36 MB Application: beforeRenderModule mod_syndicate (RSS)
Idő: 0.77 ms / 2169.29 ms Memória: 0.014 MB / 10.37 MB Application: afterRenderModule mod_syndicate (RSS)
Idő: 0.12 ms / 2169.41 ms Memória: 0.000 MB / 10.37 MB Application: beforeRenderModule mod_custom (Ziegler)
Idő: 0.31 ms / 2169.72 ms Memória: 0.007 MB / 10.37 MB Application: afterRenderModule mod_custom (Ziegler)
Idő: 0.04 ms / 2169.76 ms Memória: 0.000 MB / 10.37 MB Application: beforeRenderModule mod_banners (KÖNYVAJÁNLÓ)
Idő: 149.29 ms / 2319.05 ms Memória: 0.259 MB / 10.63 MB Application: afterRenderModule mod_banners (KÖNYVAJÁNLÓ)
Idő: 0.13 ms / 2319.18 ms Memória: 0.000 MB / 10.62 MB Application: beforeRenderModule mod_syndicate (RSS hírcsatorna)
Idő: 0.51 ms / 2319.69 ms Memória: 0.007 MB / 10.62 MB Application: afterRenderModule mod_syndicate (RSS hírcsatorna)
Idő: 0.22 ms / 2319.90 ms Memória: 0.000 MB / 10.62 MB Application: beforeRenderModule mod_jumi (Tartalom)
Idő: 5.52 ms / 2325.42 ms Memória: 0.085 MB / 10.71 MB Application: afterRenderModule mod_jumi (Tartalom)
Idő: 0.12 ms / 2325.54 ms Memória: 0.000 MB / 10.70 MB Application: beforeRenderModule mod_articles_category (Közéleti programajánló)
Idő: 18.21 ms / 2343.75 ms Memória: 0.482 MB / 11.18 MB Application: afterRenderModule mod_articles_category (Közéleti programajánló)
Idő: 0.24 ms / 2343.99 ms Memória: 0.000 MB / 11.10 MB Application: beforeRenderModule mod_articles_category (Kulturális programajánló)
Idő: 17.57 ms / 2361.57 ms Memória: 0.189 MB / 11.29 MB Application: afterRenderModule mod_articles_category (Kulturális programajánló)
Idő: 0.22 ms / 2361.78 ms Memória: 0.000 MB / 11.17 MB Application: beforeRenderModule mod_acymailing (Hírlevél)
Idő: 22.37 ms / 2384.15 ms Memória: 1.743 MB / 12.92 MB Application: afterRenderModule mod_acymailing (Hírlevél)
Idő: 0.12 ms / 2384.27 ms Memória: 0.000 MB / 12.87 MB Application: beforeRenderModule mod_custom (Önkénteseket keresünk)
Idő: 0.37 ms / 2384.64 ms Memória: 0.007 MB / 12.88 MB Application: afterRenderModule mod_custom (Önkénteseket keresünk)
Idő: 0.04 ms / 2384.69 ms Memória: 0.000 MB / 12.88 MB Application: beforeRenderModule mod_custom (Impresszum)
Idő: 0.32 ms / 2385.01 ms Memória: 0.007 MB / 12.88 MB Application: afterRenderModule mod_custom (Impresszum)
Idő: 0.04 ms / 2385.05 ms Memória: 0.000 MB / 12.88 MB Application: beforeRenderModule mod_custom (Támogasson bennünket adója 1%-val!)
Idő: 0.32 ms / 2385.37 ms Memória: 0.007 MB / 12.89 MB Application: afterRenderModule mod_custom (Támogasson bennünket adója 1%-val!)
Idő: 0.21 ms / 2385.58 ms Memória: 0.000 MB / 12.89 MB Application: beforeRenderModule mod_menu (Felső menü)
Idő: 13.75 ms / 2399.33 ms Memória: 0.476 MB / 13.36 MB Application: afterRenderModule mod_menu (Felső menü)
Idő: 0.18 ms / 2399.51 ms Memória: 0.000 MB / 13.36 MB Application: beforeRenderModule mod_itpsocialbuttons (Ajánló gombok felül)
Idő: 0.68 ms / 2400.19 ms Memória: 0.017 MB / 13.37 MB Application: afterRenderModule mod_itpsocialbuttons (Ajánló gombok felül)
Idő: 0.05 ms / 2400.24 ms Memória: 0.000 MB / 13.36 MB Application: beforeRenderModule mod_search (Keresés)
Idő: 3.29 ms / 2403.53 ms Memória: 0.028 MB / 13.39 MB Application: afterRenderModule mod_search (Keresés)
Idő: 10.90 ms / 2414.43 ms Memória: 0.338 MB / 13.73 MB Application: afterRender
Adatbázislekérdezés összesen: 2155.98 ms
14,76 MB (15.475.704 Bájtok)
56 naplózott lekérdezés 2155.98 ms
11 duplikátum található!
- Lekérdezés ideje: 0.26 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.535 MB Visszaadott sorok: 0
SELECT `data`
FROM `j3_session`
WHERE `session_id` = 'hcv1h7lsebdqe8epgudiv1tjk4'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.00 ms init 0.00 ms checking query cache for query 0.03 ms checking permissions 0.00 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.03 ms init 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 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.14 ms Utolsó lekérdezés után: 0.54 ms Memória lekérdezése: 0.012 MB memória a lekérdezés előtt: 1.590 MB Visszaadott sorok: 0
SELECT `session_id`
FROM `j3_session`
WHERE `session_id` = 'hcv1h7lsebdqe8epgudiv1tjk4'
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.00 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Waiting for query cache lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.00 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 4.34 ms cleaning up 0.02 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: 1908.18 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 1.605 MB
INSERT INTO `j3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('hcv1h7lsebdqe8epgudiv1tjk4', 1, '1614407732', 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 ('hcv1h7lsebdqe8epgudiv1tjk4', 1, '1614407732', 0, '', 0)Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms init 0.01 ms update 0.05 ms Waiting for query cache lock 0.00 ms update 0.03 ms end 0.00 ms query end 1903.64 ms closing tables 0.02 ms Unlocking tables 0.02 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.00 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: 24.04 ms Utolsó lekérdezés után: 1.16 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 1.682 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 18.49 ms init 0.03 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.02 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 ms Sending data 0.19 ms Waiting for query cache lock 4.62 ms Sending data 0.08 ms end 0.01 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.19 ms updating status 0.02 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.21 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.19 ms Utolsó lekérdezés után: 2.80 ms Memória lekérdezése: 0.015 MB memória a lekérdezés előtt: 1.792 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.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.01 ms cleaning up 0.00 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.35 ms Memória lekérdezése: 0.015 MB memória a lekérdezés előtt: 1.817 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.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 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 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.09 ms Utolsó lekérdezés után: 0.46 ms Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 1.855 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.00 ms init 0.00 ms checking query cache for query 0.05 ms checking permissions 0.00 ms Opening tables 0.01 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.02 ms statistics 0.05 ms preparing 0.03 ms executing 0.00 ms Sorting result 0.46 ms Sending data 0.18 ms end 0.01 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.00 ms storing result in query cache 0.01 ms cleaning up 0.00 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: 4.76 ms Utolsó lekérdezés után: 11.45 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 2.391 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.11 ms init 0.01 ms checking query cache for query 0.06 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.09 ms init 0.03 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.03 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.01 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 3.89 ms updating status 0.04 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 2.33 ms cleaning up 0.03 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: 5.55 ms Utolsó lekérdezés után: 0.52 ms Memória lekérdezése: 0.016 MB memória a lekérdezés előtt: 2.397 MB
UPDATE `j3_extensions`
SET `params` = '{\"mediaversion\":\"230cbeefd6fcbae0a93db6264edfa525\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE `j3_extensions` SET `params` = '{\"mediaversion\":\"230cbeefd6fcbae0a93db6264edfa525\"}' 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.13 ms updating 0.10 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 3.27 ms query end 0.07 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.01 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.14 ms Utolsó lekérdezés után: 15.18 ms Memória lekérdezése: 0.016 MB memória a lekérdezés előtt: 2.657 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.03 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 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.33 ms Utolsó lekérdezés után: 2.23 ms Memória lekérdezése: 0.049 MB memória a lekérdezés előtt: 2.765 MB Visszaadott sorok: 105
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 184 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.01 ms Waiting for query cache lock 0.04 ms init 0.00 ms checking query cache for query 0.06 ms checking permissions 0.00 ms checking permissions 0.00 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.03 ms init 0.03 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.03 ms executing 0.00 ms Sorting result 0.56 ms Sending data 0.09 ms Waiting for query cache lock 0.83 ms Sending data 0.07 ms Waiting for query cache lock 0.00 ms Sending data 0.08 ms Waiting for query cache lock 0.00 ms Sending data 0.06 ms Waiting for query cache lock 0.00 ms Sending data 0.07 ms Waiting for query cache lock 0.00 ms Sending data 0.07 ms Waiting for query cache lock 0.01 ms Sending data 0.05 ms end 0.00 ms query end 0.00 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.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 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.21 ms Utolsó lekérdezés után: 9.79 ms Memória lekérdezése: 0.017 MB memória a lekérdezés előtt: 3.605 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.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.02 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.62 ms Utolsó lekérdezés után: 2.03 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 3.684 MB Visszaadott sorok: 0
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=674
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.13 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.06 ms optimizing 0.04 ms statistics 0.06 ms preparing 0.01 ms executing 0.03 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.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.27 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:305 12 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 11 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/helpers/legacyrouter.php:350 10 ContentRouterRulesLegacy->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php: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.39 ms Utolsó lekérdezés után: 0.14 ms Memória lekérdezése: 0.017 MB memória a lekérdezés előtt: 3.700 MB Visszaadott sorok: 1
SELECT `alias`,`catid`
FROM `j3_content`
WHERE `id` = 674id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_content const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms init 0.00 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.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms Unlocking tables 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.01 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.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 3.06 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 11 JDatabaseDriver->loadObject() JROOT/components/com_content/helpers/legacyrouter.php:366 10 ContentRouterRulesLegacy->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php: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: 2.71 ms Utolsó lekérdezés után: 0.55 ms Memória lekérdezése: 0.014 MB memória a lekérdezés előtt: 3.736 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.00 ms init 0.01 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.02 ms updating status 0.00 ms cleaning up 0.00 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: 3.16 ms Utolsó lekérdezés után: 0.70 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 3.766 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.00 ms init 0.01 ms checking query cache for query 0.05 ms checking permissions 0.00 ms checking permissions 0.00 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 2.58 ms init 0.04 ms optimizing 0.03 ms statistics 0.08 ms preparing 0.03 ms executing 0.01 ms Sending data 0.11 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.00 ms updating status 0.02 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.11 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.19 ms Utolsó lekérdezés után: 6.20 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 4.036 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.02 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.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 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:55 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:248 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.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.08 ms Utolsó lekérdezés után: 2.02 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 4.213 MB Visszaadott sorok: 30
SHOW FULL COLUMNS
FROM `j3_content`Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `j3_content`Status Duration starting 0.04 ms checking permissions 0.01 ms closing tables 0.01 ms Opening tables 0.31 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.02 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.04 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 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 closing tables 0.01 ms executing 0.01 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.08 ms closing tables 0.01 ms Unlocking tables 0.00 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:430 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:312 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:250 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.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.55 ms Utolsó lekérdezés után: 7.00 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 4.646 MB Visszaadott sorok: 1
SELECT *
FROM j3_content
WHERE `id` = '674'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_content const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.02 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.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.06 ms preparing 0.01 ms Unlocking tables 0.02 ms executing 0.01 ms Sending data 0.04 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.00 ms storing result in query cache 1.52 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:730 10 Joomla\CMS\Table\Table->load() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.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.29 ms Utolsó lekérdezés után: 0.23 ms Memória lekérdezése: 0.014 MB memória a lekérdezés előtt: 4.661 MB
UPDATE j3_content
SET `hits` = (`hits` + 1)
WHERE `id` = '674'Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE j3_content SET `hits` = (`hits` + 1) WHERE `id` = '674'Status Duration starting 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 init 0.05 ms updating 0.08 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 4.60 ms query end 0.08 ms closing tables 0.00 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1241 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:252 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.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.32 ms Utolsó lekérdezés után: 2.23 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 4.809 MB Visszaadott sorok: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM j3_content AS a
INNER JOIN j3_categories AS c
on c.id = a.catid
LEFT JOIN j3_users AS u
on u.id = a.created_by
LEFT JOIN j3_categories as parent
ON parent.id = c.parent_id
LEFT JOIN j3_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 674
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-02-27 06:35:34')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-02-27 06:35:34')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 unique row not found Status Duration starting 0.02 ms Waiting for query cache lock 1.44 ms init 0.01 ms checking query cache for query 0.14 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Waiting for query cache lock 0.07 ms init 0.07 ms optimizing 0.04 ms statistics 0.12 ms preparing 0.01 ms Unlocking tables 0.02 ms executing 0.00 ms Sending data 0.05 ms end 0.01 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.01 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:148 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.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.16 ms Utolsó lekérdezés után: 3.33 ms Memória lekérdezése: 0.036 MB memória a lekérdezés előtt: 5.001 MB Visszaadott sorok: 3
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=160
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 233 Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.97 ms init 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms checking permissions 0.03 ms sending cached result to clien 0.01 ms updating status 0.00 ms cleaning up 0.01 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:305 21 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 20 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 19 ContentRouter->getCategorySegment() Same as call in the line below. 18 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 17 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 16 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 15 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:669 14 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/article/view.html.php:71 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.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.42 ms Utolsó lekérdezés után: 1.42 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 5.080 MB Visszaadott sorok: 0
SELECT `m`.`tag_id`,`t`.*
FROM `j3_contentitem_tag_map` AS m
INNER JOIN `j3_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 674
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t ALL PRIMARY,tag_idx,idx_access NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 135 Using where 1 SIMPLE m ref idx_tag_type idx_tag_type 4 diplohu_j25.t.id 6 Using index condition; Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.08 ms init 0.02 ms checking query cache for query 0.05 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.03 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.05 ms optimizing 0.03 ms statistics 0.08 ms preparing 0.03 ms executing 0.00 ms Sending data 0.80 ms end 0.01 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.03 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.19 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:180 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.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.23 ms Utolsó lekérdezés után: 12.39 ms Memória lekérdezése: 0.032 MB memória a lekérdezés előtt: 6.001 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
LEFT JOIN `j3_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (160,0,159))
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 1 SIMPLE fc ref PRIMARY PRIMARY 4 diplohu_j25.a.id 1 Using where; Using index Status Duration starting 0.03 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 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_content/views/article/view.html.php:190 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.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.36 ms Utolsó lekérdezés után: 7.65 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 6.665 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.03 ms Waiting for query cache lock 2.11 ms init 0.02 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_content/views/article/view.html.php:196 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.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.20 ms Utolsó lekérdezés után: 0.19 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 6.687 MB Visszaadott sorok: 1Duplikált lekérdezések: #54
SELECT `id`
FROM `j3_tortags_components`
WHERE `component`='com_content'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 Using where Status Duration starting 0.02 ms Waiting for query cache lock 1.10 ms init 0.01 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:1730 16 JDatabaseDriver->loadResult() JROOT/plugins/content/tortags/tortags.php:278 15 plgContentTorTags->getOidByOption() JROOT/plugins/content/tortags/tortags.php:187 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_content/views/article/view.html.php:196 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.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: 4.87 ms Utolsó lekérdezés után: 0.13 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 6.711 MB Visszaadott sorok: 4
SELECT `t`.*
FROM `j3_tortags_tags` AS `t`
INNER JOIN `j3_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=674
AND `m`.`oid`=1
AND `t`.`published`=1
ORDER BY `t`.`title` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2446 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE t eq_ref PRIMARY PRIMARY 4 diplohu_j25.m.tid 1 Using where Status Duration starting 0.01 ms Waiting for query cache lock 3.16 ms init 0.02 ms checking query cache for query 0.06 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 0.03 ms init 0.02 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.03 ms executing 0.01 ms Creating tmp table 0.03 ms Copying to tmp table 0.33 ms Sorting result 0.02 ms Sending data 0.02 ms end 0.01 ms removing tmp table 0.13 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.00 ms Waiting for query cache lock 0.73 ms updating status 0.02 ms Waiting for query cache lock 0.01 ms updating status 0.00 ms storing result in query cache 2.92 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 16 JDatabaseDriver->loadObjectList() JROOT/plugins/content/tortags/tortags.php:267 15 plgContentTorTags->getTags() JROOT/plugins/content/tortags/tortags.php:188 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_content/views/article/view.html.php:196 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.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.38 ms Utolsó lekérdezés után: 1.61 ms Memória lekérdezése: 0.030 MB memória a lekérdezés előtt: 6.758 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.02 ms init 0.01 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 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 24 JDatabaseDriver->loadColumn() JROOT/plugins/content/tortags/tortags.php:229 23 plgContentTorTags->getAlloweComponents() JROOT/plugins/content/tortags/tortags.php:104 22 plgContentTorTags->onContentPrepare() Same as call in the line below. 21 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 20 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 19 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 18 JHtmlContent::prepare() Same as call in the line below. 17 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 16 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 15 Joomla\CMS\HTML\HTMLHelper::_() JROOT/plugins/content/tortags/tortags.php:198 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_content/views/article/view.html.php:196 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.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.08 ms Utolsó lekérdezés után: 0.28 ms Memória lekérdezése: 0.030 MB memória a lekérdezés előtt: 6.789 MB Visszaadott sorok: 1
SELECT `component`
FROM `j3_tortags_components`
WHERE `id`='1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_tortags_components const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.01 ms Waiting for query cache lock 0.84 ms init 0.03 ms checking query cache for query 0.01 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 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 24 JDatabaseDriver->loadResult() JROOT/plugins/content/tortags/tortags.php:241 23 plgContentTorTags->getOptionByOid() JROOT/plugins/content/tortags/tortags.php:116 22 plgContentTorTags->onContentPrepare() Same as call in the line below. 21 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 20 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 19 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 18 JHtmlContent::prepare() Same as call in the line below. 17 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 16 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 15 Joomla\CMS\HTML\HTMLHelper::_() JROOT/plugins/content/tortags/tortags.php:198 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_content/views/article/view.html.php:196 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.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.65 ms Utolsó lekérdezés után: 1.67 ms Memória lekérdezése: 0.032 MB memória a lekérdezés előtt: 6.850 MB Visszaadott sorok: 4
SELECT `t`.*
FROM `j3_tortags_tags` AS `t`
INNER JOIN `j3_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=674
AND `m`.`oid`=1
AND `t`.`published`=1
ORDER BY `t`.`title` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2446 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE t eq_ref PRIMARY PRIMARY 4 diplohu_j25.m.tid 1 Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.51 ms init 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms updating status 0.00 ms cleaning up 0.00 ms # Caller File and line number 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 25 JDatabaseDriver->loadObjectList() JROOT/plugins/content/tortags/tortags.php:267 24 plgContentTorTags->getTags() JROOT/plugins/content/tortags/tortags.php:135 23 plgContentTorTags->getReturnTags() JROOT/plugins/content/tortags/tortags.php:125 22 plgContentTorTags->onContentPrepare() Same as call in the line below. 21 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 20 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 19 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 18 JHtmlContent::prepare() Same as call in the line below. 17 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 16 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 15 Joomla\CMS\HTML\HTMLHelper::_() JROOT/plugins/content/tortags/tortags.php:198 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_content/views/article/view.html.php:196 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.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.72 ms Utolsó lekérdezés után: 4.00 ms Memória lekérdezése: 0.077 MB memória a lekérdezés előtt: 7.056 MB Visszaadott sorok: 1303
SELECT `id`,`name`,`rules`,`parent_id`
FROM `j3_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_assets ALL idx_asset_name,idx_parent_id NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 1954 Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.81 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.07 ms updating status 0.01 ms cleaning up 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 19 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/plugins/content/pagenavigation/pagenavigation.php:54 14 PlgContentPagenavigation->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_content/views/article/view.html.php:196 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.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.90 ms Utolsó lekérdezés után: 8.28 ms Memória lekérdezése: 0.033 MB memória a lekérdezés előtt: 9.274 MB Visszaadott sorok: 8
SHOW FULL COLUMNS
FROM `j3_assets`Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `j3_assets`Status Duration starting 0.05 ms checking permissions 0.01 ms closing tables 0.01 ms Opening tables 0.34 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.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms closing tables 0.01 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.08 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 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 23 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:430 22 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 21 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 20 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Asset.php:61 19 Joomla\CMS\Table\Asset->__construct() JROOT/libraries/src/Access/Access.php:783 18 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/plugins/content/pagenavigation/pagenavigation.php:54 14 PlgContentPagenavigation->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_content/views/article/view.html.php:196 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.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.19 ms Utolsó lekérdezés után: 0.38 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 9.327 MB Visszaadott sorok: 0Duplikált lekérdezések: #35
SELECT *
FROM j3_assets
WHERE `name` = 'com_content.article.674'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.01 ms Waiting for query cache lock 1.83 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.01 ms Table lock 0.01 ms Waiting for query cache lock 0.03 ms init 0.02 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.02 ms end 0.01 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.00 ms storing result in query cache 1.57 ms cleaning up 0.01 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 20 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:730 19 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Access/Access.php:784 18 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/plugins/content/pagenavigation/pagenavigation.php:54 14 PlgContentPagenavigation->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_content/views/article/view.html.php:196 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.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: 3.38 ms Utolsó lekérdezés után: 0.72 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 9.131 MB Visszaadott sorok: 9
SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM j3_content AS a
LEFT JOIN j3_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 160
AND a.state = 1
AND a.access IN (1,1,5)
AND (a.state = 1 OR a.state = -1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2021-02-27 06:35:34')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2021-02-27 06:35:34')
ORDER BY a.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a index_merge idx_access,idx_state,idx_catid idx_catid,idx_state 4,1 NULL 6 Using intersect(idx_catid,idx_state); Using where; Fájlrendezés használata 1 SIMPLE cc const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.10 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Waiting for query cache lock 1.43 ms init 0.05 ms optimizing 0.05 ms statistics 0.10 ms preparing 0.03 ms executing 0.00 ms Sorting result 0.47 ms Sending data 0.15 ms end 0.01 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.01 ms updating status 0.00 ms storing result in query cache 0.56 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/plugins/content/pagenavigation/pagenavigation.php:159 14 PlgContentPagenavigation->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_content/views/article/view.html.php:196 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.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.17 ms Utolsó lekérdezés után: 19.71 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 9.828 MB Visszaadott sorok: 0Duplikált lekérdezések: #33
SELECT *
FROM j3_assets
WHERE `name` = 'com_content.article.674'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.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.01 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:1455 19 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:730 18 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Access/Access.php:784 17 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/templates/transform/html/com_content/article/default.php:62 13 include JROOT/templates/transform/html/com_content/article/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_content/views/article/view.html.php:207 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.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.41 ms Utolsó lekérdezés után: 6.80 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 9.664 MB Visszaadott sorok: 19
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM j3_modules AS m
LEFT JOIN j3_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN j3_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-02-27 06:35:34')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-02-27 06:35:34')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 310 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 22 Using index condition; Using where; Fájlrendezés használata 1 SIMPLE mm ref PRIMARY PRIMARY 4 diplohu_j25.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 diplohu_j25.m.module,const 1 Using index condition; 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.11 ms checking permissions 0.01 ms checking permissions 0.00 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.05 ms optimizing 0.06 ms statistics 0.11 ms preparing 0.07 ms executing 0.01 ms Sorting result 0.28 ms Sending data 0.39 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.03 ms Waiting for query cache lock 0.01 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 14 JDatabaseDriver->loadObjectList() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:433 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:363 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:581 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/transform/index.php:95 7 require JROOT/templates/transform/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1103 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.08 ms Utolsó lekérdezés után: 0.42 ms Memória lekérdezése: 0.013 MB memória a lekérdezés előtt: 9.708 MB Visszaadott sorok: 2
select link
from j3_menu
where title="Kezdőlap"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_menu ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 250 Using where 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 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 8 JDatabaseDriver->loadObject() JROOT/templates/transform/index.php:268 7 require JROOT/templates/transform/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1103 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.05 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.013 MB memória a lekérdezés előtt: 9.721 MB Visszaadott sorok: 1
select title
from j3_categories
where id=273id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_categories const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.00 ms Waiting for query cache lock 0.01 ms init 0.00 ms checking query cache for query 0.00 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 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 8 JDatabaseDriver->loadObject() JROOT/templates/transform/index.php:277 7 require JROOT/templates/transform/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1103 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.17 ms Utolsó lekérdezés után: 9.28 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 9.801 MB Visszaadott sorok: 200
SELECT '' AS `slug`, t.`title`, COUNT(x.`tid`) `frequency`
FROM j3_tortags x, j3_tortags_tags t
WHERE t.`id`=x.`tid`
AND `t`.`published`=1
GROUP BY t.`id`
ORDER BY t.`title` DESC
LIMIT 200id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE x ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2446 Using temporary; Fájlrendezés használata 1 SIMPLE t eq_ref PRIMARY PRIMARY 4 diplohu_j25.x.tid 1 Using where 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.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.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_tortags_often_clouds/helper.php:32 11 modTorTagsOftenCloudsHelper::getList() JROOT/modules/mod_tortags_often_clouds/mod_tortags_often_clouds.php:16 10 include JROOT/modules/mod_tortags_often_clouds/mod_tortags_often_clouds.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.53 ms Utolsó lekérdezés után: 24.98 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 10.481 MB Visszaadott sorok: 0
SELECT *
FROM j3_banners
WHERE '2021-02-27 06:35:34' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL NULL Impossible WHERE Status Duration starting 0.04 ms Waiting for query cache lock 0.01 ms init 0.02 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.10 ms init 0.04 ms optimizing 0.02 ms executing 0.03 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.00 ms updating status 0.02 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.25 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_banners/helpers/banners.php:79 11 BannersHelper::updateReset() JROOT/modules/mod_banners/mod_banners.php:19 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 1.17 ms Utolsó lekérdezés után: 1.33 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 10.607 MB Visszaadott sorok: 1
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM j3_banners as a
LEFT JOIN j3_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-02-27 06:35:34')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-02-27 06:35:34')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 2
AND cl.state = 1
AND a.catid IN (246)
ORDER BY a.sticky DESC, RAND()
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cl const PRIMARY PRIMARY 4 const 1 Using temporary; Fájlrendezés használata 1 SIMPLE a index_merge idx_state,idx_banner_catid idx_banner_catid,idx_state 4,1 NULL 7 Using intersect(idx_banner_catid,idx_state); Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.09 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms init 0.04 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.01 ms Unlocking tables 0.05 ms executing 0.01 ms Creating tmp table 0.25 ms Copying to tmp table 0.30 ms Sorting result 0.04 ms Sending data 0.03 ms end 0.02 ms removing tmp table 0.07 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.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_banners/models/banners.php:205 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:44 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 142.69 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: 10.636 MB
UPDATE j3_banners
SET impmade = (impmade + 1)
WHERE id IN (113)Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE j3_banners SET impmade = (impmade + 1) WHERE id IN (113)Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms init 0.04 ms updating 0.05 ms end 0.00 ms Waiting for query cache lock 0.01 ms end 0.02 ms query end 142.33 ms closing tables 0.03 ms Unlocking tables 0.03 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:249 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:48 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.59 ms Utolsó lekérdezés után: 5.85 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 10.680 MB Visszaadott sorok: 1
select catid
from j3_content
where id="674"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_content const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.03 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.04 ms init 0.02 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.01 ms Unlocking tables 0.02 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.03 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.12 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 13 JDatabaseDriver->loadObject() JROOT/components/com_jumi/files/tartalom.php:22 12 include JROOT/components/com_jumi/files/tartalom.php JROOT/modules/mod_jumi/tmpl/default.php:24 11 require JROOT/modules/mod_jumi/tmpl/default.php JROOT/modules/mod_jumi/mod_jumi.php:23 10 include JROOT/modules/mod_jumi/mod_jumi.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.12 ms Utolsó lekérdezés után: 0.30 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 10.699 MB Visszaadott sorok: 1
select title
from j3_categories
where id="160"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_categories 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:1652 13 JDatabaseDriver->loadObject() JROOT/components/com_jumi/files/tartalom.php:46 12 include JROOT/components/com_jumi/files/tartalom.php JROOT/modules/mod_jumi/tmpl/default.php:24 11 require JROOT/modules/mod_jumi/tmpl/default.php JROOT/modules/mod_jumi/mod_jumi.php:23 10 include JROOT/modules/mod_jumi/mod_jumi.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.93 ms Utolsó lekérdezés után: 0.18 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 10.718 MB Visszaadott sorok: 9
select `id`,`title`
from j3_content
where catid="160"
and state=1
order by `ordering`
limit 20id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_content index_merge idx_state,idx_catid idx_catid,idx_state 4,1 NULL 6 Using intersect(idx_catid,idx_state); 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.05 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 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.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.46 ms Sending data 0.12 ms end 0.01 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.01 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 4.05 ms cleaning up 0.02 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() JROOT/components/com_jumi/files/tartalom.php:54 12 include JROOT/components/com_jumi/files/tartalom.php JROOT/modules/mod_jumi/tmpl/default.php:24 11 require JROOT/modules/mod_jumi/tmpl/default.php JROOT/modules/mod_jumi/mod_jumi.php:23 10 include JROOT/modules/mod_jumi/mod_jumi.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 6.94 ms Utolsó lekérdezés után: 7.01 ms Memória lekérdezése: 0.045 MB memória a lekérdezés előtt: 11.095 MB Visszaadott sorok: 2
SELECT DISTINCT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM j3_content AS a
LEFT JOIN j3_categories AS c
ON c.id = a.catid
LEFT JOIN j3_users AS ua
ON ua.id = a.created_by
LEFT JOIN j3_users AS uam
ON uam.id = a.modified_by
LEFT JOIN j3_categories as parent
ON parent.id = c.parent_id
LEFT JOIN j3_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid IN (68)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-02-27 06:35:34')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-02-27 06:35:34')
ORDER BY a.title ASC
LIMIT 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 Using temporary; Fájlrendezés használata 1 SIMPLE a ref idx_access,idx_state,idx_catid idx_catid 4 const 785 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 diplohu_j25.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 diplohu_j25.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 const 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 diplohu_j25.a.id 1 Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms init 0.00 ms checking query cache for query 0.21 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Waiting for query cache lock 0.14 ms init 0.10 ms optimizing 0.05 ms statistics 0.22 ms preparing 0.01 ms Unlocking tables 0.05 ms executing 0.01 ms Creating tmp table 0.50 ms Copying to tmp table 4.92 ms Sorting result 0.05 ms Sending data 0.09 ms Waiting for query cache lock 0.00 ms Sending data 0.18 ms end 0.01 ms removing tmp table 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.03 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.03 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/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:556 15 ContentModelArticles->getItems() JROOT/modules/mod_articles_category/helper.php:229 14 ModArticlesCategoryHelper::getList() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:560 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_articles_category/mod_articles_category.php:61 10 include JROOT/modules/mod_articles_category/mod_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.18 ms Utolsó lekérdezés után: 1.60 ms Memória lekérdezése: 0.040 MB memória a lekérdezés előtt: 11.206 MB Visszaadott sorok: 3
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=68
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 233 Using where 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.01 ms checking permissions 0.00 ms sending cached result to clien 0.01 ms updating status 0.00 ms cleaning up 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 26 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:305 25 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 24 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 23 ContentRouter->getCategorySegment() Same as call in the line below. 22 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 21 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 20 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 19 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:669 18 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 17 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 16 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 15 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_category/helper.php:265 14 ModArticlesCategoryHelper::getList() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:560 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_articles_category/mod_articles_category.php:61 10 include JROOT/modules/mod_articles_category/mod_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 9.56 ms Utolsó lekérdezés után: 5.01 ms Memória lekérdezése: 0.035 MB memória a lekérdezés előtt: 11.188 MB Visszaadott sorok: 3
SELECT DISTINCT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM j3_content AS a
LEFT JOIN j3_categories AS c
ON c.id = a.catid
LEFT JOIN j3_users AS ua
ON ua.id = a.created_by
LEFT JOIN j3_users AS uam
ON uam.id = a.modified_by
LEFT JOIN j3_categories as parent
ON parent.id = c.parent_id
LEFT JOIN j3_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid IN (125)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-02-27 06:35:34')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-02-27 06:35:34')
ORDER BY a.created DESC
LIMIT 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 Using temporary; Fájlrendezés használata 1 SIMPLE a ref idx_access,idx_state,idx_catid idx_catid 4 const 424 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 diplohu_j25.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 diplohu_j25.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 const 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 diplohu_j25.a.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.31 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 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.10 ms init 0.11 ms optimizing 0.06 ms statistics 0.23 ms preparing 0.01 ms Unlocking tables 0.05 ms executing 0.01 ms Creating tmp table 0.45 ms Copying to tmp table 2.99 ms Sorting result 0.04 ms Sending data 0.10 ms Waiting for query cache lock 1.86 ms Sending data 0.20 ms end 0.01 ms removing tmp table 2.63 ms end 0.02 ms query end 0.01 ms closing tables 0.02 ms Unlocking tables 0.02 ms freeing items 0.03 ms updating status 0.01 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 1.43 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:556 15 ContentModelArticles->getItems() JROOT/modules/mod_articles_category/helper.php:229 14 ModArticlesCategoryHelper::getList() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:560 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_articles_category/mod_articles_category.php:61 10 include JROOT/modules/mod_articles_category/mod_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 1.73 ms Utolsó lekérdezés után: 1.51 ms Memória lekérdezése: 0.040 MB memória a lekérdezés előtt: 11.317 MB Visszaadott sorok: 3
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=125
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 233 Using where Status Duration starting 0.01 ms Waiting for query cache lock 1.54 ms init 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 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.00 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 26 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:305 25 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 24 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 23 ContentRouter->getCategorySegment() Same as call in the line below. 22 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 21 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 20 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 19 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:669 18 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 17 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 16 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 15 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_category/helper.php:265 14 ModArticlesCategoryHelper::getList() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:560 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_articles_category/mod_articles_category.php:61 10 include JROOT/modules/mod_articles_category/mod_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 1.83 ms Utolsó lekérdezés után: 12.41 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 12.170 MB Visszaadott sorok: 171
SELECT *
FROM j3_acymailing_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_acymailing_config ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 171 Status Duration starting 0.03 ms Waiting for query cache lock 1.51 ms init 0.02 ms checking query cache for query 0.01 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 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:450 15 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:17 14 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:434 13 acymailing_config() JROOT/administrator/components/com_acymailing/compat/joomla.php:789 12 include_once JROOT/administrator/components/com_acymailing/compat/joomla.php JROOT/administrator/components/com_acymailing/helpers/helper.php:21 11 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/modules/mod_acymailing/mod_acymailing.php:13 10 include JROOT/modules/mod_acymailing/mod_acymailing.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.17 ms Utolsó lekérdezés után: 9.61 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 12.983 MB Visszaadott sorok: 3
SELECT *
FROM j3_acymailing_list
WHERE type = 'list'
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_acymailing_list ref typeorderingindex,typeuseridindex typeorderingindex 1 const 2 Using index condition; Using where 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.01 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:450 12 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/list.php:30 11 listClass->getLists() JROOT/modules/mod_acymailing/mod_acymailing.php:105 10 include JROOT/modules/mod_acymailing/mod_acymailing.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.15 ms Utolsó lekérdezés után: 23.78 ms Memória lekérdezése: 0.015 MB memória a lekérdezés előtt: 13.649 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.03 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 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 10 JDatabaseDriver->loadColumn() JROOT/plugins/system/tortags/tortags.php:386 9 plgSystemtortags->getAlloweComponents() JROOT/plugins/system/tortags/tortags.php:183 8 plgSystemtortags->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1123 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.12 ms Utolsó lekérdezés után: 0.12 ms Memória lekérdezése: 0.018 MB memória a lekérdezés előtt: 13.664 MB Visszaadott sorok: 1
SELECT *
FROM `j3_tortags_components`
WHERE `component`='com_content'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 Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.02 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 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 10 JDatabaseDriver->loadObject() JROOT/plugins/system/tortags/tortags.php:398 9 plgSystemtortags->getCompDetails() JROOT/plugins/system/tortags/tortags.php:191 8 plgSystemtortags->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1123 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.28 ms Utolsó lekérdezés után: 0.18 ms Memória lekérdezése: 0.015 MB memória a lekérdezés előtt: 13.682 MB Visszaadott sorok: 1Duplikált lekérdezések: #26
SELECT `id`
FROM `j3_tortags_components`
WHERE `component`='com_content'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 Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.19 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 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 10 JDatabaseDriver->loadResult() JROOT/plugins/system/tortags/tortags.php:412 9 plgSystemtortags->getTags() JROOT/plugins/system/tortags/tortags.php:249 8 plgSystemtortags->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1123 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.09 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.016 MB memória a lekérdezés előtt: 13.698 MB Visszaadott sorok: 4
SELECT `t`.*
FROM `j3_tortags_tags` AS `t`
INNER JOIN `j3_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=674
AND `m`.`oid`=1
AND `t`.`published`=1
ORDER BY `t`.`title` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL NULL NEM LEHETETT INDEXKULCSOT HASZNÁLNI NULL NULL 2446 Using where; Using temporary; Fájlrendezés használata 1 SIMPLE t eq_ref PRIMARY PRIMARY 4 diplohu_j25.m.tid 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.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:1691 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/tortags/tortags.php:423 9 plgSystemtortags->getTags() JROOT/plugins/system/tortags/tortags.php:249 8 plgSystemtortags->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1123 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Lekérdezés ideje: 0.21 ms Utolsó lekérdezés után: 1.41 ms Memória lekérdezése: 0.031 MB memória a lekérdezés előtt: 13.753 MB Visszaadott sorok: 3
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=39
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 233 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.02 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms sending cached result to clien 0.02 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:305 17 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 16 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/helpers/legacyrouter.php:173 15 ContentRouterRulesLegacy->build() JROOT/libraries/src/Component/Router/RouterView.php:244 14 Joomla\CMS\Component\Router\RouterView->build() JROOT/libraries/src/Router/SiteRouter.php:528 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 9 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 8 PlgSystemSef->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1123 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51
41 naplózott lekérdezéstípus, rendezés előfordulás szerint
SELECT táblák:
5 × 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)4 × SELECT `component`
FROM `j3_tortags_components3 × SELECT `t`.*
FROM `j3_tortags_tags` AS `t`
INNER JOIN `j3_tortags` AS `m`
ON `m`.`tid`=`t`.`id`2 × SELECT *
FROM j3_assets2 × select title
from j3_categories2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j3_extensions`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `j3_assets`2 × SELECT `id`
FROM `j3_tortags_components`2 × SELECT DISTINCT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM j3_content AS a
LEFT JOIN j3_categories AS c
ON c.id = a.catid
LEFT JOIN j3_users AS ua
ON ua.id = a.created_by
LEFT JOIN j3_users AS uam
ON uam.id = a.modified_by
LEFT JOIN j3_categories as parent
ON parent.id = c.parent_id
LEFT JOIN j3_content_rating AS v
ON a.id = v.content_id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM j3_modules AS m
LEFT JOIN j3_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN j3_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × select link
from j3_menu1 × SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM j3_content AS a
LEFT JOIN j3_categories AS cc
ON cc.id = a.catid1 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM j3_banners as a
LEFT JOIN j3_banner_clients AS cl
ON cl.id = a.cid1 × SELECT *
FROM j3_acymailing_confi1 × SELECT *
FROM j3_acymailing_list1 × select `id`,`title`
from j3_content1 × select catid
from j3_content1 × SELECT *
FROM j3_banners1 × SELECT *
FROM `j3_tortags_components`1 × SELECT '' AS `slug`, t.`title`, COUNT(x.`tid`) `frequency`
FROM j3_tortags x, j3_tortags_tags t1 × 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
LEFT JOIN `j3_fields_categories` AS fc
ON fc.field_id = a.id1 × 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_id1 × select id, title, alias
from j3_jumi1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM j3_extensions1 × SELECT b.id
FROM j3_usergroups AS a
LEFT JOIN j3_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `session_id`
FROM `j3_session`1 × SELECT id, rules
FROM `j3_viewlevels1 × SELECT `alias`,`catid`
FROM `j3_content`1 × SELECT *
FROM j3_languages1 × SELECT `m`.`tag_id`,`t`.*
FROM `j3_contentitem_tag_map` AS m
INNER JOIN `j3_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT `data`
FROM `j3_session`1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM j3_content AS a
INNER JOIN j3_categories AS c
on c.id = a.catid
LEFT JOIN j3_users AS u
on u.id = a.created_by
LEFT JOIN j3_categories as parent
ON parent.id = c.parent_id
LEFT JOIN j3_content_rating AS v
ON a.id = v.content_id1 × SELECT *
FROM j3_content1 × 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_id1 × SELECT `component`
FROM `j3_tortags_components`
EGYÉB táblák:
1 × SHOW FULL COLUMNS
FROM `j3_assets1 × UPDATE j3_banners
SET impmade = (impmade + 1)1 × UPDATE j3_content
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `j3_content1 × UPDATE `j3_extensions`
SET `params` = '{\"mediaversion\":\"230cbeefd6fcbae0a93db6264edfa525\"}'1 × INSERT INTO `j3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('hcv1h7lsebdqe8epgudiv1tjk4', 1, '1614407732', 0, '', 0