Přihlášení
Písecký šplhavec
od Ingrid.Vachova
Místo Písek
9.30 - 10.30 prezence
Všechna práva vyhrazena pro Sokolskou župu Jihočeskou 2009 |
Tvorba www stránek SirdikDotCom
Joomla! konzole ladění chyb
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1714032396,
"last": 1714032396,
"now": 1714032396
},
"token": "NbDQdSnaqw6HaWf1gdhYE8fFFjKE2KiL"
},
"registry": {
"com_attachments": {
"current_url": "&return=aHR0cHM6Ly96dXBhamlob2Nlc2thLmN6L2luZGV4LnBocD9vcHRpb249Y29tX2pldmVudHMmdGFzaz1pY2FscmVwZWF0LmRldGFpbCZldmlkPTUwJkl0ZW1pZD0zNDEmeWVhcj0yMDE5Jm1vbnRoPTEwJmRheT0xOSZ0aXRsZT1waXNlY2t5LXNwbGhhdmVjJnVpZD04OWYzNGU3Nzk3OTM0YmIwMzM2OTQxZTI4MzhkYTExNw%3D%3D"
},
"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: 9.22 ms / 9.22 ms Paměť: 0.401 MB / 0.75 MB Application: afterLoad
Čas: 43.21 ms / 52.43 ms Paměť: 0.912 MB / 1.66 MB Application: afterInitialise
Čas: 13.55 ms / 65.97 ms Paměť: 0.389 MB / 2.05 MB Application: afterRoute
Čas: 5.51 ms / 71.49 ms Paměť: 0.086 MB / 2.14 MB Application: beforeRenderComponent com_jevents
Čas: 19.98 ms / 91.46 ms Paměť: 0.553 MB / 2.69 MB Application: Before Access::preloadComponents (all components)
Čas: 2.47 ms / 93.93 ms Paměť: 0.059 MB / 2.75 MB Application: After Access::preloadComponents (all components)
Čas: 0.03 ms / 93.96 ms Paměť: 0.000 MB / 2.75 MB Application: Before Access::getAssetRules (id:1398 name:com_jevents)
Čas: 0.43 ms / 94.38 ms Paměť: 0.013 MB / 2.76 MB Application: After Access::getAssetRules (id:1398 name:com_jevents)
Čas: 46.23 ms / 140.61 ms Paměť: 1.184 MB / 3.94 MB Application: Before Access::preloadPermissions (com_jevents)
Čas: 2.71 ms / 143.32 ms Paměť: 0.029 MB / 3.97 MB Application: After Access::preloadPermissions (com_jevents)
Čas: 0.02 ms / 143.34 ms Paměť: 0.000 MB / 3.97 MB Application: Before Access::getAssetRules (id:1408 name:com_jevents.category.176)
Čas: 0.01 ms / 143.35 ms Paměť: 0.002 MB / 3.97 MB Application: After Access::getAssetRules (id:1408 name:com_jevents.category.176)
Čas: 21.72 ms / 165.07 ms Paměť: 0.188 MB / 4.16 MB Application: afterRenderComponent com_jevents
Čas: 1.24 ms / 166.31 ms Paměť: 0.007 MB / 4.17 MB Application: afterDispatch
Čas: 2.80 ms / 169.11 ms Paměť: 0.025 MB / 4.19 MB Application: beforeRenderModule mod_menu (Hlavní nabídka)
Čas: 3.60 ms / 172.71 ms Paměť: 0.190 MB / 4.38 MB Application: afterRenderModule mod_menu (Hlavní nabídka)
Čas: 0.03 ms / 172.74 ms Paměť: 0.000 MB / 4.38 MB Application: beforeRenderModule mod_login (Přihlášení)
Čas: 3.21 ms / 175.95 ms Paměť: 0.022 MB / 4.40 MB Application: afterRenderModule mod_login (Přihlášení)
Čas: 0.06 ms / 176.01 ms Paměť: 0.003 MB / 4.40 MB Application: beforeRenderModule mod_search (Vyhledavání)
Čas: 2.51 ms / 178.51 ms Paměť: 0.015 MB / 4.42 MB Application: afterRenderModule mod_search (Vyhledavání)
Čas: 6.49 ms / 185.01 ms Paměť: 0.488 MB / 4.90 MB Application: afterRender
Celkem dotazů do databáze: 41.33 ms
5,34 MB (5.596.504 Bytů)
39 zaznamenaných dotazů 41.33 ms
- Čas pro dotazy: 0.48 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 1.039 MB Vráceno řádků: 0
SELECT `session_id`
FROM `j38_session`
WHERE `session_id` = X'6a3261696b6d7130746e616f6a68767175706a68686670377536'
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.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 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:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 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.47 ms Po posledním dotazu: 0.10 ms Dotaz paměti: 0.004 MB Paměť před dotazem: 1.045 MB
INSERT INTO `j38_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6a3261696b6d7130746e616f6a68767175706a68686670377536', 1, 1714032396, 0, '', 0)VYSVĚTLENÍ není možné pro dotaz: INSERT INTO `j38_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6a3261696b6d7130746e616f6a68767175706a68686670377536', 1, 1714032396, 0, '', 0)Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms update 0.09 ms Waiting for query cache lock 0.01 ms update 0.01 ms end 0.00 ms query end 0.04 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:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 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.83 ms Po posledním dotazu: 2.06 ms Dotaz paměti: 0.040 MB Paměť před dotazem: 1.076 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.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 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.01 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í v řá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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.52 ms Po posledním dotazu: 1.81 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 1.121 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.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.03 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.03 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:321 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.78 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 1.133 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.08 ms checking permissions 0.01 ms checking permissions 0.04 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.03 ms closing tables 0.04 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: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:321 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 1.93 ms Po posledním dotazu: 0.31 ms Dotaz paměti: 0.031 MB Paměť před dotazem: 1.154 MB Vráceno řádků: 127
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 140 0.48 Using index condition; Using where; Použití filesort Status Duration starting 0.09 ms checking permissions 0.02 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.07 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 1.17 ms end 0.03 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:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Stejné jako volání v řá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:359 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.62 ms Po posledním dotazu: 7.87 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 1.463 MB Vráceno řádků: 1
SELECT `enabled`
FROM `j38_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'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 element_clientid 402 const 1 10.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/plugins/system/backuponupdate/backuponupdate.php:36 7 require_once JROOT/plugins/system/backuponupdate/backuponupdate.php JROOT/libraries/src/Plugin/PluginHelper.php:253 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.53 ms Po posledním dotazu: 9.72 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 1.650 MB Vráceno řádků: 1
SELECT `lastupdate`
FROM `j38_ak_storage`
WHERE `tag` = 'akeebaupdatecheck_lastrun'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_ak_storage NULL const PRIMARY PRIMARY 402 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.02 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.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 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/akeebaupdatecheck/akeebaupdatecheck.php:81 8 plgSystemAkeebaupdatecheck->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 2.29 ms Po posledním dotazu: 3.13 ms Dotaz paměti: 0.107 MB Paměť před dotazem: 1.689 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 176 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.12 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 1.32 ms end 0.01 ms query end 0.01 ms closing tables 0.01 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í v řá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:76 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:131 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 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:64 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:491 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:1073 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.59 ms Po posledním dotazu: 9.62 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 2.069 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.05 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.09 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.03 ms cleaning up 0.01 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í v řá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:1130 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.56 ms Po posledním dotazu: 0.20 ms Dotaz paměti: 0.005 MB Paměť před dotazem: 2.059 MB
UPDATE `j38_extensions`
SET `params` = '{\"mediaversion\":\"ecf17977bf1a102e6b98f232f734974b\"}'
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.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.08 ms updating 0.07 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.05 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/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:1130 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.59 ms Po posledním dotazu: 1.40 ms Dotaz paměti: 0.019 MB Paměť před dotazem: 2.120 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.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.08 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.86 ms Po posledním dotazu: 0.33 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 2.132 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.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms executing 0.01 ms Sending data 0.23 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 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 2.28 ms Po posledním dotazu: 20.66 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 2.694 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.11 ms checking permissions 0.01 ms Opening tables 0.53 ms init 0.17 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.30 ms preparing 0.02 ms executing 0.01 ms Sending data 0.72 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 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_jevents/libraries/helper.php:2403 11 JEVHelper::isAdminUser() JROOT/components/com_jevents/libraries/helper.php:2485 10 JEVHelper::getAid() JROOT/components/com_jevents/libraries/datamodel.php:38 9 JEventsDataModel->__construct() JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:36 8 AdminIcalrepeatController->__construct() JROOT/components/com_jevents/controllers/icalrepeat.php:20 7 ICalRepeatController->__construct() JROOT/components/com_jevents/jevents.php:249 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.93 ms Po posledním dotazu: 2.69 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 2.900 MB Vráceno řádků: 1
SELECT `id`
FROM `j38_finder_types`
WHERE `title` = 'Event'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_finder_types NULL const title title 402 const 1 100.00 Using index Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.44 ms init 0.02 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 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:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729 13 FinderIndexerAdapter->getTypeId() JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142 12 FinderIndexerAdapter->__construct() JROOT/plugins/finder/jevents/jevents.php:81 11 plgFinderJEvents->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 10 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 9 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:40 8 AdminIcalrepeatController->__construct() JROOT/components/com_jevents/controllers/icalrepeat.php:20 7 ICalRepeatController->__construct() JROOT/components/com_jevents/jevents.php:249 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.49 ms Po posledním dotazu: 2.85 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 3.064 MB Vráceno řádků: 1
SELECT `id`
FROM `j38_finder_types`
WHERE `title` = 'Tag'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_finder_types NULL const title title 402 const 1 100.00 Using index Status Duration starting 0.06 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 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729 12 FinderIndexerAdapter->getTypeId() JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142 11 FinderIndexerAdapter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 10 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 9 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:40 8 AdminIcalrepeatController->__construct() JROOT/components/com_jevents/controllers/icalrepeat.php:20 7 ICalRepeatController->__construct() JROOT/components/com_jevents/jevents.php:249 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.46 ms Po posledním dotazu: 1.04 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 3.107 MB Vráceno řádků: 1
SELECT `id`
FROM `j38_finder_types`
WHERE `title` = 'Category'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_finder_types NULL const title title 402 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 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729 12 FinderIndexerAdapter->getTypeId() JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142 11 FinderIndexerAdapter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 10 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 9 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:40 8 AdminIcalrepeatController->__construct() JROOT/components/com_jevents/controllers/icalrepeat.php:20 7 ICalRepeatController->__construct() JROOT/components/com_jevents/jevents.php:249 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.47 ms Po posledním dotazu: 1.03 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 3.156 MB Vráceno řádků: 1
SELECT `id`
FROM `j38_finder_types`
WHERE `title` = 'Contact'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_finder_types NULL const title title 402 const 1 100.00 Using index 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 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 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729 12 FinderIndexerAdapter->getTypeId() JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142 11 FinderIndexerAdapter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 10 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 9 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:40 8 AdminIcalrepeatController->__construct() JROOT/components/com_jevents/controllers/icalrepeat.php:20 7 ICalRepeatController->__construct() JROOT/components/com_jevents/jevents.php:249 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.46 ms Po posledním dotazu: 0.95 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 3.204 MB Vráceno řádků: 1
SELECT `id`
FROM `j38_finder_types`
WHERE `title` = 'Article'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_finder_types NULL const title title 402 const 1 100.00 Using index 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 optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729 12 FinderIndexerAdapter->getTypeId() JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142 11 FinderIndexerAdapter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 10 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 9 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:40 8 AdminIcalrepeatController->__construct() JROOT/components/com_jevents/controllers/icalrepeat.php:20 7 ICalRepeatController->__construct() JROOT/components/com_jevents/jevents.php:249 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.45 ms Po posledním dotazu: 0.92 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 3.243 MB Vráceno řádků: 1
SELECT `id`
FROM `j38_finder_types`
WHERE `title` = 'News Feed'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_finder_types NULL const title title 402 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 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729 12 FinderIndexerAdapter->getTypeId() JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142 11 FinderIndexerAdapter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 10 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 9 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:40 8 AdminIcalrepeatController->__construct() JROOT/components/com_jevents/controllers/icalrepeat.php:20 7 ICalRepeatController->__construct() JROOT/components/com_jevents/jevents.php:249 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.54 ms Po posledním dotazu: 0.89 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 3.284 MB Vráceno řádků: 1
SELECT `id`
FROM `j38_finder_types`
WHERE `title` = 'Web Link'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_finder_types NULL const title title 402 const 1 100.00 Using index Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 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 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729 12 FinderIndexerAdapter->getTypeId() JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142 11 FinderIndexerAdapter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 10 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 9 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:40 8 AdminIcalrepeatController->__construct() JROOT/components/com_jevents/controllers/icalrepeat.php:20 7 ICalRepeatController->__construct() JROOT/components/com_jevents/jevents.php:249 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 1.51 ms Po posledním dotazu: 4.51 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 3.435 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.04 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.32 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.01 ms removing tmp table 0.07 ms closing tables 0.01 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/libraries/joomla/database/driver/mysqli.php:445 18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 16 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_jevents/tables/jevuser.php:69 15 TableUser->__construct() JROOT/components/com_jevents/libraries/helper.php:2343 14 JEVHelper::getAuthorisedUser() JROOT/components/com_jevents/libraries/helper.php:1727 13 JEVHelper::isEventPublisher() JROOT/components/com_jevents/libraries/dbmodel.php:3237 12 JEventsDBModel->listEventsById() JROOT/components/com_jevents/libraries/datamodel.php:724 11 JEventsDataModel->getEventData() JROOT/components/com_jevents/views/flat/icalevent/view.html.php:36 10 flatViewICalevent->detail() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/icalrepeat.php:151 8 ICalRepeatController->detail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:299 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 1.10 ms Po posledním dotazu: 2.16 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 3.488 MB Vráceno řádků: 4Duplicitní dotazy: #24
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-04-25 08:06:36')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-25 08:06:36')
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.85 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.12 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.08 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.05 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.28 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 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() Stejné jako volání v řádku níže. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 18 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 17 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:334 16 Joomla\CMS\Helper\ModuleHelper::_load() JROOT/components/com_jevents/libraries/jevmodulehelper.php:22 15 JevModuleHelper::getVisibleModules() JROOT/components/com_jevents/libraries/filters.php:54 14 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:200 13 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:3263 12 JEventsDBModel->listEventsById() JROOT/components/com_jevents/libraries/datamodel.php:724 11 JEventsDataModel->getEventData() JROOT/components/com_jevents/views/flat/icalevent/view.html.php:36 10 flatViewICalevent->detail() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/icalrepeat.php:151 8 ICalRepeatController->detail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:299 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 1.09 ms Po posledním dotazu: 0.81 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 3.509 MB Vráceno řádků: 4Duplicitní dotazy: #23
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-04-25 08:06:36')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-25 08:06:36')
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.85 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.12 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.08 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.05 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.25 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() Stejné jako volání v řádku níže. 21 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 20 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 19 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 18 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:37 17 Joomla\CMS\Helper\ModuleHelper::getModule() JROOT/components/com_jevents/libraries/filters.php:307 16 jevFilter->__construct() JROOT/components/com_jevents/libraries/filters/Justmine.php:44 15 jevJustmineFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:142 14 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:200 13 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:3263 12 JEventsDBModel->listEventsById() JROOT/components/com_jevents/libraries/datamodel.php:724 11 JEventsDataModel->getEventData() JROOT/components/com_jevents/views/flat/icalevent/view.html.php:36 10 flatViewICalevent->detail() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/icalrepeat.php:151 8 ICalRepeatController->detail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:299 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 1.56 ms Po posledním dotazu: 1.39 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 3.526 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.41 ms init 0.08 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.25 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 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 16 Joomla\CMS\Categories\Categories->_load() JROOT/components/com_jevents/helpers/category.php:47 15 JEventsCategories->_load() JROOT/libraries/src/Categories/Categories.php:184 14 Joomla\CMS\Categories\Categories->get() JROOT/components/com_jevents/libraries/dbmodel.php:77 13 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/dbmodel.php:3270 12 JEventsDBModel->listEventsById() JROOT/components/com_jevents/libraries/datamodel.php:724 11 JEventsDataModel->getEventData() JROOT/components/com_jevents/views/flat/icalevent/view.html.php:36 10 flatViewICalevent->detail() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/icalrepeat.php:151 8 ICalRepeatController->detail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:299 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.69 ms Po posledním dotazu: 0.39 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 3.628 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.11 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 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 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 14 JDatabaseDriver->loadColumn() JROOT/components/com_jevents/libraries/dbmodel.php:186 13 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/dbmodel.php:3270 12 JEventsDBModel->listEventsById() JROOT/components/com_jevents/libraries/datamodel.php:724 11 JEventsDataModel->getEventData() JROOT/components/com_jevents/views/flat/icalevent/view.html.php:36 10 flatViewICalevent->detail() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/icalrepeat.php:151 8 ICalRepeatController->detail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:299 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 2.85 ms Po posledním dotazu: 0.08 ms Dotaz paměti: 0.040 MB Paměť před dotazem: 3.634 MB Vráceno řádků: 1
SELECT ev.*, ev.state as published, rpt.*, rr.*, det.* , ev.created as created , 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 , ev.state as state
FROM (j38_jevents_vevent as ev )
INNER JOIN j38_jevents_repetition as rpt
ON rpt.eventid = ev.ev_id
INNER JOIN j38_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN j38_jevents_rrule as rr
ON rr.eventid = ev.ev_id
INNER JOIN j38_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
WHERE ev.catid IN(-1,175,176,177,178,179)
AND ev.access IN (1,1)
AND icsf.access IN (1,1)
AND rpt.rp_id = '50'
GROUP BY rpt.rp_idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rpt NULL const PRIMARY,eventid,eventstart,eventend,eventdetail PRIMARY 4 const 1 100.00 NULL 1 SIMPLE det NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE ev NULL const PRIMARY,icsid,evaccess PRIMARY 4 const 1 100.00 NULL 1 SIMPLE icsf NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE rr NULL ref eventid eventid 4 const 1 100.00 NULL Status Duration starting 0.21 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.66 ms init 0.11 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.16 ms preparing 0.06 ms executing 0.01 ms Sending data 0.14 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:3316 12 JEventsDBModel->listEventsById() JROOT/components/com_jevents/libraries/datamodel.php:724 11 JEventsDataModel->getEventData() JROOT/components/com_jevents/views/flat/icalevent/view.html.php:36 10 flatViewICalevent->detail() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/icalrepeat.php:151 8 ICalRepeatController->detail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:299 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.94 ms Po posledním dotazu: 0.56 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 3.689 MB Vráceno řádků: 0
SELECT *, summary as title, description as content
FROM j38_jevents_translation
WHERE evdet_id IN(50)
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 ref evdet_id,langdetail evdet_id 4 const 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.41 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 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 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:2691 13 JEventsDBModel::translateEvents() JROOT/components/com_jevents/libraries/dbmodel.php:3338 12 JEventsDBModel->listEventsById() JROOT/components/com_jevents/libraries/datamodel.php:724 11 JEventsDataModel->getEventData() JROOT/components/com_jevents/views/flat/icalevent/view.html.php:36 10 flatViewICalevent->detail() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/icalrepeat.php:151 8 ICalRepeatController->detail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:299 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 1.38 ms Po posledním dotazu: 0.27 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 3.687 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.02 ms checking permissions 0.01 ms Opening tables 0.55 ms init 0.07 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.06 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.03 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/components/com_jevents/libraries/helper.php:2278 13 JEVHelper::getContact() JROOT/components/com_jevents/libraries/jeventshtml.php:635 12 JEventsHTML::getUserMailtoLink() JROOT/components/com_jevents/libraries/datamodel.php:756 11 JEventsDataModel->getEventData() JROOT/components/com_jevents/views/flat/icalevent/view.html.php:36 10 flatViewICalevent->detail() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/icalrepeat.php:151 8 ICalRepeatController->detail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:299 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.56 ms Po posledním dotazu: 4.84 ms Dotaz paměti: 0.006 MB Paměť před dotazem: 3.812 MB
UPDATE j38_jevents_vevdetail
SET hits=(hits+1)
WHERE evdet_id='50'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE j38_jevents_vevdetail NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.04 ms updating 0.07 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 0.05 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 13 JDatabaseDriverMysqli->execute() JROOT/components/com_jevents/libraries/jicaleventdb.php:831 12 jIcalEventDB->updateHits() JROOT/components/com_jevents/libraries/datamodel.php:846 11 JEventsDataModel->getEventData() JROOT/components/com_jevents/views/flat/icalevent/view.html.php:36 10 flatViewICalevent->detail() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/icalrepeat.php:151 8 ICalRepeatController->detail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:299 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.71 ms Po posledním dotazu: 3.46 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 3.913 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.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:27 16 DefaultLoadedFromTemplate() JROOT/components/com_jevents/views/default/abstract/abstract.php:160 15 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php:37 14 include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php:5 12 include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.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:92 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/icalrepeat.php:151 8 ICalRepeatController->detail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:299 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.98 ms Po posledním dotazu: 0.06 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 3.925 MB Vráceno řádků: 0
SELECT *
FROM j38_jev_defaults
WHERE state=1
AND name= 'icalevent.detail_body'
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.06 ms checking permissions 0.01 ms Opening tables 0.33 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.00 ms Sending data 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:49 16 DefaultLoadedFromTemplate() JROOT/components/com_jevents/views/default/abstract/abstract.php:160 15 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php:37 14 include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php:5 12 include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.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:92 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/icalrepeat.php:151 8 ICalRepeatController->detail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:299 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 2.59 ms Po posledním dotazu: 0.75 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 3.952 MB Vráceno řádků: 8
SELECT `id`,`name`,`rules`,`parent_id`
FROM `j38_assets`
WHERE `name` LIKE 'com_jevents.%' OR `name` = 'com_jevents' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_assets NULL ALL idx_asset_name,idx_parent_id MOHL BY BÝT POUŽIT NO INDEX KEY NULL NULL 1974 20.69 Using where Status Duration starting 0.06 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.09 ms preparing 0.02 ms executing 0.00 ms Sending data 2.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 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 23 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 22 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 21 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 20 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 19 Joomla\CMS\User\User->authorise() JROOT/components/com_jevents/libraries/helper.php:2708 18 JEVHelper::authoriseCategories() JROOT/components/com_jevents/libraries/helper.php:2191 17 JEVHelper::canDeleteEvent() JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:825 16 DefaultLoadedFromTemplate() JROOT/components/com_jevents/views/default/abstract/abstract.php:160 15 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php:37 14 include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php:5 12 include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.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:92 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/icalrepeat.php:151 8 ICalRepeatController->detail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:299 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.77 ms Po posledním dotazu: 0.99 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 3.988 MB Vráceno řádků: 0
SELECT rpt.*,det.summary as title , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
FROM j38_jevents_repetition as rpt
LEFT JOIN j38_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
WHERE rpt.eventid=50
AND rpt.rp_id <> 50
AND rpt.startrepeat<='2019-10-19 08:00:00'
ORDER BY rpt.startrepeat DESC
limit 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rpt NULL range PRIMARY,eventid,eventstart,eventend,startrepeat,startend eventstart 9 NULL 1 100.00 Using index condition 1 SIMPLE det NULL eq_ref PRIMARY PRIMARY 4 zupajihoceska3.rpt.eventdetail_id 1 100.00 NULL Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.04 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:1662 20 JDatabaseDriver->loadObject() JROOT/components/com_jevents/libraries/jicaleventrepeat.php:415 19 jIcalEventRepeat->getAdjacentRepeats() JROOT/components/com_jevents/libraries/jicaleventrepeat.php:378 18 jIcalEventRepeat->prevRepeat() JROOT/components/com_jevents/libraries/jicaleventrepeat.php:327 17 jIcalEventRepeat->previousnextLinks() JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1298 16 DefaultLoadedFromTemplate() JROOT/components/com_jevents/views/default/abstract/abstract.php:160 15 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php:37 14 include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php:5 12 include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.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:92 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/icalrepeat.php:151 8 ICalRepeatController->detail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:299 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.72 ms Po posledním dotazu: 0.05 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 3.998 MB Vráceno řádků: 0
SELECT rpt.*,det.summary as title, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
FROM j38_jevents_repetition as rpt
LEFT JOIN j38_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
WHERE rpt.eventid=50
AND rpt.rp_id <> 50
AND rpt.startrepeat>='2019-10-19 08:00:00'
ORDER BY rpt.startrepeat ASC
limit 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rpt NULL range PRIMARY,eventid,eventstart,eventend,startrepeat,startend eventstart 9 NULL 1 100.00 Using index condition 1 SIMPLE det NULL eq_ref PRIMARY PRIMARY 4 zupajihoceska3.rpt.eventdetail_id 1 100.00 NULL Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.04 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 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 20 JDatabaseDriver->loadObject() JROOT/components/com_jevents/libraries/jicaleventrepeat.php:431 19 jIcalEventRepeat->getAdjacentRepeats() JROOT/components/com_jevents/libraries/jicaleventrepeat.php:378 18 jIcalEventRepeat->prevRepeat() JROOT/components/com_jevents/libraries/jicaleventrepeat.php:327 17 jIcalEventRepeat->previousnextLinks() JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1298 16 DefaultLoadedFromTemplate() JROOT/components/com_jevents/views/default/abstract/abstract.php:160 15 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php:37 14 include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php:5 12 include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.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:92 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/icalrepeat.php:151 8 ICalRepeatController->detail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:299 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 1.65 ms Po posledním dotazu: 1.99 ms Dotaz paměti: 0.035 MB Paměť před dotazem: 3.967 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.17 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 Opening tables 0.47 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.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms Sending data 0.12 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.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 23 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 22 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 21 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 20 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:312 19 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:11 18 DefaultLoadModules() JROOT/components/com_jevents/views/default/abstract/abstract.php:160 17 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:10 16 FlatViewHelperHeader16() JROOT/components/com_jevents/views/default/abstract/abstract.php:160 15 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:5 14 FlatViewHelperHeader() JROOT/components/com_jevents/views/default/abstract/abstract.php:160 13 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php:8 12 include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.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:92 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/icalrepeat.php:151 8 ICalRepeatController->detail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:299 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 2.17 ms Po posledním dotazu: 2.73 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 4.041 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.18 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.81 ms init 0.07 ms System lock 0.03 ms optimizing 0.03 ms statistics 0.16 ms preparing 0.05 ms Creating tmp table 0.06 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.24 ms Creating sort index 0.04 ms end 0.02 ms query end 0.01 ms removing tmp table 0.05 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 26 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 25 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 24 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 23 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 22 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 21 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 20 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 19 JEventDispatcher->trigger() JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:19 18 DefaultLoadModules() JROOT/components/com_jevents/views/default/abstract/abstract.php:160 17 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:10 16 FlatViewHelperHeader16() JROOT/components/com_jevents/views/default/abstract/abstract.php:160 15 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:5 14 FlatViewHelperHeader() JROOT/components/com_jevents/views/default/abstract/abstract.php:160 13 JEventsDefaultView->__call() JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php:8 12 include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.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:92 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/icalrepeat.php:151 8 ICalRepeatController->detail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:299 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 1.10 ms Po posledním dotazu: 26.47 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 4.462 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.05 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.49 ms Sending data 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 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:502 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:1050 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.85 ms Po posledním dotazu: 0.07 ms Dotaz paměti: 0.034 MB Paměť před dotazem: 4.488 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.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.32 ms end 0.01 ms query end 0.01 ms closing tables 0.02 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:1050 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
30 zaznamenaných typů dotazu, řazeno dle výskytu
VYBRANÉ tabulky:
7 × SELECT `id`
FROM `j38_finder_types`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `j38_assets`2 × 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_id2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j38_extensions`1 × SELECT c.id
FROM j38_categories AS c1 × 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 rpt.*,det.summary as title, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
FROM j38_jevents_repetition as rpt
LEFT JOIN j38_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id1 × SELECT rpt.*,det.summary as title , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
FROM j38_jevents_repetition as rpt
LEFT JOIN j38_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id1 × SELECT *
FROM j38_jev_defaults1 × SELECT a.id, a.parent_id
FROM j38_categories AS a1 × 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.catid1 × SELECT *, summary as title, description as content
FROM j38_jevents_translation1 × SELECT ev.*, ev.state as published, rpt.*, rr.*, det.* , ev.created as created , 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 , ev.state as state
FROM (j38_jevents_vevent as ev )
INNER JOIN j38_jevents_repetition as rpt
ON rpt.eventid = ev.ev_id
INNER JOIN j38_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN j38_jevents_rrule as rr
ON rr.eventid = ev.ev_id
INNER JOIN j38_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid1 × SELECT `session_id`
FROM `j38_session`1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `j38_categories` AS `c`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 `lastupdate`
FROM `j38_ak_storage`1 × SELECT `enabled`
FROM `j38_extensions`1 × 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
JINÉ tabulky:
1 × INSERT INTO `j38_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6a3261696b6d7130746e616f6a68767175706a68686670377536', 1, 1714032396, 0, '', 01 × UPDATE `j38_extensions`
SET `params` = '{\"mediaversion\":\"ecf17977bf1a102e6b98f232f734974b\"}'1 × SHOW FULL COLUMNS
FROM `j38_jev_users1 × UPDATE j38_jevents_vevdetail
SET hits=(hits+1)1 × SHOW FULL COLUMNS
FROM `j38_content1 × SHOW TABLE