Přihlášení
2018
únor 2018
-
úterý, 20 únor 2018 08:00
Registrace sportovních oddílů od milan.kucera :: Sporty -
úterý, 20 únor 2018 08:00
Žádosti o granty Odboru sportu ČOS od milan.kucera :: Sporty -
úterý, 20 únor 2018 08:00
Nejúspěšnější sportovec župy 2017 od milan.kucera :: Sporty
duben 2018
-
čtvrtek, 19 duben 2018 08:00
Župní granty Odboru sportu od milan.kucera :: Sporty
květen 2018
-
sobota, 05 květen 2018 08:00
Turnaj trojčlenných družstev ve stolním tenisu od Ingrid.Vachova :: Sporty
Všechna práva vyhrazena pro Sokolskou župu Jihočeskou 2009 |
Tvorba www stránek SirdikDotCom
Konzole ladění chyb Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1727454301,
"last": 1727454301,
"now": 1727454301
},
"token": "CqUAQFZKcX5Pmirffsk7UPG517a2qvaB"
},
"registry": {
"com_attachments": {
"current_url": "&return=aHR0cHM6Ly96dXBhamlob2Nlc2thLmN6L2luZGV4LnBocD9JdGVtaWQ9MzQxJmNhdGlkcz0xNzcmZGF5PTIwJm1vbnRoPTA3Jm9wdGlvbj1jb21famV2ZW50cyZ0YXNrPXllYXIubGlzdGV2ZW50cyZ5ZWFyPTIwMTg%3D"
},
"published_fv_ses": "0",
"justmine_fv_ses": "0"
},
"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: 25.06 ms / 25.06 ms Paměť: 1.708 MB / 2.06 MB Application: afterLoad
Čas: 65.05 ms / 90.12 ms Paměť: 4.049 MB / 6.11 MB Application: afterInitialise
Čas: 17.52 ms / 107.64 ms Paměť: 1.047 MB / 7.15 MB Application: afterRoute
Čas: 7.82 ms / 115.46 ms Paměť: 0.311 MB / 7.47 MB Application: beforeRenderComponent com_jevents
Čas: 50.19 ms / 165.65 ms Paměť: 2.654 MB / 10.12 MB Application: Before Access::preloadComponents (all components)
Čas: 2.00 ms / 167.65 ms Paměť: 0.061 MB / 10.18 MB Application: After Access::preloadComponents (all components)
Čas: 0.04 ms / 167.69 ms Paměť: -0.005 MB / 10.18 MB Application: Before Access::getAssetRules (id:1398 name:com_jevents)
Čas: 0.97 ms / 168.66 ms Paměť: 0.030 MB / 10.21 MB Application: After Access::getAssetRules (id:1398 name:com_jevents)
Čas: 117.77 ms / 286.43 ms Paměť: 5.460 MB / 15.67 MB Application: afterRenderComponent com_jevents
Čas: 1.58 ms / 288.00 ms Paměť: 0.006 MB / 15.67 MB Application: afterDispatch
Čas: 3.87 ms / 291.87 ms Paměť: 0.098 MB / 15.77 MB Application: beforeRenderModule mod_menu (Hlavní nabídka)
Čas: 5.04 ms / 296.91 ms Paměť: 0.231 MB / 16.00 MB Application: afterRenderModule mod_menu (Hlavní nabídka)
Čas: 0.03 ms / 296.94 ms Paměť: -0.005 MB / 16.00 MB Application: beforeRenderModule mod_login (Přihlášení)
Čas: 4.38 ms / 301.32 ms Paměť: 0.030 MB / 16.03 MB Application: afterRenderModule mod_login (Přihlášení)
Čas: 0.05 ms / 301.37 ms Paměť: 0.004 MB / 16.03 MB Application: beforeRenderModule mod_search (Vyhledavání)
Čas: 2.28 ms / 303.65 ms Paměť: 0.017 MB / 16.05 MB Application: afterRenderModule mod_search (Vyhledavání)
Čas: 10.77 ms / 314.42 ms Paměť: 1.058 MB / 17.10 MB Application: afterRender
Celkem dotazů do databáze: 41.13 ms
17,52 MB (18.375.336 Bytů)
36 zaznamenaných dotazů 41.13 ms
- Čas pro dotazy: 0.60 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 3.638 MB Vráceno řádků: 0
SELECT `session_id`
FROM `j38_session`
WHERE `session_id` = X'327163726a6362357436306b6f376b64753864686e38396d616f'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.05 ms checking permissions 0.03 ms Opening tables 0.10 ms init 0.02 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.04 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Čas pro dotazy: 0.53 ms Po posledním dotazu: 0.09 ms Dotaz paměti: 0.004 MB Paměť před dotazem: 3.643 MB
INSERT INTO `j38_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'327163726a6362357436306b6f376b64753864686e38396d616f', 1, 1727454301, 0, '', 0)VYSVĚTLENÍ není možné pro dotaz: INSERT INTO `j38_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'327163726a6362357436306b6f376b64753864686e38396d616f', 1, 1727454301, 0, '', 0)Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms update 0.09 ms Waiting for query cache lock 0.01 ms update 0.01 ms end 0.01 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Čas pro dotazy: 1.04 ms Po posledním dotazu: 3.04 ms Dotaz paměti: 0.040 MB Paměť před dotazem: 3.815 MB Vráceno řádků: 41
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j38_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 j38_extensions NULL ref extension extension 82 const 42 1.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.29 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 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}() Stejné jako volání na řádku níže. 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 pro dotazy: 0.52 ms Po posledním dotazu: 2.79 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 4.072 MB Vráceno řádků: 4
SELECT id, rules
FROM `j38_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_viewlevels NULL ALL NULL MOHL BY BÝT POUŽIT NO INDEX KEY NULL NULL 4 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.02 ms Opening tables 0.08 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 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 pro dotazy: 0.69 ms Po posledním dotazu: 0.10 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 4.084 MB Vráceno řádků: 1
SELECT b.id
FROM j38_usergroups AS a
LEFT JOIN j38_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id 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 1 100.00 Using where; Using index Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.03 ms # Volající Soubor a číslo řádku 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 pro dotazy: 1.69 ms Po posledním dotazu: 0.73 ms Dotaz paměti: 0.031 MB Paměť před dotazem: 4.149 MB Vráceno řádků: 128
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM j38_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_extensions NULL ref extension extension 82 const 142 0.48 Using index condition; Using where; Použití filesort Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.96 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 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}() Stejné jako volání na řádku níže. 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 pro dotazy: 2.43 ms Po posledním dotazu: 27.72 ms Dotaz paměti: 0.107 MB Paměť před dotazem: 6.344 MB Vráceno řádků: 55
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 j38_menu AS m
LEFT JOIN j38_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 range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 126 10.00 Using index condition; Using where; Použití filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 zupajihoceska3.m.component_id 1 100.00 Using where Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.21 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 1.27 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 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}() Stejné jako volání na řádku níže. 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:417 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:533 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:1141 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 pro dotazy: 1.13 ms Po posledním dotazu: 12.74 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 7.188 MB Vráceno řádků: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j38_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.17 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 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}() Stejné jako volání na řádku níže. 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:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.67 ms Po posledním dotazu: 0.20 ms Dotaz paměti: 0.005 MB Paměť před dotazem: 7.179 MB
UPDATE `j38_extensions`
SET `params` = '{\"mediaversion\":\"10445ec2ae2574a1c971caf6beede7e0\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE j38_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.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.12 ms updating 0.11 ms end 0.01 ms query end 0.05 ms closing tables 0.06 ms freeing items 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.71 ms Po posledním dotazu: 2.40 ms Dotaz paměti: 0.019 MB Paměť před dotazem: 7.449 MB Vráceno řádků: 2
SELECT *
FROM j38_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_languages NULL ALL NULL MOHL BY BÝT POUŽIT NO INDEX KEY NULL NULL 1 100.00 Using where; Použití filesort Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.12 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 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 pro dotazy: 1.21 ms Po posledním dotazu: 0.32 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 7.460 MB Vráceno řádků: 13
SELECT id, home, template, s.params
FROM j38_template_styles as s
LEFT JOIN j38_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 16 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 zupajihoceska3.e.element 1 81.25 Using index condition; Using where Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.04 ms executing 0.01 ms Sending data 0.28 ms end 0.01 ms query end 0.04 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 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 - Čas pro dotazy: 1.68 ms Po posledním dotazu: 51.05 ms Dotaz paměti: 0.030 MB Paměť před dotazem: 10.124 MB Vráceno řádků: 41
SELECT `id`,`name`,`rules`,`parent_id`
FROM `j38_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acym','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_attachments','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jevents','com_joomgallery','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_assets NULL range idx_asset_name idx_asset_name 202 NULL 42 100.00 Using index condition Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.21 ms init 0.06 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.26 ms preparing 0.02 ms executing 0.00 ms Sending data 0.62 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 21 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 20 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 19 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 18 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 17 Joomla\CMS\User\User->authorise() JROOT/components/com_jevents/libraries/helper.php:1428 16 JEVHelper::isAdminUser() JROOT/components/com_jevents/libraries/helper.php:1386 15 JEVHelper::getAid() JROOT/components/com_jevents/libraries/datamodel.php:50 14 JEventsDataModel->__construct() JROOT/components/com_jevents/views/default/abstract/abstract.php:65 13 JEventsDefaultView->__construct() JROOT/components/com_jevents/views/flat/abstract/abstract.php:36 12 JEventsFlatView->__construct() JROOT/libraries/src/MVC/Factory/LegacyFactory.php:89 11 Joomla\CMS\MVC\Factory\LegacyFactory->createView() JROOT/libraries/src/MVC/Controller/BaseController.php:590 10 Joomla\CMS\MVC\Controller\BaseController->createView() JROOT/libraries/src/MVC/Controller/BaseController.php:833 9 Joomla\CMS\MVC\Controller\BaseController->getView() JROOT/components/com_jevents/controllers/year.php:68 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 1.82 ms Po posledním dotazu: 14.00 ms Dotaz paměti: 0.036 MB Paměť před dotazem: 11.179 MB Vráceno řádků: 31
SHOW FULL COLUMNS
FROM `j38_content`VYSVĚTLENÍ není možné pro dotaz: SHOW FULL COLUMNS FROM `j38_content`Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.28 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.04 ms Opening tables 0.14 ms checking permissions 0.08 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.04 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.06 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms Sending data 0.18 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.07 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 25 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 24 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 23 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 22 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 21 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 20 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:15 19 DefaultLoadModules() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 18 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:17 17 FlatViewHelperHeader16() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 16 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:7 15 FlatViewHelperHeader() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 14 JEventsDefaultView->__call() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:6 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 1.62 ms Po posledním dotazu: 15.52 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 11.997 MB Vráceno řádků: 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 j38_fields AS a
LEFT JOIN `j38_languages` AS l
ON l.lang_code = a.language
LEFT JOIN j38_users AS uc
ON uc.id=a.checked_out
LEFT JOIN j38_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN j38_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN j38_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.article'
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 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; Použití filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 zupajihoceska3.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 zupajihoceska3.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 zupajihoceska3.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 zupajihoceska3.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 zupajihoceska3.a.group_id 1 100.00 Using where Status Duration starting 0.20 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.24 ms init 0.08 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.19 ms preparing 0.05 ms Creating tmp table 0.07 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.23 ms Creating sort index 0.04 ms end 0.01 ms query end 0.01 ms removing tmp table 0.05 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.05 ms # Volající Soubor a číslo řádku 29 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 28 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 27 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 26 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 25 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 24 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 23 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 22 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 21 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 20 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:23 19 DefaultLoadModules() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 18 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:17 17 FlatViewHelperHeader16() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 16 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:7 15 FlatViewHelperHeader() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 14 JEventsDefaultView->__call() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:6 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 1.32 ms Po posledním dotazu: 2.10 ms Dotaz paměti: 0.030 MB Paměť před dotazem: 12.119 MB Vráceno řádků: 4
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM j38_modules AS m
LEFT JOIN j38_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN j38_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 <= '2024-09-27 16:25:01')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-27 16:25:01')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 341 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 range PRIMARY,published,newsfeeds published 5 NULL 6 3.57 Using index condition; Using where; Použití filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 zupajihoceska3.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 zupajihoceska3.m.id 1 40.00 Using where; Using index Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.07 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.06 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.35 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 30 JDatabaseDriver->loadObjectList() Stejné jako volání na řádku níže. 29 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 28 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 27 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 26 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 25 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/plugins/content/loadmodule/loadmodule.php:169 24 PlgContentLoadmodule->_load() JROOT/plugins/content/loadmodule/loadmodule.php:81 23 PlgContentLoadmodule->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 22 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 21 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 20 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:23 19 DefaultLoadModules() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 18 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:17 17 FlatViewHelperHeader16() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 16 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:7 15 FlatViewHelperHeader() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 14 JEventsDefaultView->__call() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:6 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 1.19 ms Po posledním dotazu: 17.01 ms Dotaz paměti: 0.033 MB Paměť před dotazem: 12.831 MB Vráceno řádků: 18
SHOW FULL COLUMNS
FROM `j38_jev_users`VYSVĚTLENÍ není možné pro dotaz: SHOW FULL COLUMNS FROM `j38_jev_users`Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.23 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.03 ms executing 0.02 ms Opening tables 0.10 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms Sending data 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.04 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 29 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 28 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 27 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 26 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 25 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_jevents/tables/jevuser.php:75 24 TableUser->__construct() JROOT/components/com_jevents/libraries/helper.php:1851 23 JEVHelper::getAuthorisedUser() JROOT/components/com_jevents/libraries/helper.php:1706 22 JEVHelper::isEventCreator() JROOT/components/com_jevents/libraries/filters/Published.php:86 21 jevPublishedFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:186 20 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:257 19 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:3543 18 JEventsDBModel->listIcalEventsByYear() JROOT/components/com_jevents/libraries/dbmodel.php:3497 17 JEventsDBModel->countIcalEventsByYear() JROOT/components/com_jevents/libraries/datamodel.php:567 16 JEventsDataModel->getYearData() JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php:10 15 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 1.14 ms Po posledním dotazu: 4.05 ms Dotaz paměti: 0.033 MB Paměť před dotazem: 12.980 MB Vráceno řádků: 6
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 `j38_categories` AS `c`
WHERE (c.extension='com_jevents' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL range cat_idx,idx_access cat_idx 207 NULL 6 100.00 Using index condition; Použití filesort Status Duration starting 0.14 ms checking permissions 0.01 ms Opening tables 0.09 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.23 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 28 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 27 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 26 Joomla\CMS\Categories\Categories->_load() JROOT/components/com_jevents/helpers/category.php:53 25 JEventsCategories->_load() JROOT/libraries/src/Categories/Categories.php:184 24 Joomla\CMS\Categories\Categories->get() JROOT/components/com_jevents/libraries/dbmodel.php:422 23 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/datamodel.php:1021 22 JEventsDataModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/filters/Category.php:47 21 jevCategoryFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:186 20 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:257 19 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:3543 18 JEventsDBModel->listIcalEventsByYear() JROOT/components/com_jevents/libraries/dbmodel.php:3497 17 JEventsDBModel->countIcalEventsByYear() JROOT/components/com_jevents/libraries/datamodel.php:567 16 JEventsDataModel->getYearData() JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php:10 15 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 0.89 ms Po posledním dotazu: 0.67 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 13.047 MB Vráceno řádků: 5
SELECT c.id
FROM j38_categories AS c
WHERE c.access IN (1,1)
AND c.published = 1
AND c.language in ('cs-CZ','*')
AND c.extension = 'com_jevents'
ORDER BY c.lft ascid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL range cat_idx,idx_access,idx_language cat_idx 207 NULL 5 100.00 Using index condition; Using where; Použití filesort Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.16 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 24 JDatabaseDriver->loadColumn() JROOT/components/com_jevents/libraries/dbmodel.php:558 23 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/datamodel.php:1021 22 JEventsDataModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/filters/Category.php:47 21 jevCategoryFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:186 20 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:257 19 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:3543 18 JEventsDBModel->listIcalEventsByYear() JROOT/components/com_jevents/libraries/dbmodel.php:3497 17 JEventsDBModel->countIcalEventsByYear() JROOT/components/com_jevents/libraries/datamodel.php:567 16 JEventsDataModel->getYearData() JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php:10 15 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 0.84 ms Po posledním dotazu: 0.85 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 13.079 MB Vráceno řádků: 1
SELECT c.id
FROM j38_categories AS c
WHERE c.access IN (1,1)
AND c.published = 1
AND c.language in ('cs-CZ','*')
AND c.extension = 'com_jevents'
AND ((c.lft>=237
AND c.rgt<=238 ))
ORDER BY c.lft ascid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right,idx_language cat_idx 207 NULL 5 1.34 Using index condition; Using where; Použití filesort Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.15 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 20 JDatabaseDriver->loadColumn() JROOT/components/com_jevents/libraries/dbmodel.php:558 19 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/dbmodel.php:3554 18 JEventsDBModel->listIcalEventsByYear() JROOT/components/com_jevents/libraries/dbmodel.php:3497 17 JEventsDBModel->countIcalEventsByYear() JROOT/components/com_jevents/libraries/datamodel.php:567 16 JEventsDataModel->getYearData() JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php:10 15 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 3.21 ms Po posledním dotazu: 0.48 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 13.114 MB Vráceno řádků: 5
SELECT rpt.rp_id
FROM j38_jevents_repetition as rpt
INNER JOIN j38_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN j38_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN j38_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN j38_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,177)
AND rpt.endrepeat >= '2018-01-01 00:00:00'
AND rpt.startrepeat <= '2018-12-31 23:59:59'
AND ev.state=1
AND ev.access IN (1,1)
AND icsf.state=1
AND icsf.access IN (1,1)
GROUP BY ev.ev_idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE icsf NULL ref PRIMARY,stateidx stateidx 1 const 1 100.00 Using where; Using temporary; Použití filesort 1 SIMPLE ev NULL ref PRIMARY,uid,icsid,stateidx,evaccess icsid 4 zupajihoceska3.icsf.ics_id 38 20.00 Using where 1 SIMPLE rpt NULL ref eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat eventid 4 zupajihoceska3.ev.ev_id 1 38.05 Using where 1 SIMPLE det NULL eq_ref PRIMARY PRIMARY 4 zupajihoceska3.rpt.eventdetail_id 1 100.00 Using index 1 SIMPLE rr NULL ref eventid eventid 4 zupajihoceska3.ev.ev_id 1 100.00 Using index Status Duration starting 0.15 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 1.74 ms init 0.07 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.24 ms preparing 0.04 ms Creating tmp table 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.38 ms Creating sort index 0.04 ms end 0.02 ms query end 0.03 ms removing tmp table 0.01 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 21 JDatabaseDriverMysqli->execute() JROOT/components/com_jevents/libraries/dbmodel.php:3287 20 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 19 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:3639 18 JEventsDBModel->listIcalEventsByYear() JROOT/components/com_jevents/libraries/dbmodel.php:3497 17 JEventsDBModel->countIcalEventsByYear() JROOT/components/com_jevents/libraries/datamodel.php:567 16 JEventsDataModel->getYearData() JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php:10 15 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 2.90 ms Po posledním dotazu: 0.47 ms Dotaz paměti: 0.052 MB Paměť před dotazem: 13.126 MB Vráceno řádků: 5
SELECT ev.*, rpt.*, rr.*, det.*, ev.state as published , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM j38_jevents_repetition as rpt use INDEX (eventstart)
INNER JOIN j38_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN j38_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN j38_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN j38_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,177)
AND rpt.endrepeat >= '2018-01-01 00:00:00'
AND rpt.startrepeat <= '2018-12-31 23:59:59'
AND ev.state=1
AND ev.access IN (1,1)
AND icsf.state=1
AND icsf.access IN (1,1)
GROUP BY ev.ev_id
ORDER BY rpt.startrepeat asc
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE icsf NULL ref PRIMARY,stateidx stateidx 1 const 1 100.00 Using where; Using temporary; Použití filesort 1 SIMPLE ev NULL ref PRIMARY,uid,icsid,stateidx,evaccess icsid 4 zupajihoceska3.icsf.ics_id 38 20.00 Using where 1 SIMPLE rpt NULL ref eventstart eventstart 4 zupajihoceska3.ev.ev_id 1 11.11 Using index condition; Using where 1 SIMPLE det NULL eq_ref PRIMARY PRIMARY 4 zupajihoceska3.rpt.eventdetail_id 1 100.00 NULL 1 SIMPLE rr NULL ref eventid eventid 4 zupajihoceska3.ev.ev_id 1 100.00 NULL Status Duration starting 0.21 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.13 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.18 ms preparing 0.04 ms Creating tmp table 0.10 ms Sorting result 0.01 ms executing 0.01 ms Sending data 1.02 ms Creating sort index 0.34 ms end 0.01 ms query end 0.01 ms removing tmp table 0.13 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:3300 19 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 18 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:3639 17 JEventsDBModel->listIcalEventsByYear() JROOT/components/com_jevents/libraries/datamodel.php:584 16 JEventsDataModel->getYearData() JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php:10 15 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 1.09 ms Po posledním dotazu: 4.13 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 13.675 MB Vráceno řádků: 0
SELECT *, summary as title, description as content
FROM j38_jevents_translation
WHERE evdet_id IN(17,18,20,19,24)
AND language='cs-CZ'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_jevents_translation NULL ALL evdet_id,langdetail MOHL BY BÝT POUŽIT NO INDEX KEY NULL NULL 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.50 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:776 20 JEventsDBModel::translateEvents() JROOT/components/com_jevents/libraries/dbmodel.php:3338 19 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 18 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:3639 17 JEventsDBModel->listIcalEventsByYear() JROOT/components/com_jevents/libraries/datamodel.php:584 16 JEventsDataModel->getYearData() JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php:10 15 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 0.84 ms Po posledním dotazu: 0.41 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 13.674 MB Vráceno řádků: 6
SELECT c.*
FROM j38_categories as c
WHERE extension='com_jevents'
order by c.lft ascid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref cat_idx cat_idx 202 const 6 100.00 Using index condition; Použití filesort Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.17 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/commonfunctions.php:191 18 JEV_CommonFunctions::getCategoryData() JROOT/components/com_jevents/libraries/commonfunctions.php:144 17 JEV_CommonFunctions::setColor() JROOT/components/com_jevents/libraries/jeventcal.php:614 16 jEventCal->bgcolor() JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php:64 15 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 0.79 ms Po posledním dotazu: 4.29 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 14.050 MB Vráceno řádků: 5
SELECT a.id, a.parent_id
FROM j38_categories AS a
WHERE a.parent_id > 0
AND a.extension = "com_jevents"
AND a.published = 1
AND a.language in ('cs-CZ','*')
ORDER BY a.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref cat_idx,idx_language cat_idx 203 const,const 5 33.33 Using index condition; Using where; Použití filesort Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.13 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:42 17 DefaultLoadedFromTemplate() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 16 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php:67 15 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 0.99 ms Po posledním dotazu: 0.08 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 14.063 MB Vráceno řádků: 0
SELECT *
FROM j38_jev_defaults
WHERE state=1
AND name= 'icalevent.list_row'
AND value<>''
AND language in ('cs-CZ','*')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_jev_defaults NULL ref name,langcodename name 152 const 18 6.00 Using where Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.29 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:76 17 DefaultLoadedFromTemplate() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 16 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php:67 15 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 1.19 ms Po posledním dotazu: 2.36 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 14.152 MB Vráceno řádků: 0
SELECT `c2`.`language`,`c2`.`id`
FROM `j38_menu` AS `c`
INNER JOIN `j38_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `j38_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `j38_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 341id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL MOHL BY BÝT POUŽIT NO INDEX KEY NULL NULL NULL NULL no matching row in const table Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.58 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 20 Joomla\CMS\Language\Associations::getAssociations() JROOT/administrator/components/com_menus/helpers/menus.php:321 19 MenusHelper::getAssociations() JROOT/components/com_jevents/libraries/jicaleventrepeat.php:292 18 jIcalEventRepeat->viewDetailLink() JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:567 17 DefaultLoadedFromTemplate() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 16 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php:67 15 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 0.88 ms Po posledním dotazu: 2.03 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 14.255 MB Vráceno řádků: 0
SELECT ju.id, ju.name, ju.username, ju.sendEmail, ju.email, cd.name as contactname,
CASE WHEN CHAR_LENGTH(cd.alias) THEN CONCAT_WS(':', cd.id, cd.alias) ELSE cd.id END as slug,
CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.id, cat.alias) ELSE cat.id END AS catslug
FROM j38_users AS ju
LEFT JOIN j38_contact_details AS cd
ON cd.user_id = ju.id
LEFT JOIN j38_categories AS cat
ON cat.id = cd.catid
WHERE block ='0'
AND cd.published =1
AND cd.access IN (1,1)
AND cat.access IN (1,1)
AND ju.id = 80id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ju NULL const PRIMARY,idx_block PRIMARY 4 const 1 100.00 NULL 1 SIMPLE cd NULL ref idx_access,idx_state,idx_catid idx_state 1 const 1 10.00 Using where 1 SIMPLE cat NULL eq_ref PRIMARY,idx_access PRIMARY 4 zupajihoceska3.cd.catid 1 78.23 Using where Status Duration starting 0.15 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.03 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 21 JDatabaseDriver->loadObject() JROOT/components/com_jevents/libraries/helper.php:2989 20 JEVHelper::getContact() JROOT/components/com_jevents/libraries/jeventshtml.php:786 19 JEventsHTML::getUserMailtoLink() JROOT/components/com_jevents/libraries/jeventcal.php:406 18 jEventCal->contactLink() JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1756 17 DefaultLoadedFromTemplate() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 16 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php:67 15 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 0.43 ms Po posledním dotazu: 0.07 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 14.268 MB Vráceno řádků: 1
SELECT `id`
FROM `j38_users`
WHERE `id` = '80'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_users NULL const PRIMARY PRIMARY 4 const 1 100.00 Using index Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 22 JDatabaseDriver->loadResult() JROOT/components/com_jevents/libraries/helper.php:3048 21 JEVHelper::getUser() JROOT/components/com_jevents/libraries/helper.php:2994 20 JEVHelper::getContact() JROOT/components/com_jevents/libraries/jeventshtml.php:786 19 JEventsHTML::getUserMailtoLink() JROOT/components/com_jevents/libraries/jeventcal.php:406 18 jEventCal->contactLink() JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1756 17 DefaultLoadedFromTemplate() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 16 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php:67 15 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 1.11 ms Po posledním dotazu: 1.00 ms Dotaz paměti: 0.035 MB Paměť před dotazem: 14.407 MB Vráceno řádků: 17
SHOW FULL COLUMNS
FROM `j38_users`VYSVĚTLENÍ není možné pro dotaz: SHOW FULL COLUMNS FROM `j38_users`Status Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.03 ms Opening tables 0.24 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.05 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.08 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.05 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 33 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 32 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 31 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 30 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 29 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41 28 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:328 27 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 26 Joomla\CMS\User\User::getTable() JROOT/libraries/src/User/User.php:877 25 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 24 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 23 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 22 Joomla\CMS\Factory::getUser() JROOT/components/com_jevents/libraries/helper.php:3055 21 JEVHelper::getUser() JROOT/components/com_jevents/libraries/helper.php:2994 20 JEVHelper::getContact() JROOT/components/com_jevents/libraries/jeventshtml.php:786 19 JEventsHTML::getUserMailtoLink() JROOT/components/com_jevents/libraries/jeventcal.php:406 18 jEventCal->contactLink() JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1756 17 DefaultLoadedFromTemplate() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 16 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php:67 15 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 0.50 ms Po posledním dotazu: 0.15 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 14.444 MB Vráceno řádků: 1
SELECT *
FROM `j38_users`
WHERE `id` = 80id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_users 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.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 28 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 27 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 26 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 25 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 24 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 23 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 22 Joomla\CMS\Factory::getUser() JROOT/components/com_jevents/libraries/helper.php:3055 21 JEVHelper::getUser() JROOT/components/com_jevents/libraries/helper.php:2994 20 JEVHelper::getContact() JROOT/components/com_jevents/libraries/jeventshtml.php:786 19 JEventsHTML::getUserMailtoLink() JROOT/components/com_jevents/libraries/jeventcal.php:406 18 jEventCal->contactLink() JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1756 17 DefaultLoadedFromTemplate() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 16 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php:67 15 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 0.93 ms Po posledním dotazu: 3.62 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 15.207 MB Vráceno řádků: 1
SELECT `g`.`id`,`g`.`title`
FROM `j38_usergroups` AS g
INNER JOIN `j38_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 80id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref PRIMARY PRIMARY 4 const 1 100.00 Using index 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 zupajihoceska3.m.group_id 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.36 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 28 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 27 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:112 26 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 25 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 24 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 23 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 22 Joomla\CMS\Factory::getUser() JROOT/components/com_jevents/libraries/helper.php:3055 21 JEVHelper::getUser() JROOT/components/com_jevents/libraries/helper.php:2994 20 JEVHelper::getContact() JROOT/components/com_jevents/libraries/jeventshtml.php:786 19 JEventsHTML::getUserMailtoLink() JROOT/components/com_jevents/libraries/jeventcal.php:406 18 jEventCal->contactLink() JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1756 17 DefaultLoadedFromTemplate() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 16 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php:67 15 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 0.90 ms Po posledním dotazu: 0.16 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 15.215 MB Vráceno řádků: 6
SELECT cat.id, cat.title as name, pcat.title as pname, cat.description, cat.params
FROM j38_categories as cat
LEFT JOIN j38_categories as pcat
on pcat.id=cat.parent_id
WHERE cat.extension='com_jevents'
ORDER BY cat.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE cat NULL ref cat_idx cat_idx 202 const 6 100.00 Using index condition; Použití filesort 1 SIMPLE pcat NULL eq_ref PRIMARY PRIMARY 4 zupajihoceska3.cat.parent_id 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.19 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/jeventcal.php:523 21 jEventCal->getCategoryData() JROOT/components/com_jevents/libraries/jeventcal.php:478 20 jEventCal->getCategoryName() JROOT/components/com_jevents/libraries/jicaleventdb.php:683 19 jIcalEventDB->getCategoryName() JROOT/components/com_jevents/libraries/jeventcal.php:468 18 jEventCal->catname() JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:659 17 DefaultLoadedFromTemplate() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 16 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php:67 15 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 0.82 ms Po posledním dotazu: 7.36 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 15.476 MB Vráceno řádků: 1
SELECT ju.id, ju.name, ju.username, ju.sendEmail, ju.email, cd.name as contactname,
CASE WHEN CHAR_LENGTH(cd.alias) THEN CONCAT_WS(':', cd.id, cd.alias) ELSE cd.id END as slug,
CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.id, cat.alias) ELSE cat.id END AS catslug
FROM j38_users AS ju
LEFT JOIN j38_contact_details AS cd
ON cd.user_id = ju.id
LEFT JOIN j38_categories AS cat
ON cat.id = cd.catid
WHERE block ='0'
AND cd.published =1
AND cd.access IN (1,1)
AND cat.access IN (1,1)
AND ju.id = 134id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ju NULL const PRIMARY,idx_block PRIMARY 4 const 1 100.00 NULL 1 SIMPLE cd NULL ref idx_access,idx_state,idx_catid idx_state 1 const 1 10.00 Using where 1 SIMPLE cat NULL eq_ref PRIMARY,idx_access PRIMARY 4 zupajihoceska3.cd.catid 1 78.23 Using where Status Duration starting 0.13 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.17 ms preparing 0.03 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 21 JDatabaseDriver->loadObject() JROOT/components/com_jevents/libraries/helper.php:2989 20 JEVHelper::getContact() JROOT/components/com_jevents/libraries/jeventshtml.php:786 19 JEventsHTML::getUserMailtoLink() JROOT/components/com_jevents/libraries/jeventcal.php:406 18 jEventCal->contactLink() JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1756 17 DefaultLoadedFromTemplate() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 16 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php:67 15 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 0.75 ms Po posledním dotazu: 6.29 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 15.720 MB Vráceno řádků: 5
SELECT c.*
FROM j38_categories as c
WHERE extension='com_jevents'
AND c.access IN (1,1)
AND c.language in ('cs-CZ','*')
AND c.published = 1
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL range cat_idx,idx_access,idx_language cat_idx 207 NULL 5 100.00 Using index condition; Using where; Použití filesort Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.03 ms Creating sort index 0.15 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/modules/mod_jevents_legend/tmpl/default/legend.php:277 19 DefaultModLegendView->getCategoryHierarchy() JROOT/modules/mod_jevents_legend/tmpl/flat/legend.php:109 18 FlatModLegendView->displayCalendarLegend() JROOT/components/com_jevents/views/default/helpers/defaulteventslegend.php:30 17 DefaultEventsLegend() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 16 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php:86 15 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11 13 include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/year.php:88 8 YearController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.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 pro dotazy: 1.18 ms Po posledním dotazu: 28.85 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 16.683 MB Vráceno řádků: 153
SHOW TABLES
VYSVĚTLENÍ není možné pro dotaz: SHOW TABLESStatus Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms checking permissions 0.56 ms Sending data 0.11 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms removing tmp table 0.02 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 15 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:505 14 JDatabaseDriverMysqli->getTableList() JROOT/administrator/components/com_acymailing/compat/joomla.php:552 13 acymailing_getTableList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:16 12 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:455 11 acymailing_config() JROOT/administrator/components/com_acymailing/compat/joomla.php:840 10 include_once JROOT/administrator/components/com_acymailing/compat/joomla.php JROOT/administrator/components/com_acymailing/helpers/helper.php:23 9 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/plugins/system/regacymailing/regacymailing.php:22 8 plgSystemRegacymailing->initAcy() JROOT/plugins/system/regacymailing/regacymailing.php:146 7 plgSystemRegacymailing->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 - Čas pro dotazy: 0.90 ms Po posledním dotazu: 0.08 ms Dotaz paměti: 0.034 MB Paměť před dotazem: 16.709 MB Vráceno řádků: 167
SELECT *
FROM j38_acymailing_configid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_acymailing_config NULL ALL NULL MOHL BY BÝT POUŽIT NO INDEX KEY NULL NULL 167 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.33 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:478 13 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:21 12 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:455 11 acymailing_config() JROOT/administrator/components/com_acymailing/compat/joomla.php:840 10 include_once JROOT/administrator/components/com_acymailing/compat/joomla.php JROOT/administrator/components/com_acymailing/helpers/helper.php:23 9 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/plugins/system/regacymailing/regacymailing.php:22 8 plgSystemRegacymailing->initAcy() JROOT/plugins/system/regacymailing/regacymailing.php:146 7 plgSystemRegacymailing->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
32 zaznamenaných typů dotazu, řazeno dle výskytu
VYBRANÉ tabulky:
2 × SELECT ju.id, ju.name, ju.username, ju.sendEmail, ju.email, cd.name as contactname,
CASE WHEN CHAR_LENGTH(cd.alias) THEN CONCAT_WS(':', cd.id, cd.alias) ELSE cd.id END as slug,
CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.id, cat.alias) ELSE cat.id END AS catslug
FROM j38_users AS ju
LEFT JOIN j38_contact_details AS cd
ON cd.user_id = ju.id
LEFT JOIN j38_categories AS cat
ON cat.id = cd.catid2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j38_extensions`2 × SELECT c.*
FROM j38_categories as c2 × SELECT c.id
FROM j38_categories AS c1 × SELECT `session_id`
FROM `j38_session`1 × SELECT cat.id, cat.title as name, pcat.title as pname, cat.description, cat.params
FROM j38_categories as cat
LEFT JOIN j38_categories as pcat
on pcat.id=cat.parent_id1 × SELECT `g`.`id`,`g`.`title`
FROM `j38_usergroups` AS g
INNER JOIN `j38_user_usergroup_map` AS m
ON m.group_id = g.id1 × SELECT *
FROM `j38_users`1 × SELECT `id`
FROM `j38_users`1 × SELECT `c2`.`language`,`c2`.`id`
FROM `j38_menu` AS `c`
INNER JOIN `j38_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `j38_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `j38_menu` AS `c2`
ON a2.id = c2.`id`1 × SELECT *
FROM j38_jev_defaults1 × SELECT a.id, a.parent_id
FROM j38_categories AS a1 × SELECT *, summary as title, description as content
FROM j38_jevents_translation1 × SELECT rpt.rp_id
FROM j38_jevents_repetition as rpt
INNER JOIN j38_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN j38_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN j38_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN j38_jevents_rrule as rr
ON rr.eventid = rpt.eventid1 × SELECT ev.*, rpt.*, rr.*, det.*, ev.state as published , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM j38_jevents_repetition as rpt use INDEX (eventstart)
INNER JOIN j38_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN j38_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN j38_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN j38_jevents_rrule as rr
ON rr.eventid = rpt.eventid1 × 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 `j38_categories` AS `c`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM j38_modules AS m
LEFT JOIN j38_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN j38_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × 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 j38_fields AS a
LEFT JOIN `j38_languages` AS l
ON l.lang_code = a.language
LEFT JOIN j38_users AS uc
ON uc.id=a.checked_out
LEFT JOIN j38_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN j38_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN j38_fields_groups AS g
ON g.id = a.group_id1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `j38_assets`1 × SELECT id, home, template, s.params
FROM j38_template_styles as s
LEFT JOIN j38_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM j38_languages1 × 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 j38_menu AS m
LEFT JOIN j38_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM j38_extensions1 × SELECT b.id
FROM j38_usergroups AS a
LEFT JOIN j38_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `j38_viewlevels1 × SELECT *
FROM j38_acymailing_confi
OSTATNÍ tabulky:
1 × INSERT INTO `j38_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'327163726a6362357436306b6f376b64753864686e38396d616f', 1, 1727454301, 0, '', 01 × UPDATE `j38_extensions`
SET `params` = '{\"mediaversion\":\"10445ec2ae2574a1c971caf6beede7e0\"}'1 × SHOW FULL COLUMNS
FROM `j38_content1 × SHOW FULL COLUMNS
FROM `j38_jev_users1 × SHOW FULL COLUMNS
FROM `j38_users1 × SHOW TABLE