Čo robíme pre...
Aktuálne pozývame na...
Tešíme sa na vás v nedeľu
Bohoslužby môžete sledovať YouTube kanálu CB Levice.
v nedeľu o 9:30 hod na Sama Chalupku 7 v Leviciach alebo na niektorej z našich aktivít.Tešíme sa, že ste nás navštívili virtuálne – osobná návšteva je ešte lepšia.
Láska k Bohu, láska k ľuďom a služba svetu je to, pre čo žijeme a kam smerujeme.
Ladiaca konzola systému Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1675726528,
"last": 1675726528,
"now": 1675726528
},
"client": {
"forwarded": "3.237.29.69"
},
"token": "hmpt4O3odC3LmZ4CRVBQNrHc9Padav29"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Čas
Pamäť
Čas: 4.79 ms / 4.79 ms Pamäť: 0.398 MB / 0.74 MB Application: afterLoad
Čas: 141.84 ms / 146.63 ms Pamäť: 1.431 MB / 2.18 MB Application: afterInitialise
Čas: 40.24 ms / 186.87 ms Pamäť: 0.676 MB / 2.85 MB Application: afterRoute
Čas: 5.65 ms / 192.52 ms Pamäť: 0.115 MB / 2.97 MB Application: beforeRenderComponent com_content
Čas: 3.27 ms / 195.79 ms Pamäť: 0.051 MB / 3.02 MB Application: Before Access::preloadComponents (all components)
Čas: 5.36 ms / 201.15 ms Pamäť: 0.059 MB / 3.07 MB Application: After Access::preloadComponents (all components)
Čas: 0.07 ms / 201.22 ms Pamäť: -0.003 MB / 3.07 MB Application: Before Access::preloadPermissions (com_content)
Čas: 2.35 ms / 203.57 ms Pamäť: 0.183 MB / 3.26 MB Application: After Access::preloadPermissions (com_content)
Čas: 0.06 ms / 203.63 ms Pamäť: -0.011 MB / 3.25 MB Application: Before Access::getAssetRules (id:236 name:com_content.article.59)
Čas: 0.52 ms / 204.15 ms Pamäť: 0.010 MB / 3.25 MB Application: After Access::getAssetRules (id:236 name:com_content.article.59)
Čas: 33.76 ms / 237.92 ms Pamäť: 0.349 MB / 3.60 MB Application: afterRenderComponent com_content
Čas: 2.55 ms / 240.46 ms Pamäť: 0.015 MB / 3.62 MB Application: afterDispatch
Čas: 264.66 ms / 505.12 ms Pamäť: 2.090 MB / 5.71 MB Application: afterRender
Celkový počet dotazov na databázu: 71.04 ms
6,05 MB (6 343 128 Bytov)
Zaznamenané dotazy: 32 71.04 ms
- Čas dotazu: 1.09 ms Pamäť pre dotazy: 0.023 MB pamäť pred dotazom: 1.036 MB Vrátené riadky: 0
SELECT `data`
FROM `xtldo_session`
WHERE `session_id` = X'3866306164386332303238633563373466636638306361626630396664353230'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xtldo_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.41 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms executing 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Rovnaké, ako volanie o riadok nižšie. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:854 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:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Čas dotazu: 0.69 ms Po ostatnom dotaze: 0.47 ms Pamäť pre dotazy: 0.020 MB pamäť pred dotazom: 1.051 MB Vrátené riadky: 0
SELECT `session_id`
FROM `xtldo_session`
WHERE `session_id` = X'3866306164386332303238633563373466636638306361626630396664353230'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xtldo_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:856 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:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Čas dotazu: 0.81 ms Po ostatnom dotaze: 0.33 ms Pamäť pre dotazy: 0.004 MB pamäť pred dotazom: 1.056 MB
INSERT INTO `xtldo_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3866306164386332303238633563373466636638306361626630396664353230', 1, 1675726528, 0, '', 0)Nie je možné VYSVETLENIE na dotaz: INSERT INTO `xtldo_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3866306164386332303238633563373466636638306361626630396664353230', 1, 1675726528, 0, '', 0)Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms update 0.12 ms Waiting for query cache lock 0.01 ms update 0.01 ms end 0.00 ms query end 0.08 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:856 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:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Čas dotazu: 1.80 ms Po ostatnom dotaze: 1.13 ms Pamäť pre dotazy: 0.040 MB pamäť pred dotazom: 1.087 MB Vrátené riadky: 42
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `xtldo_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xtldo_extensions NULL ref extension extension 82 const 43 1.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.34 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.00 ms Sending data 0.38 ms end 0.01 ms query end 0.01 ms closing tables 0.06 ms freeing items 0.08 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 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}() Rovnaké, ako volanie o riadok nižšie. 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 - Čas dotazu: 0.93 ms Po ostatnom dotaze: 0.86 ms Pamäť pre dotazy: 0.021 MB pamäť pred dotazom: 1.129 MB Vrátené riadky: 5
SELECT id, rules
FROM `xtldo_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xtldo_viewlevels NULL ALL NULL NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX NULL NULL 5 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.33 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.06 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 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 - Čas dotazu: 1.19 ms Po ostatnom dotaze: 0.11 ms Pamäť pre dotazy: 0.021 MB pamäť pred dotazom: 1.141 MB Vrátené riadky: 2
SELECT b.id
FROM xtldo_usergroups AS a
LEFT JOIN xtldo_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.40 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 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 - Čas dotazu: 2.07 ms Po ostatnom dotaze: 0.35 ms Pamäť pre dotazy: 0.030 MB pamäť pred dotazom: 1.162 MB Vrátené riadky: 97
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM xtldo_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xtldo_extensions NULL ref extension extension 82 const 131 0.60 Using index condition; Using where; Pomocou filesort Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 1.24 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 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}() Rovnaké, ako volanie o riadok nižšie. 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 - Čas dotazu: 1.23 ms Po ostatnom dotaze: 12.75 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 1.586 MB Vrátené riadky: 1Duplicitné dotazy: #9
SELECT template
FROM xtldo_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ALL idx_client_id,idx_client_id_home NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX NULL NULL 20 9.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.38 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 ms Sending data 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 12 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 11 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 10 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 9 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:95 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:53 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 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 - Čas dotazu: 0.67 ms Po ostatnom dotaze: 0.17 ms Pamäť pre dotazy: 0.023 MB pamäť pred dotazom: 1.594 MB Vrátené riadky: 1Duplicitné dotazy: #8
SELECT template
FROM xtldo_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ALL idx_client_id,idx_client_id_home NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX NULL NULL 20 9.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.00 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 13 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 12 RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 11 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 10 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 9 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:95 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:53 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 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 - Čas dotazu: 0.97 ms Po ostatnom dotaze: 1.80 ms Pamäť pre dotazy: 0.021 MB pamäť pred dotazom: 1.772 MB Vrátené riadky: 4
SELECT extension, file, type
FROM xtldo_rokcommon_configs
ORDER BY priorityid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xtldo_rokcommon_configs NULL ALL NULL NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX NULL NULL 4 100.00 Pomocou filesort Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.29 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rokcommon/rokcommon.php:131 8 plgSystemRokCommon->processRegisteredConfigs() JROOT/plugins/system/rokcommon/rokcommon.php:75 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 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 - Čas dotazu: 1.41 ms Po ostatnom dotaze: 17.49 ms Pamäť pre dotazy: 0.026 MB pamäť pred dotazom: 1.951 MB Vrátené riadky: 18
SHOW FULL COLUMNS
FROM `xtldo_extensions`Nie je možné VYSVETLENIE na dotaz: SHOW FULL COLUMNS FROM `xtldo_extensions`Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.25 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.04 ms Opening tables 0.02 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms Sending data 0.13 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.06 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:253 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 11 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Extension.php:32 10 Joomla\CMS\Table\Extension->__construct() JROOT/libraries/src/Table/Table.php:320 9 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/system/roksprocket/roksprocket.php:45 8 plgSystemRokSprocket->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:696 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 - Čas dotazu: 0.75 ms Po ostatnom dotaze: 0.63 ms Pamäť pre dotazy: 0.021 MB pamäť pred dotazom: 1.980 MB Vrátené riadky: 1
SELECT `extension_id`
FROM `xtldo_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xtldo_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.02 ms executing 0.00 ms Sending data 0.05 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 9 Joomla\CMS\Table\Extension->find() JROOT/plugins/system/roksprocket/roksprocket.php:47 8 plgSystemRokSprocket->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:696 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 - Čas dotazu: 0.69 ms Po ostatnom dotaze: 0.18 ms Pamäť pre dotazy: 0.021 MB pamäť pred dotazom: 1.986 MB Vrátené riadky: 1Duplicitné dotazy: #15
SELECT *
FROM xtldo_extensions
WHERE `extension_id` = '10012'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xtldo_extensions NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 9 Joomla\CMS\Table\Table->load() JROOT/plugins/system/roksprocket/roksprocket.php:54 8 plgSystemRokSprocket->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:696 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 - Čas dotazu: 0.64 ms Po ostatnom dotaze: 0.14 ms Pamäť pre dotazy: 0.021 MB pamäť pred dotazom: 1.990 MB Vrátené riadky: 1
SELECT `extension_id`
FROM `xtldo_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xtldo_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.02 ms executing 0.00 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 9 Joomla\CMS\Table\Extension->find() JROOT/plugins/system/roksprocket/roksprocket.php:70 8 plgSystemRokSprocket->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:696 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 - Čas dotazu: 0.56 ms Po ostatnom dotaze: 0.11 ms Pamäť pre dotazy: 0.021 MB pamäť pred dotazom: 1.996 MB Vrátené riadky: 1Duplicitné dotazy: #13
SELECT *
FROM xtldo_extensions
WHERE `extension_id` = '10012'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xtldo_extensions NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 9 Joomla\CMS\Table\Table->load() JROOT/plugins/system/roksprocket/roksprocket.php:76 8 plgSystemRokSprocket->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:696 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 - Čas dotazu: 3.26 ms Po ostatnom dotaze: 76.26 ms Pamäť pre dotazy: 0.076 MB pamäť pred dotazom: 2.203 MB Vrátené riadky: 57
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 xtldo_menu AS m
LEFT JOIN xtldo_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_client_id_parent_id_alias_language NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX NULL NULL 141 5.82 Using where; Pomocou filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 db13483xjom36.m.component_id 1 100.00 Using where Status Duration starting 0.15 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.53 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 1.31 ms end 0.01 ms query end 0.01 ms closing tables 0.07 ms freeing items 0.12 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Rovnaké, ako volanie o riadok nižšie. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:445 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:561 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1169 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 - Čas dotazu: 1.28 ms Po ostatnom dotaze: 10.25 ms Pamäť pre dotazy: 0.023 MB pamäť pred dotazom: 2.545 MB Vrátené riadky: 18
SELECT id, home, template, s.params
FROM xtldo_template_styles as s
LEFT JOIN xtldo_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 5 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 db13483xjom36.e.element 4 90.00 Using index condition; Using where Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.03 ms executing 0.00 ms Sending data 0.31 ms end 0.01 ms query end 0.01 ms closing tables 0.06 ms freeing items 0.09 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/gantry5/gantry5.php:257 9 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:108 8 plgSystemGantry5->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:1218 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 - Čas dotazu: 1.11 ms Po ostatnom dotaze: 13.15 ms Pamäť pre dotazy: 0.024 MB pamäť pred dotazom: 2.826 MB Vrátené riadky: 16
SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM xtldo_template_styles AS s
WHERE s.client_id = 0
AND s.template = 'rt_ethereal'
ORDER BY s.idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL index idx_template,idx_client_id,idx_client_id_home PRIMARY 4 NULL 20 72.00 Using where Status Duration starting 0.18 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.14 ms end 0.01 ms query end 0.01 ms closing tables 0.05 ms freeing items 0.07 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69 14 Gantry\Joomla\StyleHelper::loadStyles() JROOT/libraries/gantry5/src/classes/Gantry/Framework/Assignments.php:63 13 Gantry\Framework\Assignments->loadAssignments() JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:301 12 Gantry\Component\Assignments\AbstractAssignments->init() JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:99 11 Gantry\Component\Assignments\AbstractAssignments->scores() JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:86 10 Gantry\Component\Assignments\AbstractAssignments->select() JROOT/plugins/system/gantry5/gantry5.php:315 9 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:108 8 plgSystemGantry5->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:1218 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 - Čas dotazu: 1.10 ms Po ostatnom dotaze: 8.84 ms Pamäť pre dotazy: 0.024 MB pamäť pred dotazom: 2.862 MB Vrátené riadky: 8
SELECT *
FROM xtldo_rokcandy
WHERE published=1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xtldo_rokcandy NULL ALL NULL NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX NULL NULL 8 12.50 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.31 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.11 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.07 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27 13 RokCandyHelper::getUserMacros() Rovnaké, ako volanie o riadok nižšie. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 10 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17 9 RokCandyHelper::getMacros() JROOT/plugins/system/rokcandy/rokcandy.php:28 8 plgSystemRokCandy->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:1218 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 - Čas dotazu: 0.93 ms Po ostatnom dotaze: 0.82 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 2.873 MB Vrátené riadky: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `xtldo_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xtldo_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.17 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.02 ms executing 0.00 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.07 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Rovnaké, ako volanie o riadok nižšie. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1131 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas dotazu: 1.04 ms Po ostatnom dotaze: 0.36 ms Pamäť pre dotazy: 0.005 MB pamäť pred dotazom: 2.863 MB
UPDATE `xtldo_extensions`
SET `params` = '{\"mediaversion\":\"a848fbafd2f0aa729832b28241532f92\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE xtldo_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.10 ms updating 0.12 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.10 ms closing tables 0.18 ms freeing items 0.09 ms cleaning up 0.02 ms # Volacia funkcia Súbor a číslo riadku 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1131 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas dotazu: 1.52 ms Po ostatnom dotaze: 0.96 ms Pamäť pre dotazy: 0.019 MB pamäť pred dotazom: 2.955 MB Vrátené riadky: 1
SELECT *
FROM xtldo_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xtldo_languages NULL ALL NULL NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX NULL NULL 1 100.00 Using where; Pomocou filesort Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.60 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.03 ms Creating sort index 0.13 ms end 0.01 ms query end 0.01 ms closing tables 0.16 ms freeing items 0.06 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas dotazu: 4.97 ms Po ostatnom dotaze: 3.92 ms Pamäť pre dotazy: 0.028 MB pamäť pred dotazom: 3.021 MB Vrátené riadky: 42
SELECT `id`,`name`,`rules`,`parent_id`
FROM `xtldo_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_extplorer','com_fields','com_finder','com_gantry5','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_rokcandy','com_rokgallery','com_roksprocket','com_search','com_sermonspeaker','com_tags','com_templates','com_users','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xtldo_assets NULL ALL idx_asset_name NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX NULL NULL 367 11.72 Using where Status Duration starting 0.12 ms checking permissions 0.01 ms Opening tables 1.69 ms init 0.09 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.26 ms preparing 0.02 ms executing 0.00 ms Sending data 2.21 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.08 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas dotazu: 1.84 ms Po ostatnom dotaze: 0.40 ms Pamäť pre dotazy: 0.044 MB pamäť pred dotazom: 3.073 MB Vrátené riadky: 215
SELECT `id`,`name`,`rules`,`parent_id`
FROM `xtldo_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xtldo_assets NULL ALL idx_asset_name,idx_parent_id NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX NULL NULL 367 24.21 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.02 ms executing 0.02 ms Sending data 1.12 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.07 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas dotazu: 3.39 ms Po ostatnom dotaze: 1.42 ms Pamäť pre dotazy: 0.031 MB pamäť pred dotazom: 3.258 MB Vrátené riadky: 31
SHOW FULL COLUMNS
FROM `xtldo_content`Nie je možné VYSVETLENIE na dotaz: SHOW FULL COLUMNS FROM `xtldo_content`Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.26 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.02 ms Opening tables 1.63 ms checking permissions 0.23 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.03 ms Sending data 0.24 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.08 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:253 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:320 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas dotazu: 0.79 ms Po ostatnom dotaze: 1.68 ms Pamäť pre dotazy: 0.005 MB pamäť pred dotazom: 3.319 MB
UPDATE xtldo_content
SET `hits` = (`hits` + 1)
WHERE `id` = '59'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE xtldo_content NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.06 ms updating 0.11 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.08 ms closing tables 0.04 ms freeing items 0.11 ms cleaning up 0.02 ms # Volacia funkcia Súbor a číslo riadku 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1256 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas dotazu: 4.78 ms Po ostatnom dotaze: 0.96 ms Pamäť pre dotazy: 0.023 MB pamäť pred dotazom: 3.406 MB Vrátené riadky: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM xtldo_content AS a
INNER JOIN xtldo_categories AS c
on c.id = a.catid
LEFT JOIN xtldo_users AS u
on u.id = a.created_by
LEFT JOIN xtldo_categories as parent
ON parent.id = c.parent_id
LEFT JOIN xtldo_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 59
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-02-06 23:35:28')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-02-06 23:35:28')
AND (a.state = 1 OR a.state =2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.29 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 3.37 ms init 0.13 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.20 ms preparing 0.05 ms executing 0.00 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.10 ms freeing items 0.09 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas dotazu: 3.00 ms Po ostatnom dotaze: 1.54 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 3.453 MB Vrátené riadky: 0
SELECT `m`.`tag_id`,`t`.*
FROM `xtldo_contentitem_tag_map` AS m
INNER JOIN `xtldo_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 59
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX NULL NULL 6 16.67 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 db13483xjom36.m.tag_id 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 2.06 ms init 0.11 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.04 ms executing 0.01 ms Sending data 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.05 ms freeing items 0.07 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas dotazu: 1.34 ms Po ostatnom dotaze: 3.16 ms Pamäť pre dotazy: 0.026 MB pamäť pred dotazom: 3.509 MB Vrátené riadky: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `xtldo_categories` AS `s`
INNER JOIN `xtldo_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 2
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 2 54.55 Using index condition; Using where Status Duration starting 0.21 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.09 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.20 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.14 ms end 0.01 ms query end 0.01 ms closing tables 0.08 ms freeing items 0.08 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:135 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:189 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas dotazu: 7.25 ms Po ostatnom dotaze: 0.43 ms Pamäť pre dotazy: 0.025 MB pamäť pred dotazom: 3.592 MB Vrátené riadky: 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 xtldo_fields AS a
LEFT JOIN `xtldo_languages` AS l
ON l.lang_code = a.language
LEFT JOIN xtldo_users AS uc
ON uc.id=a.checked_out
LEFT JOIN xtldo_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN xtldo_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN xtldo_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `xtldo_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (2,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; Pomocou filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 db13483xjom36.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 db13483xjom36.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 db13483xjom36.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 db13483xjom36.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 db13483xjom36.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 db13483xjom36.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.27 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 5.08 ms init 0.14 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.28 ms preparing 0.07 ms Creating tmp table 0.09 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.34 ms Creating sort index 0.10 ms end 0.01 ms query end 0.01 ms removing tmp table 0.07 ms query end 0.01 ms closing tables 0.09 ms freeing items 0.10 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:189 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas dotazu: 1.12 ms Po ostatnom dotaze: 35.20 ms Pamäť pre dotazy: 0.035 MB pamäť pred dotazom: 4.553 MB Vrátené riadky: 2
SELECT `a`.`menutype`,`a`.`title`
FROM `xtldo_menu_types` AS `a`
WHERE `a`.`client_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ALL NULL NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX NULL NULL 2 50.00 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.41 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.00 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.07 ms cleaning up 0.02 ms # Volacia funkcia Súbor a číslo riadku 44 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 43 JDatabaseDriver->loadAssocList() JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:109 42 Gantry\Framework\Menu->getMenuOptions() JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:86 41 Gantry\Framework\Menu->getMenus() JROOT/libraries/gantry5/src/classes/Gantry/Component/Menu/AbstractMenu.php:273 40 Gantry\Component\Menu\AbstractMenu->instance() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 39 Twig\Template->getAttribute() JROOT/cache/gantry5/rt_ethereal/twig/19/19f8adc478aa2192dced0e324db5f55a9a8fabc70c8a6168f27ecd2eddfb0b65.php:32 38 __TwigTemplate_6360d48ac8de69bf011b22f4e47c920e8057161103f896708fe27594201bac68->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 36 Twig\Template->display() JROOT/cache/gantry5/rt_ethereal/twig/58/5834446c4b95d9aceb7f7f7d2005f1e47fe1fb37f03c54edd2c13ca5c5649bfe.php:85 35 __TwigTemplate_71a2058ce3af4bf86acb5d0d19acb1e7280a2b449ae4a3eae0e53ec9c958895b->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 34 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 33 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 32 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 31 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 30 Twig\Environment->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 29 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 28 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 27 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 21 Twig\Template->getAttribute() JROOT/cache/gantry5/rt_ethereal/twig/44/443b718b4b7d10dbf10d53c7f959819051f457d219376e18b34dd2d0b94e073d.php:47 20 __TwigTemplate_3d2f853656adb6b47bbce16512a5e0f1b41d3df36de5fd5b0eadf6b195d3957f->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 18 Twig\Template->display() JROOT/cache/gantry5/rt_ethereal/twig/26/26e7a53453c65189ccfd1903a40b6c05ed7ab4b6a9be200e9c92137f1976a5a4.php:35 17 __TwigTemplate_7e912497652b5404597f403c0e9ef7203bee01fa69c45bd1792bb345ba8776f2->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 15 Twig\Template->display() JROOT/cache/gantry5/rt_ethereal/twig/ef/ef8e07e166046269f3dca612e18b7c1048223d8304ffc8fddcc44df12fa15fcd.php:35 14 __TwigTemplate_7207b4f0928042abab84f415c8042082cbf7803c1cb8396fd0c0f2635ba6fad5->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 12 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 11 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/rt_ethereal/index.php:23 7 require JROOT/templates/rt_ethereal/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1126 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 - Čas dotazu: 16.83 ms Po ostatnom dotaze: 210.55 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 5.487 MB Vrátené riadky: 2
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM xtldo_modules AS m
LEFT JOIN xtldo_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN xtldo_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-02-06 23:35:28')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-02-06 23:35:28')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 439 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL PRIMARY,published,newsfeeds NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX NULL NULL 93 1.12 Using where; Pomocou filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 db13483xjom36.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 db13483xjom36.m.id 1 40.00 Using where; Using index Status Duration starting 0.20 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 13.51 ms init 0.10 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.16 ms preparing 0.05 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 2.07 ms end 0.01 ms query end 0.01 ms closing tables 0.09 ms freeing items 0.09 ms cleaning up 0.01 ms # Volacia funkcia Súbor a číslo riadku 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() Rovnaké, ako volanie o riadok nižšie. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 10 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 9 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 8 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:45 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 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
27 zaznamenaných typov dotazov, zoradené podľa výskytu udalosti.
VYBERTE tabuľky:
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `xtldo_extensions`2 × SELECT template
FROM xtldo_template_styles as s2 × SELECT `extension_id`
FROM `xtldo_extensions`2 × SELECT *
FROM xtldo_extensions2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `xtldo_assets`1 × SELECT `data`
FROM `xtldo_session`1 × SELECT `session_id`
FROM `xtldo_session`1 × SELECT id, rules
FROM `xtldo_viewlevels1 × SELECT b.id
FROM xtldo_usergroups AS a
LEFT JOIN xtldo_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM xtldo_extensions1 × SELECT extension, file, type
FROM xtldo_rokcommon_configs1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM xtldo_menu AS m
LEFT JOIN xtldo_extensions AS e
ON m.component_id = e.extension_id1 × SELECT id, home, template, s.params
FROM xtldo_template_styles as s
LEFT JOIN xtldo_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM xtldo_template_styles AS s1 × SELECT *
FROM xtldo_rokcandy1 × SELECT *
FROM xtldo_languages1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM xtldo_content AS a
INNER JOIN xtldo_categories AS c
on c.id = a.catid
LEFT JOIN xtldo_users AS u
on u.id = a.created_by
LEFT JOIN xtldo_categories as parent
ON parent.id = c.parent_id
LEFT JOIN xtldo_content_rating AS v
ON a.id = v.content_id1 × SELECT `m`.`tag_id`,`t`.*
FROM `xtldo_contentitem_tag_map` AS m
INNER JOIN `xtldo_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `xtldo_categories` AS `s`
INNER JOIN `xtldo_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)1 × SELECT 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 xtldo_fields AS a
LEFT JOIN `xtldo_languages` AS l
ON l.lang_code = a.language
LEFT JOIN xtldo_users AS uc
ON uc.id=a.checked_out
LEFT JOIN xtldo_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN xtldo_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN xtldo_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `xtldo_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT `a`.`menutype`,`a`.`title`
FROM `xtldo_menu_types` AS `a`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM xtldo_modules AS m
LEFT JOIN xtldo_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN xtldo_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
ĎALŠIE tabuľky:
1 × INSERT INTO `xtldo_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3866306164386332303238633563373466636638306361626630396664353230', 1, 1675726528, 0, '', 01 × SHOW FULL COLUMNS
FROM `xtldo_extensions1 × UPDATE `xtldo_extensions`
SET `params` = '{\"mediaversion\":\"a848fbafd2f0aa729832b28241532f92\"}'1 × SHOW FULL COLUMNS
FROM `xtldo_content1 × UPDATE xtldo_content
SET `hits` = (`hits` + 1)