Přihlášení
Napište nám
- Pozice:
- tajemník župy
-
-
Sokolská župa Jhočeská
Sokolský ostrov 1
-
České Budějovice
-
Jihočeský
-
37001
-
Česká republika
-
- 777 674 078
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": 1638935813,
"last": 1638935813,
"now": 1638935813
},
"token": "gUaAxHtuvluPR7XiZycCmccXkrZnB7Gu"
},
"registry": {
"com_contact": {
"contact": {
"data": {
"catid": "50"
}
}
},
"com_attachments": {
"current_url": "&return=aHR0cHM6Ly96dXBhamlob2Nlc2thLmN6L2luZGV4LnBocD9vcHRpb249Y29tX2NvbnRhY3Qmdmlldz1jb250YWN0JmlkPTk6a2FuY2VsYXItenVweSZjYXRpZD01MCZJdGVtaWQ9MTc4"
}
},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Čas
Paměť
Čas: 4.65 ms / 4.65 ms Paměť: 0.397 MB / 0.74 MB Application: afterLoad
Čas: 54.42 ms / 59.07 ms Paměť: 0.909 MB / 1.65 MB Application: afterInitialise
Čas: 6.72 ms / 65.79 ms Paměť: 0.389 MB / 2.04 MB Application: afterRoute
Čas: 3.66 ms / 69.45 ms Paměť: 0.057 MB / 2.10 MB Application: beforeRenderComponent com_contact
Čas: 7.06 ms / 76.51 ms Paměť: 0.261 MB / 2.36 MB Application: Before Access::preloadComponents (all components)
Čas: 1.54 ms / 78.06 ms Paměť: 0.060 MB / 2.42 MB Application: After Access::preloadComponents (all components)
Čas: 0.02 ms / 78.08 ms Paměť: 0.000 MB / 2.41 MB Application: Before Access::getAssetRules (id:7 name:com_contact)
Čas: 0.26 ms / 78.34 ms Paměť: 0.012 MB / 2.43 MB Application: After Access::getAssetRules (id:7 name:com_contact)
Čas: 25.77 ms / 104.11 ms Paměť: 0.646 MB / 3.07 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Čas: 0.05 ms / 104.16 ms Paměť: 0.012 MB / 3.08 MB Application: After Access::getAssetRules (id:1 name:root.1)
Čas: 18.79 ms / 122.95 ms Paměť: 0.245 MB / 3.33 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Čas: 0.02 ms / 122.97 ms Paměť: 0.002 MB / 3.33 MB Application: After Access::getAssetRules (id:1 name:root.1)
Čas: 67.95 ms / 190.92 ms Paměť: 0.605 MB / 3.94 MB Application: afterRenderComponent com_contact
Čas: 0.95 ms / 191.87 ms Paměť: 0.004 MB / 3.94 MB Application: afterDispatch
Čas: 3.26 ms / 195.13 ms Paměť: 0.038 MB / 3.98 MB Application: beforeRenderModule mod_menu (Hlavní nabídka)
Čas: 2.24 ms / 197.37 ms Paměť: 0.187 MB / 4.17 MB Application: afterRenderModule mod_menu (Hlavní nabídka)
Čas: 0.02 ms / 197.39 ms Paměť: 0.000 MB / 4.16 MB Application: beforeRenderModule mod_login (Přihlášení)
Čas: 0.98 ms / 198.37 ms Paměť: 0.018 MB / 4.18 MB Application: afterRenderModule mod_login (Přihlášení)
Čas: 0.05 ms / 198.42 ms Paměť: 0.004 MB / 4.18 MB Application: beforeRenderModule mod_search (Vyhledavání)
Čas: 1.30 ms / 199.73 ms Paměť: 0.013 MB / 4.20 MB Application: afterRenderModule mod_search (Vyhledavání)
Čas: 13.64 ms / 213.37 ms Paměť: 0.460 MB / 4.66 MB Application: afterRender
Celkem dotazů do databáze: 73.53 ms
5,11 MB (5.354.520 Bytů)
37 zaznamenaných dotazů 73.53 ms
- Čas pro dotazy: 0.69 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 1.031 MB Vráceno řádků: 0
SELECT `session_id`
FROM `j38_session`
WHERE `session_id` = X'6d6e3235716d683432653776386b3064656e6f39683474766936'
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.08 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.04 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php: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: 6.38 ms Po posledním dotazu: 0.07 ms Dotaz paměti: 0.004 MB Paměť před dotazem: 1.037 MB
INSERT INTO `j38_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6d6e3235716d683432653776386b3064656e6f39683474766936', 1, 1638935813, 0, '', 0)VYSVĚTLENÍ není možné pro dotaz: INSERT INTO `j38_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6d6e3235716d683432653776386b3064656e6f39683474766936', 1, 1638935813, 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.01 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php: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: 12.16 ms Po posledním dotazu: 1.04 ms Dotaz paměti: 0.040 MB Paměť před dotazem: 1.068 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.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 ms Sending data 0.27 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Stejné jako volání 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: 1.51 ms Po posledním dotazu: 0.81 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 1.112 MB Vráceno řádků: 4
SELECT id, rules
FROM `j38_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_viewlevels NULL ALL NULL MOHL BY BÝT POUŽIT NO INDEX KEY NULL NULL 4 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 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.08 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 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: 2.40 ms Po posledním dotazu: 0.08 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 1.124 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.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 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: 2.70 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.031 MB Paměť před dotazem: 1.145 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.04 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.92 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 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.60 ms Po posledním dotazu: 3.75 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 1.454 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.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.09 ms preparing 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.02 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/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.42 ms Po posledním dotazu: 4.08 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 1.641 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.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.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 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.23 ms Po posledním dotazu: 1.30 ms Dotaz paměti: 0.107 MB Paměť před dotazem: 1.680 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.10 ms checking permissions 0.01 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.08 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 1.31 ms end 0.02 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.60 ms Po posledním dotazu: 3.80 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 2.059 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.11 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 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.52 ms Po posledním dotazu: 0.09 ms Dotaz paměti: 0.005 MB Paměť před dotazem: 2.049 MB
UPDATE `j38_extensions`
SET `params` = '{\"mediaversion\":\"bc45e07eaf5ee3b82429ce6a19c7754a\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE j38_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.07 ms updating 0.06 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.07 ms closing tables 0.01 ms freeing items 0.02 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.49 ms Po posledním dotazu: 0.57 ms Dotaz paměti: 0.019 MB Paměť před dotazem: 2.073 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.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 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.75 ms Po posledním dotazu: 0.19 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 2.092 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.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms executing 0.00 ms Sending data 0.20 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 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: 1.41 ms Po posledním dotazu: 7.41 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 2.362 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.02 ms init 0.07 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.20 ms preparing 0.01 ms executing 0.00 ms Sending data 0.64 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 19 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/components/com_contact/models/contact.php:62 14 ContactModelContact->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_contact/models/contact.php:165 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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.01 ms Po posledním dotazu: 0.43 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 2.431 MB Vráceno řádků: 1
SELECT a.*,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM j38_contact_details AS a
LEFT JOIN j38_categories AS c
on c.id = a.catid
LEFT JOIN j38_categories as parent
ON parent.id = c.parent_id
WHERE a.id = 9
AND (a.published = 1 OR a.published =2)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-12-08 03:56:53')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-12-08 03:56:53')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY,idx_state PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.22 ms init 0.09 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_contact/models/contact.php:225 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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.81 ms Po posledním dotazu: 0.55 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 2.458 MB Vráceno řádků: 0
SELECT `m`.`tag_id`,`t`.*
FROM `j38_contentitem_tag_map` AS m
INNER JOIN `j38_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_contact.contact'
AND `m`.`content_item_id` = 9
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type MOHL BY BÝT POUŽIT NO INDEX KEY NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 zupajihoceska3.m.tag_id 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.16 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.00 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 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 13 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_contact/models/contact.php:255 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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.96 ms Po posledním dotazu: 4.45 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 2.608 MB Vráceno řádků: 16
SHOW FULL COLUMNS
FROM `j38_users`VYSVĚTLENÍ není možné pro dotaz: SHOW FULL COLUMNS FROM `j38_users`Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.23 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.03 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 Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.04 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 21 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 20 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 19 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:40 18 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:312 17 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_users/models/user.php:64 16 UsersModelUser->getTable() JROOT/libraries/src/MVC/Model/AdminModel.php:968 15 Joomla\CMS\MVC\Model\AdminModel->getItem() JROOT/administrator/components/com_users/models/user.php:89 14 UsersModelUser->getItem() JROOT/components/com_contact/models/contact.php:395 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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: 0.40 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 2.638 MB Vráceno řádků: 1Duplicitní dotazy: #22
SELECT *
FROM `j38_users`
WHERE `id` = 134id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_users NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:86 16 Joomla\CMS\Table\User->load() JROOT/libraries/src/MVC/Model/AdminModel.php:973 15 Joomla\CMS\MVC\Model\AdminModel->getItem() JROOT/administrator/components/com_users/models/user.php:89 14 UsersModelUser->getItem() JROOT/components/com_contact/models/contact.php:395 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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.29 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 2.649 MB Vráceno řádků: 4Duplicitní dotazy: #23
SELECT `g`.`id`,`g`.`title`
FROM `j38_usergroups` AS g
INNER JOIN `j38_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 134id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref PRIMARY PRIMARY 4 const 4 100.00 Using index 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 zupajihoceska3.m.group_id 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.46 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 17 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:111 16 Joomla\CMS\Table\User->load() JROOT/libraries/src/MVC/Model/AdminModel.php:973 15 Joomla\CMS\MVC\Model\AdminModel->getItem() JROOT/administrator/components/com_users/models/user.php:89 14 UsersModelUser->getItem() JROOT/components/com_contact/models/contact.php:395 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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.42 ms Po posledním dotazu: 14.32 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 3.063 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_users.user'
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.21 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.07 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.17 ms preparing 0.05 ms Creating tmp table 0.06 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.25 ms Creating sort index 0.05 ms end 0.01 ms query end 0.01 ms removing tmp table 0.06 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 18 FieldsHelper::getFields() JROOT/administrator/components/com_fields/helpers/fields.php:285 17 FieldsHelper::prepareForm() JROOT/plugins/system/fields/fields.php:305 16 PlgSystemFields->onContentPrepareForm() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:411 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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.13 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 3.087 MB Vráceno řádků: 1
SELECT COUNT(*)
FROM j38_privacy_consents
WHERE user_id = 134
AND subject = 'PLG_SYSTEM_PRIVACYCONSENT_SUBJECT'
AND state = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_privacy_consents NULL ref idx_user_id idx_user_id 4 const 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.48 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 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.02 ms freeing items 0.03 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/plugins/system/privacyconsent/privacyconsent.php:423 17 PlgSystemPrivacyconsent->isUserConsented() JROOT/plugins/system/privacyconsent/privacyconsent.php:95 16 PlgSystemPrivacyconsent->onContentPrepareForm() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:411 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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.91 ms Po posledním dotazu: 14.46 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 3.296 MB Vráceno řádků: 1Duplicitní dotazy: #18
SELECT *
FROM `j38_users`
WHERE `id` = 134id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_users NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.02 ms Opening tables 0.02 ms init 0.04 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.01 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 21 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:86 20 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:883 19 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 18 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 17 Joomla\CMS\User\User::getInstance() JROOT/plugins/system/actionlogs/actionlogs.php:166 16 PlgSystemActionLogs->onContentPrepareData() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:414 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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.03 ms Po posledním dotazu: 0.10 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 3.309 MB Vráceno řádků: 4Duplicitní dotazy: #19
SELECT `g`.`id`,`g`.`title`
FROM `j38_usergroups` AS g
INNER JOIN `j38_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 134id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref PRIMARY PRIMARY 4 const 4 100.00 Using index 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 zupajihoceska3.m.group_id 1 100.00 NULL Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.02 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.03 ms # Volající Soubor a číslo řádku 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 21 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:111 20 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:883 19 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 18 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 17 Joomla\CMS\User\User::getInstance() JROOT/plugins/system/actionlogs/actionlogs.php:166 16 PlgSystemActionLogs->onContentPrepareData() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:414 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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.15 ms Po posledním dotazu: 0.08 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 3.319 MB Vráceno řádků: 12
SELECT b.id
FROM j38_user_usergroup_map AS map
LEFT JOIN j38_usergroups AS a
ON a.id = map.group_id
LEFT JOIN j38_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE map.user_id = 134id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE map NULL ref PRIMARY PRIMARY 4 const 4 100.00 Using index 1 SIMPLE a NULL eq_ref PRIMARY PRIMARY 4 zupajihoceska3.map.group_id 1 100.00 NULL 1 SIMPLE b NULL ALL idx_usergroup_nested_set_lookup MOHL BY BÝT POUŽIT NO INDEX KEY NULL NULL 6 100.00 Range checked for each record (index map: 0x10) Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.04 ms executing 0.01 ms Sending data 0.15 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 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 20 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 19 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/User/User.php:480 18 Joomla\CMS\User\User->getAuthorisedGroups() JROOT/libraries/src/User/User.php:386 17 Joomla\CMS\User\User->authorise() JROOT/plugins/system/actionlogs/actionlogs.php:166 16 PlgSystemActionLogs->onContentPrepareData() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:414 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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.67 ms Po posledním dotazu: 0.09 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 3.328 MB Vráceno řádků: 11
SELECT profile_key, profile_value
FROM j38_user_profiles
WHERE user_id = 134
AND profile_key LIKE 'profile.%'
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_user_profiles NULL range idx_user_id_profile_key idx_user_id_profile_key 406 NULL 11 100.00 Using where; Použití filesort Status Duration starting 0.06 ms checking permissions 0.02 ms Opening tables 0.59 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.27 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1811 17 JDatabaseDriver->loadRowList() JROOT/plugins/user/profile/profile.php:92 16 PlgUserProfile->onContentPrepareData() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:414 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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.47 ms Po posledním dotazu: 4.31 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 3.440 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_contact.mail'
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.24 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 Opening tables 0.06 ms init 0.14 ms System lock 0.04 ms optimizing 0.04 ms statistics 0.25 ms preparing 0.11 ms Creating tmp table 0.10 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.36 ms Creating sort index 0.09 ms end 0.01 ms query end 0.02 ms removing tmp table 0.10 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.03 ms # Volající Soubor a číslo řádku 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 20 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 19 FieldsHelper::getFields() JROOT/administrator/components/com_fields/helpers/fields.php:285 18 FieldsHelper::prepareForm() JROOT/plugins/system/fields/fields.php:305 17 PlgSystemFields->onContentPrepareForm() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/src/MVC/Model/FormModel.php:321 14 Joomla\CMS\MVC\Model\FormModel->preprocessForm() JROOT/libraries/src/MVC/Model/FormModel.php:242 13 Joomla\CMS\MVC\Model\FormModel->loadForm() JROOT/components/com_contact/models/contact.php:82 12 ContactModelContact->getForm() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:83 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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.85 ms Po posledním dotazu: 1.66 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 3.499 MB Vráceno řádků: 1
SELECT a.*,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM `j38_contact_details` AS a
LEFT JOIN j38_categories AS c
ON c.id = a.catid
LEFT JOIN j38_users AS ua
ON ua.id = a.created_by
LEFT JOIN j38_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1)
AND a.catid = 50
AND c.access IN (1,1)
AND a.published = 1
ORDER BY a.name ascid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 Použití filesort 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_state 1 const 1 11.11 Using index condition; Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 zupajihoceska3.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 zupajihoceska3.a.modified_by 1 100.00 Using where; Using index Status Duration starting 0.18 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.14 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.22 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.06 ms Creating sort index 0.24 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.03 ms # Volající Soubor a číslo řádku 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 12 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_contact/models/category.php:91 11 ContactModelCategory->getItems() JROOT/components/com_contact/views/contact/view.html.php:125 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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.36 ms Po posledním dotazu: 0.10 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 3.520 MB Vráceno řádků: 0
SELECT `m`.`tag_id`,`t`.*
FROM `j38_contentitem_tag_map` AS m
INNER JOIN `j38_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_contact.contact'
AND `m`.`content_item_id` = 9
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type MOHL BY BÝT POUŽIT NO INDEX KEY NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 zupajihoceska3.m.tag_id 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.02 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.12 ms preparing 0.05 ms executing 0.01 ms Sending data 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_contact/models/category.php:107 11 ContactModelCategory->getItems() JROOT/components/com_contact/views/contact/view.html.php:125 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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.10 ms Po posledním dotazu: 2.04 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 3.548 MB Vráceno řádků: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `j38_categories` AS `s`
INNER JOIN `j38_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_contact' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 50
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Použití filesort 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right cat_idx 207 NULL 2 54.84 Using index condition; Using where Status Duration starting 0.19 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.09 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.18 ms preparing 0.05 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.17 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_contact/views/contact/view.html.php:304 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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.67 ms Po posledním dotazu: 0.23 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 3.563 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
LEFT JOIN `j38_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_contact.contact'
AND (fc.category_id IS NULL OR fc.category_id IN (50,0))
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 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 zupajihoceska3.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.19 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.12 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.24 ms preparing 0.05 ms Creating tmp table 0.07 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.23 ms Creating sort index 0.06 ms end 0.01 ms query end 0.01 ms removing tmp table 0.06 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 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_contact/views/contact/view.html.php:304 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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.08 ms Po posledním dotazu: 10.19 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 3.694 MB Vráceno řádků: 0
SELECT `m`.`tag_id`,`t`.*
FROM `j38_contentitem_tag_map` AS m
INNER JOIN `j38_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_contact.contact'
AND `m`.`content_item_id` = 9
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type MOHL BY BÝT POUŽIT NO INDEX KEY NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 zupajihoceska3.m.tag_id 1 100.00 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.04 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_contact/views/contact/view.html.php:350 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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.75 ms Po posledním dotazu: 1.70 ms Dotaz paměti: 0.033 MB Paměť před dotazem: 3.724 MB Vráceno řádků: 43
SHOW FULL COLUMNS
FROM `j38_contact_details`VYSVĚTLENÍ není možné pro dotaz: SHOW FULL COLUMNS FROM `j38_contact_details`Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.18 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.02 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms Sending data 0.22 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.06 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/libraries/joomla/database/driver/mysqli.php:445 16 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 15 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 14 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_contact/tables/contact.php:39 13 ContactTableContact->__construct() JROOT/libraries/src/Table/Table.php:312 12 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_contact/models/contact.php:628 11 ContactModelContact->hit() JROOT/components/com_contact/views/contact/view.html.php:368 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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.61 ms Po posledním dotazu: 1.00 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 3.793 MB Vráceno řádků: 1
SELECT *
FROM j38_contact_details
WHERE `id` = '9'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE j38_contact_details NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 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.02 ms # Volající Soubor a číslo řádku 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 13 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 12 Joomla\CMS\Table\Table->load() JROOT/components/com_contact/models/contact.php:629 11 ContactModelContact->hit() JROOT/components/com_contact/views/contact/view.html.php:368 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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.08 ms Dotaz paměti: 0.006 MB Paměť před dotazem: 3.800 MB
UPDATE j38_contact_details
SET `hits` = (`hits` + 1)
WHERE `id` = '9'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE j38_contact_details NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.03 ms Opening tables 0.03 ms init 0.03 ms System lock 0.06 ms updating 0.15 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.06 ms query end 0.07 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 13 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1245 12 Joomla\CMS\Table\Table->hit() JROOT/components/com_contact/models/contact.php:630 11 ContactModelContact->hit() JROOT/components/com_contact/views/contact/view.html.php:368 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.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.06 ms Po posledním dotazu: 29.60 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 3.980 MB Vráceno řádků: 4
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM j38_modules AS m
LEFT JOIN j38_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN j38_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-12-08 03:56:53')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-12-08 03:56:53')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 178 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.15 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.10 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.15 ms preparing 0.07 ms Sorting result 0.05 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.26 ms end 0.01 ms query end 0.01 ms closing tables 0.07 ms freeing items 0.04 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() Stejné jako volání v řádku níže. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:591 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/zupajihoceska.cz/index.php:36 7 require JROOT/templates/zupajihoceska.cz/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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: 1.50 ms Po posledním dotazu: 6.58 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 4.294 MB Vráceno řádků: 153
SHOW TABLES
VYSVĚTLENÍ není možné pro dotaz: SHOW TABLESStatus Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms checking permissions 0.51 ms Sending data 0.10 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.02 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 15 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php: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: 9.06 ms Po posledním dotazu: 0.07 ms Dotaz paměti: 0.034 MB Paměť před dotazem: 4.320 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.02 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 Sending data 0.30 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
31 zaznamenaných typů dotazu, řazeno dle výskytu
VYBRANÉ tabulky:
3 × SELECT `m`.`tag_id`,`t`.*
FROM `j38_contentitem_tag_map` AS m
INNER JOIN `j38_tags` AS t
ON `m`.`tag_id` = `t`.`id`2 × SELECT *
FROM `j38_users`2 × 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_id2 × SELECT `g`.`id`,`g`.`title`
FROM `j38_usergroups` AS g
INNER JOIN `j38_user_usergroup_map` AS m
ON m.group_id = g.id2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j38_extensions`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM j38_modules AS m
LEFT JOIN j38_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN j38_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM j38_contact_details1 × 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
LEFT JOIN `j38_fields_categories` AS fc
ON fc.field_id = a.id1 × 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 `s`
INNER JOIN `j38_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)1 × SELECT a.*,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM `j38_contact_details` AS a
LEFT JOIN j38_categories AS c
ON c.id = a.catid
LEFT JOIN j38_users AS ua
ON ua.id = a.created_by
LEFT JOIN j38_users AS uam
ON uam.id = a.modified_by1 × SELECT profile_key, profile_value
FROM j38_user_profiles1 × SELECT b.id
FROM j38_user_usergroup_map AS map
LEFT JOIN j38_usergroups AS a
ON a.id = map.group_id
LEFT JOIN j38_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT COUNT(*)
FROM j38_privacy_consents1 × SELECT `session_id`
FROM `j38_session`1 × SELECT a.*,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM j38_contact_details AS a
LEFT JOIN j38_categories AS c
on c.id = a.catid
LEFT JOIN j38_categories as parent
ON parent.id = c.parent_id1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `j38_assets`1 × SELECT id, home, template, s.params
FROM j38_template_styles as s
LEFT JOIN j38_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM j38_languages1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM j38_menu AS m
LEFT JOIN j38_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `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'6d6e3235716d683432653776386b3064656e6f39683474766936', 1, 1638935813, 0, '', 01 × UPDATE `j38_extensions`
SET `params` = '{\"mediaversion\":\"bc45e07eaf5ee3b82429ce6a19c7754a\"}'1 × SHOW FULL COLUMNS
FROM `j38_users1 × SHOW FULL COLUMNS
FROM `j38_contact_details1 × UPDATE j38_contact_details
SET `hits` = (`hits` + 1)1 × SHOW TABLE