Lekérdezés ideje: 2.13 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 1.033 MB Visszaadott sorok: 1
SELECT `data`
FROM `szakmai2_session`
WHERE `session_id` = X'3762333062333534316233316466393635663861353064316366366462636662'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
Status | Duration |
---|
Starting | 0.24 ms |
Checking permissions | 0.08 ms |
Opening tables | 0.09 ms |
After opening tables | 0.06 ms |
System lock | 0.06 ms |
Table lock | 0.06 ms |
Init | 0.09 ms |
Optimizing | 0.08 ms |
Statistics | 0.14 ms |
Preparing | 0.07 ms |
Unlocking tables | 0.06 ms |
Preparing | 0.08 ms |
Executing | 0.09 ms |
Sending data | 0.07 ms |
End of update loop | 0.06 ms |
Query end | 0.06 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.07 ms |
Starting cleanup | 0.06 ms |
Freeing items | 0.05 ms |
Updating status | 0.17 ms |
Reset for next command | 0.10 ms |
# | Hívó | Fájl és sorok száma |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
14 | JSessionStorageDatabase->read() | Ugyanaz a hívás, mint egy sorral lejjebb. |
13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:661 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Lekérdezés ideje: 2.97 ms Utolsó lekérdezés után: 3.00 ms Memória lekérdezése: 0.040 MB memória a lekérdezés előtt: 1.078 MB Visszaadott sorok: 42
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `szakmai2_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_extensions | ref | extension | extension | 82 | const | 42 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.16 ms |
Checking permissions | 0.07 ms |
Opening tables | 0.08 ms |
After opening tables | 0.06 ms |
System lock | 0.05 ms |
Table lock | 0.06 ms |
Init | 0.09 ms |
Optimizing | 0.10 ms |
Statistics | 0.19 ms |
Preparing | 0.17 ms |
Executing | 0.06 ms |
Sending data | 0.94 ms |
End of update loop | 0.07 ms |
Query end | 0.06 ms |
Commit | 0.05 ms |
Closing tables | 0.06 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.07 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.06 ms |
Updating status | 0.14 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Ugyanaz a hívás, mint egy sorral lejjebb. |
9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 1.76 ms Utolsó lekérdezés után: 2.61 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.126 MB Visszaadott sorok: 3
SELECT id, rules
FROM `szakmai2_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_viewlevels | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 3 | |
Status | Duration |
---|
Starting | 0.11 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.09 ms |
After opening tables | 0.06 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.09 ms |
Optimizing | 0.06 ms |
Statistics | 0.08 ms |
Preparing | 0.07 ms |
Executing | 0.05 ms |
Sending data | 0.16 ms |
End of update loop | 0.08 ms |
Query end | 0.05 ms |
Commit | 0.06 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.18 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 2.13 ms Utolsó lekérdezés után: 0.24 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.137 MB Visszaadott sorok: 1
SELECT b.id
FROM szakmai2_usergroups AS a
LEFT JOIN szakmai2_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
id | 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 | 1 | Using where; Using index |
Status | Duration |
---|
Starting | 0.14 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.12 ms |
After opening tables | 0.06 ms |
System lock | 0.05 ms |
Table lock | 0.08 ms |
Init | 0.08 ms |
Optimizing | 0.08 ms |
Statistics | 0.18 ms |
Preparing | 0.07 ms |
Unlocking tables | 0.06 ms |
Preparing | 0.09 ms |
Executing | 0.06 ms |
Sending data | 0.16 ms |
End of update loop | 0.07 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.10 ms |
Unlocking tables | 0.06 ms |
Closing tables | 0.07 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.06 ms |
Updating status | 0.16 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 4.16 ms Utolsó lekérdezés után: 0.49 ms Memória lekérdezése: 0.093 MB memória a lekérdezés előtt: 1.158 MB Visszaadott sorok: 96
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM szakmai2_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_extensions | ref | extension | extension | 82 | const | 123 | Using index condition; Using where; Fájlrendezés használata |
Status | Duration |
---|
Starting | 0.15 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.07 ms |
After opening tables | 0.06 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.10 ms |
Optimizing | 0.08 ms |
Statistics | 0.13 ms |
Preparing | 0.15 ms |
Sorting result | 0.07 ms |
Executing | 0.05 ms |
Sending data | 0.06 ms |
Creating sort index | 2.20 ms |
End of update loop | 0.08 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.06 ms |
Freeing items | 0.06 ms |
Updating status | 0.16 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 |
9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Ugyanaz a hívás, mint egy sorral lejjebb. |
8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:356 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 2.15 ms Utolsó lekérdezés után: 40.09 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.650 MB Visszaadott sorok: 1
SELECT `template`
FROM `szakmai2_template_styles`
WHERE `client_id` = 0
AND `home` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_template_styles | ref | idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 6 | Using where |
Status | Duration |
---|
Starting | 0.13 ms |
Checking permissions | 0.07 ms |
Opening tables | 0.08 ms |
After opening tables | 0.06 ms |
System lock | 0.06 ms |
Table lock | 0.05 ms |
Init | 0.08 ms |
Optimizing | 0.13 ms |
Statistics | 0.18 ms |
Preparing | 0.11 ms |
Executing | 0.06 ms |
Sending data | 0.24 ms |
End of update loop | 0.07 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.07 ms |
Closing tables | 0.09 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.17 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
10 | JDatabaseDriver->loadObject() | JROOT/plugins/system/helix3/helix3.php:247 |
9 | plgSystemHelix3->getTemplateName() | JROOT/plugins/system/helix3/helix3.php:41 |
8 | plgSystemHelix3->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 2.16 ms Utolsó lekérdezés után: 4.10 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.666 MB Visszaadott sorok: 1
SELECT *
FROM szakmai2_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_languages | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 2 | Using where; Fájlrendezés használata |
Status | Duration |
---|
Starting | 0.11 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.11 ms |
After opening tables | 0.06 ms |
System lock | 0.10 ms |
Table lock | 0.09 ms |
Init | 0.09 ms |
Optimizing | 0.07 ms |
Statistics | 0.07 ms |
Preparing | 0.08 ms |
Sorting result | 0.06 ms |
Executing | 0.05 ms |
Sending data | 0.08 ms |
Creating sort index | 0.21 ms |
End of update loop | 0.07 ms |
Query end | 0.08 ms |
Commit | 0.06 ms |
Closing tables | 0.06 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.16 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
10 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:100 |
9 | Sh404sefClassPageinfo->init() | JROOT/plugins/system/sh404sef/sh404sef.php:47 |
8 | plgSystemSh404sef->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 2.69 ms Utolsó lekérdezés után: 1.69 ms Memória lekérdezése: 0.044 MB memória a lekérdezés előtt: 1.696 MB Visszaadott sorok: 9
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 szakmai2_menu AS m
LEFT JOIN szakmai2_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.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | range | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | NULL | 10 | Using index condition; Using where; Fájlrendezés használata |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | belvaros_jozsefvar.m.component_id | 1 | Using where |
Status | Duration |
---|
Starting | 0.18 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.10 ms |
After opening tables | 0.06 ms |
System lock | 0.05 ms |
Table lock | 0.08 ms |
Init | 0.11 ms |
Optimizing | 0.10 ms |
Statistics | 0.15 ms |
Preparing | 0.12 ms |
Sorting result | 0.07 ms |
Executing | 0.05 ms |
Sending data | 0.07 ms |
Creating sort index | 0.50 ms |
End of update loop | 0.07 ms |
Query end | 0.06 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.06 ms |
Freeing items | 0.06 ms |
Updating status | 0.18 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
19 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Ugyanaz a hívás, mint egy sorral lejjebb. |
18 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
17 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
16 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
15 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
14 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
13 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
12 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
11 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:131 |
10 | Sh404sefClassPageinfo->loadHomepages() | JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:103 |
9 | Sh404sefClassPageinfo->init() | JROOT/plugins/system/sh404sef/sh404sef.php:47 |
8 | plgSystemSh404sef->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 2.06 ms Utolsó lekérdezés után: 4.24 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 1.862 MB Visszaadott sorok: 1
SELECT `params`
FROM szakmai2_extensions
WHERE `element`='com_sh404sef'
AND `type`='component';
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.12 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.07 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.07 ms |
Optimizing | 0.12 ms |
Statistics | 0.24 ms |
Preparing | 0.10 ms |
Executing | 0.05 ms |
Sending data | 0.18 ms |
End of update loop | 0.07 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.09 ms |
Freeing items | 0.06 ms |
Updating status | 0.16 ms |
Reset for next command | 0.08 ms |
# | Hívó | Fájl és sorok száma |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:716 |
14 | ShlDbClass->loadResult() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:364 |
13 | ShlDbClass->shlLoadResult() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483 |
12 | ShlDbHelper::selectResult() | JROOT/administrator/components/com_sh404sef/helpers/general.php:111 |
11 | Sh404sefHelperGeneral::getComponentParams() | JROOT/administrator/components/com_sh404sef/classes/config.php:560 |
10 | Sh404sefClassConfig->__construct() | JROOT/administrator/components/com_sh404sef/sh404seffactory.php:119 |
9 | Sh404sefFactory::getConfig() | JROOT/plugins/system/sh404sef/sh404sef.php:56 |
8 | plgSystemSh404sef->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 2.31 ms Utolsó lekérdezés után: 16.49 ms Memória lekérdezése: 0.050 MB memória a lekérdezés előtt: 2.091 MB Visszaadott sorok: 357
SELECT `varname`, `value`, `default`
FROM szakmai2_mt_config
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_mt_config | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 357 | |
Status | Duration |
---|
Starting | 0.12 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.08 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.06 ms |
Optimizing | 0.06 ms |
Statistics | 0.06 ms |
Preparing | 0.07 ms |
Executing | 0.05 ms |
Sending data | 0.56 ms |
End of update loop | 0.07 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.17 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_mtree/config.mtree.class.php:81 |
11 | mtConfig->__construct() | JROOT/administrator/components/com_mtree/config.mtree.class.php:30 |
10 | mtFactory::createConfig() | JROOT/administrator/components/com_mtree/config.mtree.class.php:22 |
9 | mtFactory::getConfig() | JROOT/components/com_mtree/init.php:17 |
8 | require_once JROOT/components/com_mtree/init.php | JROOT/components/com_mtree/router.php:14 |
7 | require_once JROOT/components/com_mtree/router.php | JROOT/libraries/src/Router/SiteRouter.php:779 |
6 | Joomla\CMS\Router\SiteRouter->getComponentRouter() | JROOT/libraries/src/Router/SiteRouter.php:131 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 2.09 ms Utolsó lekérdezés után: 6.49 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.316 MB Visszaadott sorok: 0
select `alias`,`newurl`
from `szakmai2_sh404sef_aliases`
where `alias` = 'index.php?option=com_mtree&Itemid=&lang=hu&link_id=527&task=print&tmpl=component' or `alias` = 'index.php' or `alias` = 'index.php/'
order by `alias` desc
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_sh404sef_aliases | range | alias | alias | 767 | NULL | 3 | Using where |
Status | Duration |
---|
Starting | 0.17 ms |
Checking permissions | 0.07 ms |
Opening tables | 0.08 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.09 ms |
Optimizing | 0.07 ms |
Statistics | 0.25 ms |
Preparing | 0.10 ms |
Sorting result | 0.06 ms |
Executing | 0.05 ms |
Sending data | 0.14 ms |
End of update loop | 0.07 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.17 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
14 | JDatabaseDriver->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:657 |
13 | ShlDbClass->loadObject() | JROOT/administrator/components/com_sh404sef/classes/router.php:475 |
12 | Sh404sefClassRouterInternal->_checkAliases() | JROOT/administrator/components/com_sh404sef/classes/router.php:232 |
11 | Sh404sefClassRouterInternal->parseRule() | Ugyanaz a hívás, mint egy sorral lejjebb. |
10 | call_user_func_array() | JROOT/libraries/src/Router/Router.php:596 |
9 | Joomla\CMS\Router\Router->processParseRules() | JROOT/libraries/src/Router/SiteRouter.php:597 |
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:139 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 2.01 ms Utolsó lekérdezés után: 1.23 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 2.344 MB Visszaadott sorok: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `szakmai2_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
Status | Duration |
---|
Starting | 0.13 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.07 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.08 ms |
Optimizing | 0.07 ms |
Statistics | 0.18 ms |
Preparing | 0.15 ms |
Executing | 0.06 ms |
Sending data | 0.21 ms |
End of update loop | 0.07 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.16 ms |
Reset for next command | 0.08 ms |
# | Hívó | Fájl és sorok száma |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
18 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
17 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Ugyanaz a hívás, mint egy sorral lejjebb. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
14 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
13 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
12 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/jcktypography/jcktypography.php:48 |
8 | plgSystemJCKtypography->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 2.89 ms Utolsó lekérdezés után: 0.45 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 2.336 MB
UPDATE `szakmai2_extensions`
SET `params` = '{\"mediaversion\":\"a067a76f0ed07165e9d43c569b9cd412\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE `szakmai2_extensions`
SET `params` = '{\"mediaversion\":\"a067a76f0ed07165e9d43c569b9cd412\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status | Duration |
---|
Starting | 0.14 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.07 ms |
After opening tables | 0.06 ms |
System lock | 0.05 ms |
Table lock | 0.07 ms |
Init for update | 0.21 ms |
Updating | 0.26 ms |
End of update loop | 0.08 ms |
Query end | 0.05 ms |
Commit | 1.20 ms |
Closing tables | 0.07 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.08 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.16 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/jcktypography/jcktypography.php:48 |
8 | plgSystemJCKtypography->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 2.06 ms Utolsó lekérdezés után: 1.09 ms Memória lekérdezése: 0.083 MB memória a lekérdezés előtt: 2.355 MB Visszaadott sorok: 1
SELECT params
FROM szakmai2_extensions
WHERE folder ='editors'
AND element ='jckeditor'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_extensions | ref | element_clientid,element_folder_clientid | element_clientid | 402 | const | 1 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.11 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.07 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.10 ms |
Optimizing | 0.07 ms |
Statistics | 0.15 ms |
Preparing | 0.10 ms |
Executing | 0.05 ms |
Sending data | 0.32 ms |
End of update loop | 0.07 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.06 ms |
Unlocking tables | 0.07 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.06 ms |
Freeing items | 0.05 ms |
Updating status | 0.18 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
9 | JDatabaseDriver->loadResult() | JROOT/plugins/system/jcktypography/jcktypography.php:61 |
8 | plgSystemJCKtypography->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 2.40 ms Utolsó lekérdezés után: 2.07 ms Memória lekérdezése: 0.034 MB memória a lekérdezés előtt: 2.364 MB Visszaadott sorok: 2
SELECT id, home, template, s.params
FROM szakmai2_template_styles as s
LEFT JOIN szakmai2_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 = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 4 | Using index condition; Using where |
1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 9 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
Starting | 0.14 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.09 ms |
After opening tables | 0.10 ms |
System lock | 0.06 ms |
Table lock | 0.05 ms |
Init | 0.09 ms |
Optimizing | 0.09 ms |
Statistics | 0.23 ms |
Preparing | 0.22 ms |
Executing | 0.06 ms |
Sending data | 0.44 ms |
End of update loop | 0.07 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.17 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
4 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/Application/SiteApplication.php:168 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 5.00 ms Utolsó lekérdezés után: 7.63 ms Memória lekérdezése: 0.037 MB memória a lekérdezés előtt: 2.635 MB Visszaadott sorok: 1
SELECT l.*, tlcat.cat_id AS tlcat_id, tlcat.cat_name AS tlcat_name, u.username AS username, u.name AS owner, u.email AS owner_email, cl.cat_id AS cat_id, c.cat_name AS cat_name, c.cat_association, img.filename AS link_image, img.img_id
FROM (szakmai2_mt_links AS l, szakmai2_mt_cl AS cl)
LEFT JOIN szakmai2_users AS u
ON u.id = l.user_id
LEFT JOIN szakmai2_mt_cats AS c
ON c.cat_id = cl.cat_id
LEFT JOIN szakmai2_mt_cats AS tlcat
ON tlcat.lft <= c.lft
AND tlcat.rgt >= c.rgt
AND tlcat.cat_parent =0
LEFT JOIN szakmai2_mt_images AS img
ON img.link_id = l.link_id
AND img.ordering = 1
WHERE link_published='1'
AND link_approved > 0
AND l.link_id='527'
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-05-19 19:31:27' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-05-19 19:31:27' )
AND l.link_id = cl.link_id
AND cl.main = 1
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | l | const | PRIMARY,publishing,count_listfeatured,count_viewowner | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | cl | ref | link_id | link_id | 4 | const | 2 | Using where |
1 | SIMPLE | c | eq_ref | PRIMARY,cat_id | PRIMARY | 4 | belvaros_jozsefvar.cl.cat_id | 1 | |
1 | SIMPLE | tlcat | ref | cat_parent,lft_rgt,func_getPathWay | cat_parent | 4 | const | 70 | Using where |
1 | SIMPLE | img | ref | link_id_ordering,ordering | link_id_ordering | 8 | const,const | 10 | Using where |
Status | Duration |
---|
Starting | 0.34 ms |
Checking permissions | 0.07 ms |
Opening tables | 0.17 ms |
After opening tables | 0.07 ms |
System lock | 0.06 ms |
Table lock | 0.06 ms |
Init | 0.21 ms |
Optimizing | 0.15 ms |
Statistics | 0.56 ms |
Preparing | 0.07 ms |
Unlocking tables | 0.09 ms |
Preparing | 0.14 ms |
Executing | 0.06 ms |
Sending data | 2.00 ms |
End of update loop | 0.07 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.07 ms |
Unlocking tables | 0.07 ms |
Closing tables | 0.08 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.07 ms |
Updating status | 0.16 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
9 | JDatabaseDriver->loadObject() | JROOT/components/com_mtree/mtree.tools.php:35 |
8 | loadLink() | JROOT/components/com_mtree/mtree.php:2846 |
7 | printlink() | JROOT/components/com_mtree/mtree.php:228 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 1.75 ms Utolsó lekérdezés után: 0.16 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.648 MB Visszaadott sorok: 1
SELECT cat_id, cat_parent, metadata, lft, rgt
FROM szakmai2_mt_cats
WHERE cat_id = 230
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_mt_cats | const | PRIMARY,cat_id | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.11 ms |
Checking permissions | 0.08 ms |
Opening tables | 0.07 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.07 ms |
Optimizing | 0.06 ms |
Statistics | 0.11 ms |
Preparing | 0.06 ms |
Unlocking tables | 0.05 ms |
Preparing | 0.06 ms |
Executing | 0.05 ms |
Sending data | 0.06 ms |
End of update loop | 0.05 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.07 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.07 ms |
Freeing items | 0.05 ms |
Updating status | 0.15 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
10 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mtree/config.mtree.class.php:158 |
9 | mtConfig->setCategory() | JROOT/components/com_mtree/mtree.tools.php:39 |
8 | loadLink() | JROOT/components/com_mtree/mtree.php:2846 |
7 | printlink() | JROOT/components/com_mtree/mtree.php:228 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 1.73 ms Utolsó lekérdezés után: 0.17 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.654 MB Visszaadott sorok: 1
SELECT cat_template
FROM szakmai2_mt_cats
WHERE cat_id='230'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_mt_cats | const | PRIMARY,cat_id | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.11 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.09 ms |
After opening tables | 0.07 ms |
System lock | 0.05 ms |
Table lock | 0.06 ms |
Init | 0.07 ms |
Optimizing | 0.07 ms |
Statistics | 0.12 ms |
Preparing | 0.06 ms |
Unlocking tables | 0.05 ms |
Preparing | 0.06 ms |
Executing | 0.05 ms |
Sending data | 0.06 ms |
End of update loop | 0.05 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.07 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.15 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
9 | JDatabaseDriver->loadResult() | JROOT/components/com_mtree/mtree.tools.php:50 |
8 | loadLink() | JROOT/components/com_mtree/mtree.php:2846 |
7 | printlink() | JROOT/components/com_mtree/mtree.php:228 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 3.53 ms Utolsó lekérdezés után: 0.49 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 2.660 MB Visszaadott sorok: 24
SHOW FULL COLUMNS
FROM `szakmai2_mt_cats`
Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `szakmai2_mt_cats`
Status | Duration |
---|
Starting | 0.12 ms |
Checking permissions | 0.06 ms |
Closing tables | 0.05 ms |
Opening tables | 0.83 ms |
After opening tables | 0.07 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.06 ms |
Optimizing | 0.06 ms |
Statistics | 0.06 ms |
Preparing | 0.08 ms |
Executing | 0.06 ms |
Filling schema table | 0.06 ms |
Opening tables | 0.07 ms |
After opening tables | 0.06 ms |
Checking permissions | 0.35 ms |
Closing tables | 0.09 ms |
Executing | 0.05 ms |
Sending data | 0.17 ms |
End of update loop | 0.06 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Removing tmp table | 0.26 ms |
Closing tables | 0.06 ms |
Unlocking tables | 0.07 ms |
Closing tables | 0.05 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.15 ms |
Reset for next command | 0.08 ms |
# | Hívó | Fájl és sorok száma |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
15 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
14 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
13 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_mtree/admin.mtree.class.php:280 |
12 | mtCats->__construct() | JROOT/components/com_mtree/mtree.tools.php:998 |
11 | getTopLevelCatID() | JROOT/components/com_mtree/mtree.tools.php:968 |
10 | getAssignedFieldsID() | JROOT/components/com_mtree/mtree.tools.php:93 |
9 | loadFields() | JROOT/components/com_mtree/mtree.tools.php:60 |
8 | loadLink() | JROOT/components/com_mtree/mtree.php:2846 |
7 | printlink() | JROOT/components/com_mtree/mtree.php:228 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 1.77 ms Utolsó lekérdezés után: 1.10 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 2.698 MB Visszaadott sorok: 1
Duplikált lekérdezések:
#26SELECT *
FROM szakmai2_mt_cats
WHERE `cat_id` = '230'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_mt_cats | const | PRIMARY,cat_id | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.10 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.07 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
Table lock | 0.07 ms |
Init | 0.09 ms |
Optimizing | 0.07 ms |
Statistics | 0.12 ms |
Preparing | 0.06 ms |
Unlocking tables | 0.05 ms |
Preparing | 0.06 ms |
Executing | 0.05 ms |
Sending data | 0.09 ms |
End of update loop | 0.05 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.08 ms |
Updating status | 0.15 ms |
Reset for next command | 0.08 ms |
# | Hívó | Fájl és sorok száma |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
13 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
12 | Joomla\CMS\Table\Table->load() | JROOT/components/com_mtree/mtree.tools.php:999 |
11 | getTopLevelCatID() | JROOT/components/com_mtree/mtree.tools.php:968 |
10 | getAssignedFieldsID() | JROOT/components/com_mtree/mtree.tools.php:93 |
9 | loadFields() | JROOT/components/com_mtree/mtree.tools.php:60 |
8 | loadLink() | JROOT/components/com_mtree/mtree.php:2846 |
7 | printlink() | JROOT/components/com_mtree/mtree.php:228 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 2.70 ms Utolsó lekérdezés után: 0.20 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.697 MB Visszaadott sorok: 32
SELECT cf_id
FROM szakmai2_mt_fields_map
WHERE cat_id = 230
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_mt_fields_map | index | NULL | PRIMARY | 8 | NULL | 2369 | Using where; Using index |
Status | Duration |
---|
Starting | 0.10 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.07 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
Table lock | 0.08 ms |
Init | 0.07 ms |
Optimizing | 0.06 ms |
Statistics | 0.07 ms |
Preparing | 0.10 ms |
Executing | 0.05 ms |
Sending data | 1.12 ms |
End of update loop | 0.07 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.17 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
11 | JDatabaseDriver->loadColumn() | JROOT/components/com_mtree/mtree.tools.php:976 |
10 | getAssignedFieldsID() | JROOT/components/com_mtree/mtree.tools.php:93 |
9 | loadFields() | JROOT/components/com_mtree/mtree.tools.php:60 |
8 | loadLink() | JROOT/components/com_mtree/mtree.php:2846 |
7 | printlink() | JROOT/components/com_mtree/mtree.php:228 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 2.38 ms Utolsó lekérdezés után: 0.27 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.705 MB Visszaadott sorok: 21
SELECT cf_id
FROM szakmai2_mt_customfields
WHERE cf_id IN (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33)
AND published = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_mt_customfields | ref | PRIMARY,published_ordering | published_ordering | 1 | const | 21 | Using where |
Status | Duration |
---|
Starting | 0.14 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.08 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
Table lock | 0.08 ms |
Init | 0.09 ms |
Optimizing | 0.08 ms |
Statistics | 0.17 ms |
Preparing | 0.10 ms |
Executing | 0.05 ms |
Sending data | 0.66 ms |
End of update loop | 0.07 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.15 ms |
Reset for next command | 0.08 ms |
# | Hívó | Fájl és sorok száma |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
11 | JDatabaseDriver->loadColumn() | JROOT/components/com_mtree/mtree.tools.php:982 |
10 | getAssignedFieldsID() | JROOT/components/com_mtree/mtree.tools.php:93 |
9 | loadFields() | JROOT/components/com_mtree/mtree.tools.php:60 |
8 | loadLink() | JROOT/components/com_mtree/mtree.php:2846 |
7 | printlink() | JROOT/components/com_mtree/mtree.php:228 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 2.92 ms Utolsó lekérdezés után: 0.22 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 2.713 MB Visszaadott sorok: 11
SELECT cf.*, cfv.link_id, cfv.value, cfv.attachment, cfv.counter
FROM szakmai2_mt_customfields AS cf
LEFT JOIN szakmai2_mt_cfvalues AS cfv
ON cf.cf_id=cfv.cf_id
AND cfv.link_id = 527
WHERE cf.published = '1'
AND cf.cf_id IN (1,27,2,26,8,5,4,29,9,33,10,11,32,12,14,15,17,18,19,20,21,22) && details_view = '1'
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | cf | ref | PRIMARY,published_ordering | published_ordering | 1 | const | 21 | Using where |
1 | SIMPLE | cfv | ref | cf_id,link_id | cf_id | 8 | belvaros_jozsefvar.cf.cf_id,const | 1 | |
Status | Duration |
---|
Starting | 0.20 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.09 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.13 ms |
Optimizing | 0.10 ms |
Statistics | 0.23 ms |
Preparing | 0.12 ms |
Sorting result | 0.07 ms |
Executing | 0.05 ms |
Sending data | 0.89 ms |
End of update loop | 0.07 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.07 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.06 ms |
Updating status | 0.15 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/components/com_mtree/mtree.tools.php:115 |
9 | loadFields() | JROOT/components/com_mtree/mtree.tools.php:60 |
8 | loadLink() | JROOT/components/com_mtree/mtree.php:2846 |
7 | printlink() | JROOT/components/com_mtree/mtree.php:228 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 1.81 ms Utolsó lekérdezés után: 6.69 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.948 MB Visszaadott sorok: 1
SELECT CONCAT('cust_',cf_id) as varname, value
FROM szakmai2_mt_cfvalues
WHERE link_id = '527'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_mt_cfvalues | ref | link_id | link_id | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.14 ms |
Checking permissions | 0.11 ms |
Opening tables | 0.08 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.08 ms |
Optimizing | 0.06 ms |
Statistics | 0.10 ms |
Preparing | 0.09 ms |
Executing | 0.05 ms |
Sending data | 0.13 ms |
End of update loop | 0.06 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.07 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.16 ms |
Reset for next command | 0.08 ms |
# | Hívó | Fájl és sorok száma |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
9 | JDatabaseDriver->loadObjectList() | JROOT/components/com_mtree/mtree.tools.php:64 |
8 | loadLink() | JROOT/components/com_mtree/mtree.php:2846 |
7 | printlink() | JROOT/components/com_mtree/mtree.php:228 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 2.08 ms Utolsó lekérdezés után: 0.66 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.956 MB Visszaadott sorok: 8
SELECT img_id AS id, filename
FROM szakmai2_mt_images
WHERE link_id = '527'
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_mt_images | ref | link_id_ordering | link_id_ordering | 4 | const | 8 | Using where |
Status | Duration |
---|
Starting | 0.12 ms |
Checking permissions | 0.07 ms |
Opening tables | 0.07 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.07 ms |
Optimizing | 0.06 ms |
Statistics | 0.17 ms |
Preparing | 0.10 ms |
Sorting result | 0.06 ms |
Executing | 0.05 ms |
Sending data | 0.28 ms |
End of update loop | 0.06 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.20 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
8 | JDatabaseDriver->loadObjectList() | JROOT/components/com_mtree/mtree.php:2867 |
7 | printlink() | JROOT/components/com_mtree/mtree.php:228 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 1.82 ms Utolsó lekérdezés után: 0.45 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.973 MB Visszaadott sorok: 1
Duplikált lekérdezések:
#20SELECT *
FROM szakmai2_mt_cats
WHERE `cat_id` = '230'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_mt_cats | const | PRIMARY,cat_id | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.10 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.10 ms |
After opening tables | 0.06 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.08 ms |
Optimizing | 0.07 ms |
Statistics | 0.12 ms |
Preparing | 0.06 ms |
Unlocking tables | 0.05 ms |
Preparing | 0.06 ms |
Executing | 0.05 ms |
Sending data | 0.10 ms |
End of update loop | 0.05 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.09 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.15 ms |
Reset for next command | 0.08 ms |
# | Hívó | Fájl és sorok száma |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
10 | Joomla\CMS\Table\Table->load() | JROOT/components/com_mtree/mtree.tools.php:999 |
9 | getTopLevelCatID() | JROOT/components/com_mtree/mtree.tools.php:173 |
8 | assignCommonViewlinkVar() | JROOT/components/com_mtree/mtree.php:2874 |
7 | printlink() | JROOT/components/com_mtree/mtree.php:228 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 1.81 ms Utolsó lekérdezés után: 0.19 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.972 MB Visszaadott sorok: 1
SELECT *
FROM szakmai2_mt_cats
WHERE cat_id = 230
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_mt_cats | const | PRIMARY,cat_id | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.10 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.09 ms |
After opening tables | 0.06 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.08 ms |
Optimizing | 0.07 ms |
Statistics | 0.11 ms |
Preparing | 0.06 ms |
Unlocking tables | 0.05 ms |
Preparing | 0.06 ms |
Executing | 0.05 ms |
Sending data | 0.09 ms |
End of update loop | 0.05 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.11 ms |
Closing tables | 0.07 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.14 ms |
Reset for next command | 0.08 ms |
# | Hívó | Fájl és sorok száma |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
9 | JDatabaseDriver->loadObject() | JROOT/components/com_mtree/mtree.tools.php:175 |
8 | assignCommonViewlinkVar() | JROOT/components/com_mtree/mtree.php:2874 |
7 | printlink() | JROOT/components/com_mtree/mtree.php:228 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 1.51 ms Utolsó lekérdezés után: 0.18 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.979 MB Visszaadott sorok: 1
SELECT COUNT(*)
FROM szakmai2_mt_favourites
WHERE link_id = '527'
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.11 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.11 ms |
After opening tables | 0.06 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.07 ms |
Optimizing | 0.06 ms |
Statistics | 0.07 ms |
Preparing | 0.05 ms |
Executing | 0.06 ms |
End of update loop | 0.05 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.17 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
9 | JDatabaseDriver->loadResult() | JROOT/components/com_mtree/mtree.tools.php:205 |
8 | assignCommonViewlinkVar() | JROOT/components/com_mtree/mtree.php:2874 |
7 | printlink() | JROOT/components/com_mtree/mtree.php:228 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 1.60 ms Utolsó lekérdezés után: 0.15 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.984 MB Visszaadott sorok: 1
SELECT COUNT(*)
FROM szakmai2_mt_images
WHERE link_id = '527'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_mt_images | ref | link_id_ordering | link_id_ordering | 4 | const | 8 | Using index |
Status | Duration |
---|
Starting | 0.10 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.07 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.07 ms |
Optimizing | 0.06 ms |
Statistics | 0.13 ms |
Preparing | 0.10 ms |
Executing | 0.05 ms |
Sending data | 0.08 ms |
End of update loop | 0.06 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.05 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.15 ms |
Reset for next command | 0.08 ms |
# | Hívó | Fájl és sorok száma |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
9 | JDatabaseDriver->loadResult() | JROOT/components/com_mtree/mtree.tools.php:219 |
8 | assignCommonViewlinkVar() | JROOT/components/com_mtree/mtree.php:2874 |
7 | printlink() | JROOT/components/com_mtree/mtree.php:228 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 4.29 ms Utolsó lekérdezés után: 6.68 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 3.131 MB Visszaadott sorok: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM szakmai2_fields AS a
LEFT JOIN `szakmai2_languages` AS l
ON l.lang_code = a.language
LEFT JOIN szakmai2_users AS uc
ON uc.id=a.checked_out
LEFT JOIN szakmai2_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN szakmai2_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN szakmai2_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_mtree.listing'
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Fájlrendezés használata |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | belvaros_jozsefvar.a.language | 1 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | belvaros_jozsefvar.a.checked_out | 1 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | belvaros_jozsefvar.a.access | 1 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | belvaros_jozsefvar.a.created_user_id | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | belvaros_jozsefvar.a.group_id | 1 | Using where |
Status | Duration |
---|
Starting | 0.34 ms |
Checking permissions | 0.07 ms |
Opening tables | 0.17 ms |
After opening tables | 0.07 ms |
System lock | 0.06 ms |
Table lock | 0.05 ms |
Init | 0.15 ms |
Optimizing | 0.12 ms |
Statistics | 0.32 ms |
Preparing | 0.20 ms |
Creating tmp table | 0.26 ms |
Sorting result | 0.10 ms |
Executing | 0.05 ms |
Sending data | 0.97 ms |
Creating sort index | 0.15 ms |
Removing tmp table | 0.26 ms |
Creating sort index | 0.12 ms |
End of update loop | 0.07 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.07 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.06 ms |
Updating status | 0.15 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
15 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
14 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
13 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:404 |
12 | PlgSystemFields->display() | JROOT/plugins/system/fields/fields.php:324 |
11 | PlgSystemFields->onContentAfterTitle() | JROOT/libraries/joomla/event/event.php:70 |
10 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
9 | JEventDispatcher->trigger() | JROOT/components/com_mtree/mtree.tools.php:289 |
8 | assignCommonViewlinkVar() | JROOT/components/com_mtree/mtree.php:2874 |
7 | printlink() | JROOT/components/com_mtree/mtree.php:228 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 1.85 ms Utolsó lekérdezés után: 10.23 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.311 MB Visszaadott sorok: 1
SELECT params
FROM szakmai2_mt_templates
WHERE tem_name = 'kinabalu'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_mt_templates | const | tem_name | tem_name | 767 | const | 1 | |
Status | Duration |
---|
Starting | 0.14 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.08 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.08 ms |
Optimizing | 0.07 ms |
Statistics | 0.14 ms |
Preparing | 0.09 ms |
Unlocking tables | 0.06 ms |
Preparing | 0.07 ms |
Executing | 0.05 ms |
Sending data | 0.06 ms |
End of update loop | 0.05 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.18 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
13 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_mtree/config.mtree.class.php:204 |
12 | mtConfig->getTemParam() | JROOT/components/com_mtree/templates/kinabalu/sub_images.tpl.php:4 |
11 | include JROOT/components/com_mtree/templates/kinabalu/sub_images.tpl.php | JROOT/components/com_mtree/templates/kinabalu/page_print.tpl.php:15 |
10 | include JROOT/components/com_mtree/templates/kinabalu/page_print.tpl.php | JROOT/components/com_mtree/Savant2.php:970 |
9 | Savant2->fetch() | JROOT/components/com_mtree/Savant2.php:999 |
8 | Savant2->display() | JROOT/components/com_mtree/mtree.php:2877 |
7 | printlink() | JROOT/components/com_mtree/mtree.php:228 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 1.81 ms Utolsó lekérdezés után: 10.12 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 3.239 MB Visszaadott sorok: 0
SELECT `pageid`
FROM szakmai2_sh404sef_pageids
WHERE `newurl`='index.php?option=com_mtree&Itemid=&lang=hu&link_id=527&task=print&tmpl=component';
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_sh404sef_pageids | ref | newurl | newurl | 767 | const | 1 | Using index condition |
Status | Duration |
---|
Starting | 0.12 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.08 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.08 ms |
Optimizing | 0.06 ms |
Statistics | 0.17 ms |
Preparing | 0.13 ms |
Executing | 0.06 ms |
Sending data | 0.09 ms |
End of update loop | 0.06 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.17 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
12 | JDatabaseDriver->loadResult() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:716 |
11 | ShlDbClass->loadResult() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:364 |
10 | ShlDbClass->shlLoadResult() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483 |
9 | ShlDbHelper::selectResult() | JROOT/administrator/components/com_sh404sef/helpers/shurl.php:51 |
8 | Sh404sefHelperShurl::updateShurls() | JROOT/plugins/system/sh404sef/sh404sef.php:172 |
7 | plgSystemSh404sef->onAfterDispatch() | 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/SiteApplication.php:199 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 1.99 ms Utolsó lekérdezés után: 2.68 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.257 MB Visszaadott sorok: 0
SELECT *
FROM szakmai2_jmap_metainfo
WHERE `linkurl` = 'https://www.jozsefvarosi.info/index.php'
AND `published` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_jmap_metainfo | ref | published | published | 1 | const | 1 | Using where |
Status | Duration |
---|
Starting | 0.12 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.11 ms |
After opening tables | 0.06 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.09 ms |
Optimizing | 0.09 ms |
Statistics | 0.13 ms |
Preparing | 0.10 ms |
Executing | 0.06 ms |
Sending data | 0.14 ms |
End of update loop | 0.07 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.08 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.09 ms |
Starting cleanup | 0.06 ms |
Freeing items | 0.05 ms |
Updating status | 0.16 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jmap/jmap.php:408 |
12 | plgSystemJMap->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 |
8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 |
7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 1.72 ms Utolsó lekérdezés után: 0.17 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 3.264 MB Visszaadott sorok: 0
SELECT *
FROM szakmai2_jmap_canonicals
WHERE `linkurl` = 'https://www.jozsefvarosi.info/index.php'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_jmap_canonicals | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 1 | Using where |
Status | Duration |
---|
Starting | 0.11 ms |
Checking permissions | 0.09 ms |
Opening tables | 0.08 ms |
After opening tables | 0.06 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.08 ms |
Optimizing | 0.06 ms |
Statistics | 0.08 ms |
Preparing | 0.07 ms |
Executing | 0.05 ms |
Sending data | 0.14 ms |
End of update loop | 0.07 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.09 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.15 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jmap/jmap.php:486 |
12 | plgSystemJMap->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 |
8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 |
7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 1.73 ms Utolsó lekérdezés után: 3.07 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 3.292 MB Visszaadott sorok: 0
SELECT *
FROM szakmai2_jmap_headings
WHERE `linkurl` = 'https://www.jozsefvarosi.info/index.php'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | szakmai2_jmap_headings | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 1 | Using where |
Status | Duration |
---|
Starting | 0.11 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.08 ms |
After opening tables | 0.05 ms |
System lock | 0.08 ms |
Table lock | 0.06 ms |
Init | 0.08 ms |
Optimizing | 0.06 ms |
Statistics | 0.07 ms |
Preparing | 0.07 ms |
Executing | 0.05 ms |
Sending data | 0.14 ms |
End of update loop | 0.07 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.17 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
8 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jmap/jmap.php:747 |
7 | plgSystemJMap->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 3.77 ms Utolsó lekérdezés után: 2.59 ms Memória lekérdezése: 0.033 MB memória a lekérdezés előtt: 3.318 MB Visszaadott sorok: 36
SHOW FULL COLUMNS
FROM `szakmai2_sh404sef_metas`
Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `szakmai2_sh404sef_metas`
Status | Duration |
---|
Starting | 0.15 ms |
Checking permissions | 0.07 ms |
Closing tables | 0.05 ms |
Opening tables | 0.72 ms |
After opening tables | 0.10 ms |
System lock | 0.05 ms |
Table lock | 0.05 ms |
Init | 0.06 ms |
Optimizing | 0.06 ms |
Statistics | 0.06 ms |
Preparing | 0.07 ms |
Executing | 0.05 ms |
Filling schema table | 0.06 ms |
Opening tables | 0.08 ms |
After opening tables | 0.06 ms |
Checking permissions | 0.46 ms |
Closing tables | 0.09 ms |
Executing | 0.05 ms |
Sending data | 0.20 ms |
End of update loop | 0.06 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Removing tmp table | 0.29 ms |
Closing tables | 0.09 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.05 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.05 ms |
Updating status | 0.16 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
16 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
15 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
14 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_sh404sef/tables/metas.php:127 |
13 | Sh404sefTableMetas->__construct() | JROOT/libraries/src/Table/Table.php:328 |
12 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_sh404sef/shPageRewrite.full.php:257 |
11 | shGetCustomMetaData() | JROOT/components/com_sh404sef/shPageRewrite.full.php:334 |
10 | shDoTitleTags() | JROOT/components/com_sh404sef/shPageRewrite.full.php:1175 |
9 | include_once JROOT/components/com_sh404sef/shPageRewrite.full.php | JROOT/components/com_sh404sef/shPageRewrite.php:15 |
8 | require_once JROOT/components/com_sh404sef/shPageRewrite.php | JROOT/plugins/system/sh404sef/sh404sef.php:246 |
7 | plgSystemSh404sef->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Lekérdezés ideje: 1.86 ms Utolsó lekérdezés után: 0.98 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.362 MB Visszaadott sorok: 0
SELECT *
FROM szakmai2_sh404sef_metas
WHERE `newurl`='index.php?option=com_mtree&Itemid=&lang=hu&link_id=527&task=print&tmpl=component';
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.11 ms |
Checking permissions | 0.06 ms |
Opening tables | 0.08 ms |
After opening tables | 0.09 ms |
System lock | 0.06 ms |
Table lock | 0.05 ms |
Init | 0.10 ms |
Optimizing | 0.07 ms |
Statistics | 0.12 ms |
Preparing | 0.06 ms |
Unlocking tables | 0.05 ms |
Preparing | 0.05 ms |
Executing | 0.09 ms |
End of update loop | 0.05 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.10 ms |
Starting cleanup | 0.06 ms |
Freeing items | 0.05 ms |
Updating status | 0.15 ms |
Reset for next command | 0.09 ms |
# | Hívó | Fájl és sorok száma |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
15 | JDatabaseDriver->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:657 |
14 | ShlDbClass->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:452 |
13 | ShlDbClass->shlLoadObject() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655 |
12 | ShlDbHelper::selectObject() | JROOT/components/com_sh404sef/shPageRewrite.full.php:261 |
11 | shGetCustomMetaData() | JROOT/components/com_sh404sef/shPageRewrite.full.php:334 |
10 | shDoTitleTags() | JROOT/components/com_sh404sef/shPageRewrite.full.php:1175 |
9 | include_once JROOT/components/com_sh404sef/shPageRewrite.full.php | JROOT/components/com_sh404sef/shPageRewrite.php:15 |
8 | require_once JROOT/components/com_sh404sef/shPageRewrite.php | JROOT/plugins/system/sh404sef/sh404sef.php:246 |
7 | plgSystemSh404sef->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
3 × SELECT *
FROM szakmai2_mt_cats
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `szakmai2_extensions`
1 × SELECT `data`
FROM `szakmai2_session`
1 × SELECT *
FROM szakmai2_jmap_headings
1 × SELECT *
FROM szakmai2_jmap_canonicals
1 × SELECT *
FROM szakmai2_jmap_metainfo
1 × SELECT `pageid`
FROM szakmai2_sh404sef_pageids
1 × SELECT params
FROM szakmai2_mt_templates
1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM szakmai2_fields AS a
LEFT JOIN `szakmai2_languages` AS l
ON l.lang_code = a.language
LEFT JOIN szakmai2_users AS uc
ON uc.id=a.checked_out
LEFT JOIN szakmai2_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN szakmai2_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN szakmai2_fields_groups AS g
ON g.id = a.group_id
1 × SELECT COUNT(*)
FROM szakmai2_mt_images
1 × SELECT COUNT(*)
FROM szakmai2_mt_favourites
1 × SELECT img_id AS id, filename
FROM szakmai2_mt_images
1 × SELECT CONCAT('cust_',cf_id) as varname, value
FROM szakmai2_mt_cfvalues
1 × SELECT cf.*, cfv.link_id, cfv.value, cfv.attachment, cfv.counter
FROM szakmai2_mt_customfields AS cf
LEFT JOIN szakmai2_mt_cfvalues AS cfv
ON cf.cf_id=cfv.cf_id
AND cfv.link_id = 527
1 × SELECT cf_id
FROM szakmai2_mt_customfields
1 × SELECT cf_id
FROM szakmai2_mt_fields_map
1 × SELECT cat_template
FROM szakmai2_mt_cats
1 × SELECT cat_id, cat_parent, metadata, lft, rgt
FROM szakmai2_mt_cats
1 × SELECT l.*, tlcat.cat_id AS tlcat_id, tlcat.cat_name AS tlcat_name, u.username AS username, u.name AS owner, u.email AS owner_email, cl.cat_id AS cat_id, c.cat_name AS cat_name, c.cat_association, img.filename AS link_image, img.img_id
FROM (szakmai2_mt_links AS l, szakmai2_mt_cl AS cl)
LEFT JOIN szakmai2_users AS u
ON u.id = l.user_id
LEFT JOIN szakmai2_mt_cats AS c
ON c.cat_id = cl.cat_id
LEFT JOIN szakmai2_mt_cats AS tlcat
ON tlcat.lft <= c.lft
AND tlcat.rgt >= c.rgt
AND tlcat.cat_parent =0
LEFT JOIN szakmai2_mt_images AS img
ON img.link_id = l.link_id
AND img.ordering = 1
1 × SELECT id, home, template, s.params
FROM szakmai2_template_styles as s
LEFT JOIN szakmai2_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT params
FROM szakmai2_extensions
1 × select `alias`,`newurl`
from `szakmai2_sh404sef_aliases`
1 × SELECT `varname`, `value`, `default`
FROM szakmai2_mt_confi
1 × SELECT `params`
FROM szakmai2_extensions
1 × 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 szakmai2_menu AS m
LEFT JOIN szakmai2_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM szakmai2_languages
1 × SELECT `template`
FROM `szakmai2_template_styles`
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM szakmai2_extensions
1 × SELECT b.id
FROM szakmai2_usergroups AS a
LEFT JOIN szakmai2_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `szakmai2_viewlevels
1 × SELECT *
FROM szakmai2_sh404sef_metas