Konzole ladění chyb Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1670454942,
"last": 1670454942,
"now": 1670454942
},
"token": "kgXZzsCsB09r0DluSTsAlf0wQnXsxtHV"
},
"registry": {
"jevents": {
"moduleid89": {
"shownEventIds": [],
"page": 0,
"firstEventDate": false
}
},
"published_fv_ses": "0"
},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Čas
Paměť
Čas: 27.56 ms / 27.56 ms Paměť: 1.990 MB / 2.33 MB Application: afterLoad
Čas: 54.93 ms / 82.49 ms Paměť: 3.866 MB / 6.20 MB Application: afterInitialise
Čas: 17.17 ms / 99.66 ms Paměť: 1.132 MB / 7.33 MB Application: afterRoute
Čas: 5.91 ms / 105.57 ms Paměť: 0.303 MB / 7.63 MB Application: beforeRenderComponent com_content
Čas: 6.72 ms / 112.29 ms Paměť: 0.447 MB / 8.08 MB Application: Before Access::preloadComponents (all components)
Čas: 1.36 ms / 113.64 ms Paměť: 0.065 MB / 8.15 MB Application: After Access::preloadComponents (all components)
Čas: 0.02 ms / 113.66 ms Paměť: -0.003 MB / 8.14 MB Application: Before Access::preloadPermissions (com_content)
Čas: 0.96 ms / 114.62 ms Paměť: 0.211 MB / 8.35 MB Application: After Access::preloadPermissions (com_content)
Čas: 0.02 ms / 114.64 ms Paměť: -0.011 MB / 8.34 MB Application: Before Access::getAssetRules (id:362 name:com_content.article.332)
Čas: 0.97 ms / 115.62 ms Paměť: 0.029 MB / 8.37 MB Application: After Access::getAssetRules (id:362 name:com_content.article.332)
Čas: 55.19 ms / 170.80 ms Paměť: 2.973 MB / 11.34 MB Application: afterRenderComponent com_content
Čas: 5.19 ms / 175.99 ms Paměť: 0.124 MB / 11.47 MB Application: afterDispatch
Čas: 6.25 ms / 182.24 ms Paměť: 0.778 MB / 12.25 MB Application: beforeRenderModule mod_phocagallery_image (Phoca Gallery Image Module)
Čas: 24.88 ms / 207.12 ms Paměť: 1.203 MB / 13.45 MB Application: afterRenderModule mod_phocagallery_image (Phoca Gallery Image Module)
Čas: 14.94 ms / 222.06 ms Paměť: 0.101 MB / 13.55 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Čas: 2.42 ms / 224.48 ms Paměť: 0.024 MB / 13.58 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Čas: 3.61 ms / 228.09 ms Paměť: 0.024 MB / 13.60 MB Application: beforeRenderModule mod_menu (Pro členy klubu)
Čas: 6.41 ms / 234.50 ms Paměť: 0.119 MB / 13.72 MB Application: afterRenderModule mod_menu (Pro členy klubu)
Čas: 0.29 ms / 234.79 ms Paměť: -0.020 MB / 13.70 MB Application: beforeRenderModule mod_jevents_latest (Nejbližší akce)
Čas: 19.66 ms / 254.45 ms Paměť: 1.403 MB / 15.10 MB Application: Before Access::getAssetRules (id:56 name:com_jevents)
Čas: 0.03 ms / 254.48 ms Paměť: 0.007 MB / 15.11 MB Application: After Access::getAssetRules (id:56 name:com_jevents)
Čas: 21.65 ms / 276.13 ms Paměť: 1.561 MB / 16.67 MB Application: afterRenderModule mod_jevents_latest (Nejbližší akce)
Čas: 0.68 ms / 276.80 ms Paměť: 0.028 MB / 16.70 MB Application: beforeRenderModule mod_vvisit_counter (Visitors Counter)
Čas: 12.62 ms / 289.42 ms Paměť: 1.036 MB / 17.73 MB Application: afterRenderModule mod_vvisit_counter (Visitors Counter)
Čas: 15.04 ms / 304.46 ms Paměť: 0.074 MB / 17.81 MB Application: beforeRenderModule mod_menu (Main Menu)
Čas: 7.97 ms / 312.43 ms Paměť: 0.103 MB / 17.91 MB Application: afterRenderModule mod_menu (Main Menu)
Čas: 5.11 ms / 317.54 ms Paměť: -0.627 MB / 17.28 MB Application: afterRender
Celkem dotazů do databáze: 26.06 ms
17,73 MB (18.587.432 Bytů)
33 zaznamenaných dotazů 26.06 ms
- Čas pro dotazy: 0.52 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 4.043 MB Vráceno řádků: 0
SELECT `data`
FROM `makac_session`
WHERE `session_id` = X'6566653737386336343863323530636634646561303530633532653936393633'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE makac_session const PRIMARY PRIMARY 194 const 1 Status Duration starting 0.06 ms checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Stejné jako volání na řádku níže. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Čas pro dotazy: 0.39 ms Po posledním dotazu: 2.06 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 4.150 MB Vráceno řádků: 0
SELECT `session_id`
FROM `makac_session`
WHERE `session_id` = X'6566653737386336343863323530636634646561303530633532653936393633'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE makac_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.02 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.02 ms updating status 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/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Čas pro dotazy: 0.44 ms Po posledním dotazu: 0.06 ms Dotaz paměti: 0.004 MB Paměť před dotazem: 4.156 MB
INSERT INTO `makac_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6566653737386336343863323530636634646561303530633532653936393633', 1, 1670454942, 0, '', 0)VYSVĚTLENÍ není možné pro dotaz: INSERT INTO `makac_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6566653737386336343863323530636634646561303530633532653936393633', 1, 1670454942, 0, '', 0)Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms init 0.01 ms update 0.08 ms Waiting for query cache lock 0.01 ms update 0.01 ms end 0.01 ms query end 0.06 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Čas pro dotazy: 0.59 ms Po posledním dotazu: 7.51 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 4.783 MB Vráceno řádků: 5
SELECT id, rules
FROM `makac_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE makac_viewlevels ALL NULL MOHL BY BÝT POUŽIT NO INDEX KEY NULL NULL 5 Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.07 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 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:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.50 ms Po posledním dotazu: 0.06 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 4.795 MB Vráceno řádků: 2
SELECT b.id
FROM makac_usergroups AS a
LEFT JOIN makac_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 Using where; Using index Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.01 ms Unlocking tables 0.04 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 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:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.59 ms Po posledním dotazu: 37.59 ms Dotaz paměti: 0.005 MB Paměť před dotazem: 7.352 MB
UPDATE `makac_extensions`
SET `params` = '{\"mediaversion\":\"957523b7a484af18f0628c3c4092e053\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'VYSVĚTLENÍ není možné pro dotaz: UPDATE `makac_extensions` SET `params` = '{\"mediaversion\":\"957523b7a484af18f0628c3c4092e053\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.07 ms updating 0.04 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 0.06 ms closing tables 0.01 ms Unlocking tables 0.03 ms freeing items 0.01 ms updating status 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:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 1.24 ms Po posledním dotazu: 11.04 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 8.086 MB Vráceno řádků: 42
SELECT `id`,`name`,`rules`,`parent_id`
FROM `makac_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','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_jce','com_jevents','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_metgis','com_modules','com_newsfeeds','com_phocacommander','com_phocadownload','com_phocagallery','com_phocamaps','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templateck','com_templates','com_users','com_weblinks','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE makac_assets ALL idx_asset_name MOHL BY BÝT POUŽIT NO INDEX KEY NULL NULL 350 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.04 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.04 ms executing 0.01 ms Sending data 0.57 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 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/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.76 ms Po posledním dotazu: 0.11 ms Dotaz paměti: 0.059 MB Paměť před dotazem: 8.143 MB Vráceno řádků: 243
SELECT `id`,`name`,`rules`,`parent_id`
FROM `makac_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE makac_assets ALL idx_asset_name,idx_parent_id MOHL BY BÝT POUŽIT NO INDEX KEY NULL NULL 350 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.02 ms init 0.02 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.01 ms Sending data 0.27 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.02 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/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 1.16 ms Po posledním dotazu: 2.38 ms Dotaz paměti: 0.032 MB Paměť před dotazem: 8.419 MB Vráceno řádků: 31
SHOW FULL COLUMNS
FROM `makac_content`VYSVĚTLENÍ není možné pro dotaz: SHOW FULL COLUMNS FROM `makac_content`Status Duration starting 0.05 ms checking permissions 0.02 ms closing tables 0.01 ms Opening tables 0.21 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.01 ms optimizing 0.03 ms statistics 0.01 ms preparing 0.02 ms executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms checking permissions 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms closing tables 0.01 ms executing 0.01 ms Sending data 0.08 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 Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.55 ms Po posledním dotazu: 4.72 ms Dotaz paměti: 0.005 MB Paměť před dotazem: 8.745 MB
UPDATE makac_content
SET `hits` = (`hits` + 1)
WHERE `id` = '332'VYSVĚTLENÍ není možné pro dotaz: UPDATE makac_content SET `hits` = (`hits` + 1) WHERE `id` = '332'Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.05 ms updating 0.07 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 0.09 ms closing tables 0.01 ms Unlocking tables 0.04 ms freeing items 0.01 ms updating status 0.04 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 1.17 ms Po posledním dotazu: 3.34 ms Dotaz paměti: 0.102 MB Paměť před dotazem: 8.917 MB Vráceno řádků: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM makac_content AS a
INNER JOIN makac_categories AS c
on c.id = a.catid
LEFT JOIN makac_users AS u
on u.id = a.created_by
LEFT JOIN makac_categories as parent
ON parent.id = c.parent_id
LEFT JOIN makac_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 332
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-12-07 23:15:42')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-12-07 23:15:42')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 unique row not found Status Duration starting 0.26 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 After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.08 ms optimizing 0.14 ms statistics 0.16 ms preparing 0.01 ms Unlocking tables 0.02 ms executing 0.01 ms Sending data 0.11 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.03 ms freeing items 0.01 ms updating status 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/components/com_content/models/article.php:151 13 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.82 ms Po posledním dotazu: 2.44 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 9.080 MB Vráceno řádků: 0
SELECT `m`.`tag_id`,`t`.*
FROM `makac_contentitem_tag_map` AS m
INNER JOIN `makac_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 332
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type MOHL BY BÝT POUŽIT NO INDEX KEY NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 d85662_model.m.tag_id 1 Using where Status Duration starting 0.20 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.04 ms optimizing 0.05 ms statistics 0.06 ms preparing 0.03 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms Unlocking tables 0.03 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.01 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_content/views/article/view.html.php:184 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 1.22 ms Po posledním dotazu: 16.00 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 10.135 MB Vráceno řádků: 3
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 `makac_categories` AS `s`
INNER JOIN `makac_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 138
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 Použití filesort 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right MOHL BY BÝT POUŽIT NO INDEX KEY NULL NULL 119 Using where Status Duration starting 0.23 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.05 ms optimizing 0.03 ms statistics 0.19 ms preparing 0.02 ms Unlocking tables 0.03 ms executing 0.01 ms Sorting result 0.19 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.03 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 1.29 ms Po posledním dotazu: 0.77 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 10.188 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 makac_fields AS a
LEFT JOIN `makac_languages` AS l
ON l.lang_code = a.language
LEFT JOIN makac_users AS uc
ON uc.id=a.checked_out
LEFT JOIN makac_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN makac_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN makac_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `makac_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (138,0,130))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Použití filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 d85662_model.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 d85662_model.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 d85662_model.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 d85662_model.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 d85662_model.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 d85662_model.a.id 1 Using where; Using index; Distinct Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.03 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 Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.02 ms Table lock 0.02 ms init 0.06 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.06 ms executing 0.01 ms Creating tmp table 0.27 ms Copying to tmp table 0.03 ms Sorting result 0.02 ms Sending data 0.04 ms end 0.01 ms removing tmp table 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.96 ms Po posledním dotazu: 27.67 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 11.620 MB Vráceno řádků: 12
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM makac_modules AS m
LEFT JOIN makac_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN makac_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 <= '2022-12-07 23:15:42')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-12-07 23:15:42')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 186 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 14 Using index condition; Using where; Použití filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 d85662_model.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 d85662_model.m.module,const 1 Using index condition; Using where Status Duration starting 0.12 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.06 ms optimizing 0.05 ms statistics 0.10 ms preparing 0.04 ms executing 0.01 ms Sorting result 0.14 ms Sending data 0.17 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.03 ms freeing items 0.01 ms updating status 0.02 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() Stejné jako volání na řá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:441 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 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:601 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/modelorlicko/index.php:37 7 require JROOT/templates/modelorlicko/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.66 ms Po posledním dotazu: 8.76 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 12.846 MB Vráceno řádků: 3
SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM makac_phocagallery_styles AS a
WHERE a.published = 1
ORDER BY a.type, a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL MOHL BY BÝT POUŽIT NO INDEX KEY NULL NULL 4 Using where; Použití filesort Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.02 ms optimizing 0.03 ms statistics 0.01 ms preparing 0.02 ms executing 0.01 ms Sorting result 0.04 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/render/renderfront.php:736 11 PhocaGalleryRenderFront::renderAllCSS() JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php:46 10 include JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:500 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.65 ms Po posledním dotazu: 11.75 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 13.067 MB Vráceno řádků: 1
SELECT cc.title AS text, cc.id AS id, cc.parent_id as parentid, cc.alias as alias, cc.access as access, cc.accessuserid as accessuserid
FROM makac_phocagallery_categories AS cc
WHERE cc.published = 1
AND cc.access IN (1,1,5)
AND cc.id IN (3)
ORDER BY cc.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cc const PRIMARY,idx_access PRIMARY 4 const 1 Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.03 ms System lock 0.01 ms Table lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.01 ms Unlocking tables 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.03 ms freeing items 0.01 ms updating status 0.03 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/modules/mod_phocagallery_image/mod_phocagallery_image.php:621 10 include JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:500 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.54 ms Po posledním dotazu: 0.64 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 13.130 MB Vráceno řádků: 1
SELECT cc.id AS idcat, a.id AS idimage
FROM makac_phocagallery_categories AS cc
LEFT JOIN makac_phocagallery AS a
ON a.catid = cc.id
WHERE a.published = 1
AND a.approved = 1
AND cc.published = 1
AND cc.id IN (3)
ORDER BY a.ordering ASC
LIMIT 0,1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cc const PRIMARY PRIMARY 4 const 1 Použití filesort 1 SIMPLE a ref catid catid 5 const,const 1 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms Unlocking tables 0.02 ms executing 0.01 ms Sorting result 0.03 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 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/modules/mod_phocagallery_image/mod_phocagallery_image.php:684 10 include JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:500 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.53 ms Po posledním dotazu: 0.09 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 13.138 MB Vráceno řádků: 1
SELECT cc.id, cc.alias as catalias, a.id, a.catid, a.title, a.alias, a.filename, a.description, a.extm, a.exts,a.extl, a.exto, a.extw, a.exth, a.extid,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
FROM makac_phocagallery_categories AS cc
LEFT JOIN makac_phocagallery AS a
ON a.catid = cc.id
WHERE a.id in (3942)
AND (cc.language IN ('cs-CZ','*')
AND a.language IN ('cs-CZ','*'))
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,catid PRIMARY 4 const 1 1 SIMPLE cc const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.04 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.01 ms Unlocking tables 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms freeing items 0.01 ms updating status 0.03 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/modules/mod_phocagallery_image/mod_phocagallery_image.php:710 10 include JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:500 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 1.10 ms Po posledním dotazu: 64.99 ms Dotaz paměti: 0.030 MB Paměť před dotazem: 16.455 MB Vráceno řádků: 18
SHOW FULL COLUMNS
FROM `makac_jev_users`VYSVĚTLENÍ není možné pro dotaz: SHOW FULL COLUMNS FROM `makac_jev_users`Status Duration starting 0.06 ms checking permissions 0.01 ms closing tables 0.01 ms Opening tables 0.22 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.03 ms After opening tables 0.01 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 closing tables 0.01 ms executing 0.01 ms Sending data 0.06 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 Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 22 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 21 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 20 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_jevents/tables/jevuser.php:75 19 TableUser->__construct() JROOT/components/com_jevents/libraries/helper.php:1615 18 JEVHelper::getAuthorisedUser() JROOT/components/com_jevents/libraries/helper.php:1470 17 JEVHelper::isEventCreator() JROOT/components/com_jevents/libraries/filters/Published.php:61 16 jevPublishedFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:180 15 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:251 14 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:1255 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35 11 ExtModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:500 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.83 ms Po posledním dotazu: 2.07 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 16.602 MB Vráceno řádků: 6
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `makac_categories` AS `c`
WHERE (c.extension='com_jevents' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c range cat_idx,idx_access cat_idx 207 NULL 8 Using index condition; Using where; Použití filesort Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.07 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.01 ms Sorting result 0.11 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 21 Joomla\CMS\Categories\Categories->_load() JROOT/components/com_jevents/helpers/category.php:53 20 JEventsCategories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/components/com_jevents/libraries/dbmodel.php:411 18 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/datamodel.php:1020 17 JEventsDataModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/filters/Category.php:47 16 jevCategoryFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:180 15 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:251 14 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:1255 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35 11 ExtModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:500 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.53 ms Po posledním dotazu: 0.11 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 16.638 MB Vráceno řádků: 5
SELECT c.id
FROM makac_categories AS c
WHERE c.access IN (1,1,5)
AND c.published = 1
AND c.language in ('cs-CZ','*')
AND c.extension = 'com_jevents'
ORDER BY c.lft ascid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c range cat_idx,idx_access,idx_language cat_idx 207 NULL 6 Using index condition; Using where; Použití filesort Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sorting result 0.06 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 19 JDatabaseDriver->loadColumn() JROOT/components/com_jevents/libraries/dbmodel.php:542 18 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/datamodel.php:1020 17 JEventsDataModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/filters/Category.php:47 16 jevCategoryFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:180 15 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:251 14 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:1255 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35 11 ExtModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:500 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 1.21 ms Po posledním dotazu: 1.09 ms Dotaz paměti: 0.042 MB Paměť před dotazem: 16.694 MB Vráceno řádků: 0
SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM makac_jevents_repetition as rpt
INNER JOIN makac_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN makac_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN makac_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN makac_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,121,118,120,119,143)
AND rpt.endrepeat >= '2022-12-08 00:15:42'
AND rpt.startrepeat <= '2023-02-06 23:59:59'
AND ev.state=1
AND ev.access IN (1,1,5)
AND icsf.state=1
AND icsf.access IN (1,1,5)
GROUP BY rpt.startrepeat , rpt.rp_id
ORDER BY rpt.startrepeat ASC
LIMIT 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rpt range eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat endrepeat 5 NULL 1 Using index condition; Using where; Using temporary; Použití filesort 1 SIMPLE ev eq_ref PRIMARY,icsid,stateidx,evaccess PRIMARY 4 d85662_model.rpt.eventid 1 Using where 1 SIMPLE icsf eq_ref PRIMARY,stateidx PRIMARY 4 d85662_model.ev.icsid 1 Using where 1 SIMPLE det eq_ref PRIMARY PRIMARY 4 d85662_model.rpt.eventdetail_id 1 1 SIMPLE rr ref eventid eventid 4 d85662_model.rpt.eventid 1 Status Duration starting 0.12 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.06 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.04 ms executing 0.01 ms Creating tmp table 0.26 ms Copying to tmp table 0.04 ms Sorting result 0.02 ms Sending data 0.05 ms end 0.01 ms removing tmp table 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.02 ms updating status 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:3232 15 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 14 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:1868 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35 11 ExtModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:500 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 1.15 ms Po posledním dotazu: 0.11 ms Dotaz paměti: 0.042 MB Paměť před dotazem: 16.704 MB Vráceno řádků: 0
SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM makac_jevents_repetition as rpt
INNER JOIN makac_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN makac_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN makac_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN makac_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,121,118,120,119,143)
AND rpt.endrepeat >= '2022-10-09 00:00:00'
AND rpt.startrepeat <= '2022-12-08 00:15:42'
AND ev.state=1
AND ev.access IN (1,1,5)
AND icsf.state=1
AND icsf.access IN (1,1,5)
GROUP BY rpt.startrepeat , rpt.rp_id
ORDER BY rpt.startrepeat desc
LIMIT 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rpt range eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat endrepeat 5 NULL 1 Using index condition; Using where; Using temporary; Použití filesort 1 SIMPLE ev eq_ref PRIMARY,icsid,stateidx,evaccess PRIMARY 4 d85662_model.rpt.eventid 1 Using where 1 SIMPLE icsf eq_ref PRIMARY,stateidx PRIMARY 4 d85662_model.ev.icsid 1 Using where 1 SIMPLE det eq_ref PRIMARY PRIMARY 4 d85662_model.rpt.eventdetail_id 1 1 SIMPLE rr ref eventid eventid 4 d85662_model.rpt.eventid 1 Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.06 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.04 ms executing 0.01 ms Creating tmp table 0.28 ms Copying to tmp table 0.03 ms Sorting result 0.02 ms Sending data 0.05 ms end 0.01 ms removing tmp table 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.02 ms updating status 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:3232 15 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 14 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:1926 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35 11 ExtModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:500 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.51 ms Po posledním dotazu: 7.09 ms Dotaz paměti: 0.007 MB Paměť před dotazem: 17.633 MB
CREATE TABLE IF NOT EXISTS makac_Visitors(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=1
VYSVĚTLENÍ není možné pro dotaz: CREATE TABLE IF NOT EXISTS makac_Visitors(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=1Status Duration starting 0.14 ms checking permissions 0.03 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.02 ms After create 0.01 ms Writing to binlog 0.03 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 14 JDatabase->query() JROOT/modules/mod_vvisit_counter/helper.php:1404 13 modVisitCounterHelper->init() JROOT/modules/mod_vvisit_counter/helper.php:482 12 modVisitCounterHelper->__construct() JROOT/modules/mod_vvisit_counter/tmpl/default.php:21 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:500 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.39 ms Po posledním dotazu: 0.04 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 17.640 MB Vráceno řádků: 1
SELECT count( * ) AS records, MAX( id ) AS max
FROM makac_Visitorsid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL MOHL BY BÝT POUŽIT NO INDEX KEY NULL NULL NULL Select tables optimized away Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.03 ms optimizing 0.02 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 14 JDatabaseDriver->loadRow() JROOT/modules/mod_vvisit_counter/helper.php:1417 13 modVisitCounterHelper->init() JROOT/modules/mod_vvisit_counter/helper.php:482 12 modVisitCounterHelper->__construct() JROOT/modules/mod_vvisit_counter/tmpl/default.php:21 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:500 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 3.04 ms Po posledním dotazu: 0.05 ms Dotaz paměti: 0.007 MB Paměť před dotazem: 17.647 MB
DELETE
FROM makac_Visitors
WHERE id<='287644'VYSVĚTLENÍ není možné pro dotaz: DELETE FROM makac_Visitors WHERE id<='287644'Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.01 ms init 0.03 ms updating 2.56 ms end 0.03 ms Waiting for query cache lock 0.01 ms end 0.02 ms query end 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms Waiting for query cache lock 0.01 ms Unlocking tables 0.03 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 14 JDatabase->query() JROOT/modules/mod_vvisit_counter/helper.php:1560 13 modVisitCounterHelper->init() JROOT/modules/mod_vvisit_counter/helper.php:482 12 modVisitCounterHelper->__construct() JROOT/modules/mod_vvisit_counter/tmpl/default.php:21 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:500 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.54 ms Po posledním dotazu: 0.07 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 17.655 MB Vráceno řádků: 1
SELECT COUNT(*)
FROM makac_Visitors
WHERE ip=UNHEX(SHA1('3.236.146.28'))
AND ( ((unix_timestamp(NOW()) - tm ) / 60 ) < '15' )id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE makac_Visitors ref ip,iptm iptm 20 const 5 Using where; Using index Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.04 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.02 ms updating status 0.02 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/modules/mod_vvisit_counter/helper.php:1612 13 modVisitCounterHelper->init() JROOT/modules/mod_vvisit_counter/helper.php:482 12 modVisitCounterHelper->__construct() JROOT/modules/mod_vvisit_counter/tmpl/default.php:21 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:500 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.29 ms Po posledním dotazu: 0.06 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 17.726 MB Vráceno řádků: 1
SELECT COUNT(*)
FROM makac_Visitors
WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW()))
AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE makac_Visitors range tm tm 4 NULL 4 Using where; Using index Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/modules/mod_vvisit_counter/helper.php:1920 13 modVisitCounterHelper->sql_today_visitors() JROOT/modules/mod_vvisit_counter/helper.php:763 12 modVisitCounterHelper->renderPeopleTable() JROOT/modules/mod_vvisit_counter/tmpl/default.php:26 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:500 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.38 ms Po posledním dotazu: 0.03 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 17.733 MB Vráceno řádků: 1
SELECT COUNT(*)
FROM makac_Visitors
WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 DAY))
AND UNIX_TIMESTAMP(DATE(NOW()))id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE makac_Visitors range tm tm 4 NULL 124 Using where; Using index Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 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 Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/modules/mod_vvisit_counter/helper.php:1935 13 modVisitCounterHelper->sql_yesterday_visitors() JROOT/modules/mod_vvisit_counter/helper.php:774 12 modVisitCounterHelper->renderPeopleTable() JROOT/modules/mod_vvisit_counter/tmpl/default.php:26 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:500 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.45 ms Po posledním dotazu: 0.05 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 17.742 MB Vráceno řádků: 1
SELECT COUNT(*)
FROM makac_Visitors
WHERE tm BETWEEN 1670194800
AND 1670799600id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE makac_Visitors range tm tm 4 NULL 326 Using where; Using index Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/modules/mod_vvisit_counter/helper.php:1979 13 modVisitCounterHelper->sql_week_visitors() JROOT/modules/mod_vvisit_counter/helper.php:784 12 modVisitCounterHelper->renderPeopleTable() JROOT/modules/mod_vvisit_counter/tmpl/default.php:26 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:500 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.54 ms Po posledním dotazu: 0.05 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 17.749 MB Vráceno řádků: 1
SELECT COUNT(*)
FROM makac_Visitors
WHERE tm BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01"))
AND UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01") + INTERVAL 1 MONTH)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE makac_Visitors range tm tm 4 NULL 936 Using where; Using index Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Sending data 0.18 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Volající Soubor a číslo řádku 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/modules/mod_vvisit_counter/helper.php:1994 13 modVisitCounterHelper->sql_month_visitors() JROOT/modules/mod_vvisit_counter/helper.php:808 12 modVisitCounterHelper->renderPeopleTable() JROOT/modules/mod_vvisit_counter/tmpl/default.php:26 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:500 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Čas pro dotazy: 0.56 ms Po posledním dotazu: 27.35 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 17.213 MB Vráceno řádků: 0
SELECT *
FROM makac_joat_postmanager
WHERE content_type="joomla"
AND state=1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE makac_joat_postmanager ALL NULL MOHL BY BÝT POUŽIT NO INDEX KEY NULL NULL 2 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.01 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 Unlocking tables 0.02 ms freeing items 0.01 ms updating status 0.05 ms cleaning up 0.02 ms # Volající Soubor a číslo řádku 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 8 JDatabaseDriver->loadObjectList() JROOT/plugins/system/jo_autopost_facebook/jo_autopost_facebook.php:74 7 plgSystemJo_autopost_facebook->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
27 zaznamenaných typů dotazu, řazeno dle výskytu
VYBRANÉ tabulky:
5 × SELECT COUNT(*)
FROM makac_Visitors2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `makac_assets`2 × SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM makac_jevents_repetition as rpt
INNER JOIN makac_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN makac_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN makac_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN makac_jevents_rrule as rr
ON rr.eventid = rpt.eventid1 × SELECT `data`
FROM `makac_session`1 × SELECT cc.title AS text, cc.id AS id, cc.parent_id as parentid, cc.alias as alias, cc.access as access, cc.accessuserid as accessuserid
FROM makac_phocagallery_categories AS cc1 × SELECT count( * ) AS records, MAX( id ) AS max
FROM makac_Visitor1 × SELECT c.id
FROM makac_categories AS c1 × 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 `makac_categories` AS `c`1 × SELECT cc.id, cc.alias as catalias, a.id, a.catid, a.title, a.alias, a.filename, a.description, a.extm, a.exts,a.extl, a.exto, a.extw, a.exth, a.extid,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
FROM makac_phocagallery_categories AS cc
LEFT JOIN makac_phocagallery AS a
ON a.catid = cc.id1 × SELECT cc.id AS idcat, a.id AS idimage
FROM makac_phocagallery_categories AS cc
LEFT JOIN makac_phocagallery AS a
ON a.catid = cc.id1 × SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM makac_phocagallery_styles AS a1 × SELECT `session_id`
FROM `makac_session`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM makac_modules AS m
LEFT JOIN makac_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN makac_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM makac_fields AS a
LEFT JOIN `makac_languages` AS l
ON l.lang_code = a.language
LEFT JOIN makac_users AS uc
ON uc.id=a.checked_out
LEFT JOIN makac_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN makac_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN makac_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `makac_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 `makac_categories` AS `s`
INNER JOIN `makac_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 `m`.`tag_id`,`t`.*
FROM `makac_contentitem_tag_map` AS m
INNER JOIN `makac_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM makac_content AS a
INNER JOIN makac_categories AS c
on c.id = a.catid
LEFT JOIN makac_users AS u
on u.id = a.created_by
LEFT JOIN makac_categories as parent
ON parent.id = c.parent_id
LEFT JOIN makac_content_rating AS v
ON a.id = v.content_id1 × SELECT b.id
FROM makac_usergroups AS a
LEFT JOIN makac_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `makac_viewlevels1 × SELECT *
FROM makac_joat_postmanager
OSTATNÍ tabulky:
1 × INSERT INTO `makac_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6566653737386336343863323530636634646561303530633532653936393633', 1, 1670454942, 0, '', 01 × UPDATE `makac_extensions`
SET `params` = '{\"mediaversion\":\"957523b7a484af18f0628c3c4092e053\"}'1 × SHOW FULL COLUMNS
FROM `makac_content1 × UPDATE makac_content
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `makac_jev_users1 × CREATE TABLE IF NOT EXISTS makac_Visitors(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=
1 × DELETE
FROM makac_Visitors
