Czech Geowest

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1643192182,
                "last": 1643192182,
                "now": 1643192182
            },
            "token": "VW355lPIijW2FKgXGy1The5jirQ2Emi1"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Čas

Paměť

45 zaznamenaných dotazů 665.95 ms

1. Čas pro dotazy: 61.80 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 1.162 MB Vráceno řádků: 0

   SELECT `data`
   
     FROM `sys_session`
   
     WHERE `session_id` = 'fva4gb9jti7ehpmlscvd8gbat4'

   Vysvětlení

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	sys_session	const	PRIMARY	PRIMARY	766	const	1

   Profil

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.01 ms
   init	0.00 ms
   checking query cache for query	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   After opening tables	0.01 ms
   Waiting for query cache lock	0.00 ms
   After opening tables	61.27 ms
   init	0.04 ms
   optimizing	0.02 ms
   statistics	0.08 ms
   preparing	0.01 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   updating status	0.04 ms
   Waiting for query cache lock	0.01 ms
   updating status	0.00 ms
   storing result in query cache	0.01 ms
   cleaning up	0.01 ms

   Stack volání

   #	Volající	Soubor a číslo řádku
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Stejné jako volání v řá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:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:755
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   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:343
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

   ---

2. Čas pro dotazy: 73.68 ms Po posledním dotazu: 14.83 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 1.180 MB Vráceno řádků: 0

   SELECT `session_id`
   
     FROM `sys_session`
   
     WHERE `session_id` = 'fva4gb9jti7ehpmlscvd8gbat4' 
     LIMIT 1

   Vysvětlení

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	sys_session	const	PRIMARY	PRIMARY	766	const	1	Using index

   Profil

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   init	0.00 ms
   checking query cache for query	73.09 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   After opening tables	0.01 ms
   Waiting for query cache lock	0.00 ms
   After opening tables	0.03 ms
   init	0.03 ms
   optimizing	0.02 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.03 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   Waiting for query cache lock	0.01 ms
   updating status	0.03 ms
   Waiting for query cache lock	0.01 ms
   updating status	0.00 ms
   storing result in query cache	0.12 ms
   cleaning up	0.01 ms

   Stack volání

   #	Volající	Soubor a číslo řádku
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   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:343
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

   ---

3. Čas pro dotazy: 100.32 ms Po posledním dotazu: 0.26 ms Dotaz paměti: 0.005 MB Paměť před dotazem: 1.188 MB

   INSERT INTO `sys_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('fva4gb9jti7ehpmlscvd8gbat4', 1, '1643192183', 0, '', 0)

   Vysvětlení

   VYSVĚTLENÍ není možné pro dotaz: INSERT INTO `sys_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('fva4gb9jti7ehpmlscvd8gbat4', 1, '1643192183', 0, '', 0)

   Profil

   Status	Duration
   starting	0.05 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
   After opening tables	0.01 ms
   init	0.02 ms
   update	86.29 ms
   Waiting for query cache lock	0.01 ms
   update	0.02 ms
   end	0.01 ms
   query end	13.74 ms
   closing tables	0.02 ms
   freeing items	0.01 ms
   updating status	0.03 ms
   cleaning up	0.01 ms

   Stack volání

   #	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:152
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   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:343
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

   ---

4. Čas pro dotazy: 16.33 ms Po posledním dotazu: 64.57 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 1.287 MB Vráceno řádků: 39

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `sys_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Vysvětlení

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	sys_extensions	ref	extension	extension	82	const	40	Using index condition; Using where

   Profil

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.01 ms
   init	0.00 ms
   checking query cache for query	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
   After opening tables	0.01 ms
   Waiting for query cache lock	0.00 ms
   After opening tables	0.08 ms
   init	0.03 ms
   optimizing	0.03 ms
   statistics	0.09 ms
   preparing	0.04 ms
   executing	0.01 ms
   Sending data	0.87 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   updating status	14.84 ms
   Waiting for query cache lock	0.01 ms
   updating status	0.00 ms
   storing result in query cache	0.01 ms
   cleaning up	0.01 ms

   Stack volání

   #	Volající	Soubor a číslo řádku
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:425
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Stejné jako volání v řádku níže.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:433
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:499
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:596
   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:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

   ---

5. Čas pro dotazy: 0.16 ms Po posledním dotazu: 51.24 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 1.337 MB Vráceno řádků: 4

   SELECT id, rules
   
     FROM `sys_viewlevels`

   Vysvětlení

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	sys_viewlevels	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	4

   Profil

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.01 ms
   init	0.00 ms
   checking query cache for query	0.01 ms
   checking privileges on cached	0.01 ms
   checking permissions	0.01 ms
   sending cached result to clien	0.02 ms
   updating status	0.01 ms
   cleaning up	0.00 ms

   Stack volání

   #	Volající	Soubor a číslo řádku
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
   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:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

   ---

6. Čas pro dotazy: 0.12 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 1.351 MB Vráceno řádků: 1

   SELECT b.id
   
     FROM sys_usergroups AS a
   
     LEFT JOIN sys_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 1

   Vysvětlení

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	8	Using where; Using index

   Profil

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   init	0.00 ms
   checking query cache for query	0.01 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   sending cached result to clien	0.02 ms
   updating status	0.01 ms
   cleaning up	0.00 ms

   Stack volání

   #	Volající	Soubor a číslo řádku
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
   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:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

   ---

7. Čas pro dotazy: 72.91 ms Po posledním dotazu: 72.15 ms Dotaz paměti: 0.037 MB Paměť před dotazem: 1.374 MB Vráceno řádků: 83

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM sys_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,4)
   
     ORDER BY ordering

   Vysvětlení

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	sys_extensions	ref	extension	extension	82	const	110	Using index condition; Using where; Použití filesort

   Profil

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.01 ms
   init	0.00 ms
   checking query cache for query	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
   After opening tables	0.01 ms
   Waiting for query cache lock	0.00 ms
   After opening tables	0.02 ms
   init	0.03 ms
   optimizing	0.03 ms
   statistics	0.07 ms
   preparing	0.04 ms
   executing	0.01 ms
   Sorting result	33.64 ms
   Sending data	0.19 ms
   end	0.01 ms
   query end	0.11 ms
   closing tables	0.02 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   updating status	38.44 ms
   Waiting for query cache lock	0.01 ms
   updating status	0.00 ms
   storing result in query cache	0.01 ms
   cleaning up	0.01 ms

   Stack volání

   #	Volající	Soubor a číslo řádku
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Stejné jako volání v řádku níže.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
   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:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

   ---

8. Čas pro dotazy: 47.43 ms Po posledním dotazu: 127.43 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 1.722 MB Vráceno řádků: 1

   SELECT `enabled`
   
     FROM `sys_extensions`
   
     WHERE `element` = 'com_akeeba' 
     AND `type` = 'component'

   Vysvětlení

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	sys_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

   Profil

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.01 ms
   init	0.00 ms
   checking query cache for query	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
   After opening tables	0.01 ms
   Waiting for query cache lock	0.00 ms
   After opening tables	46.84 ms
   init	0.04 ms
   optimizing	0.02 ms
   statistics	0.10 ms
   preparing	0.03 ms
   executing	0.01 ms
   Sending data	0.06 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   updating status	0.03 ms
   Waiting for query cache lock	0.01 ms
   updating status	0.00 ms
   storing result in query cache	0.01 ms
   cleaning up	0.01 ms

   Stack volání

   #	Volající	Soubor a číslo řádku
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:74
   7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   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:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

   ---

9. Čas pro dotazy: 85.52 ms Po posledním dotazu: 439.78 ms Dotaz paměti: 0.043 MB Paměť před dotazem: 1.914 MB Vráceno řádků: 16

   SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
   
     FROM sys_menu AS m
   
     LEFT JOIN sys_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   Vysvětlení

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	17	Using index condition; Using where; Použití filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	c1_geowest.m.component_id	1	Using where

   Profil

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.01 ms
   init	0.01 ms
   checking query cache for query	0.08 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
   After opening tables	0.01 ms
   Waiting for query cache lock	0.00 ms
   After opening tables	58.07 ms
   init	0.05 ms
   optimizing	0.03 ms
   statistics	0.08 ms
   preparing	0.04 ms
   executing	0.01 ms
   Sorting result	0.62 ms
   Sending data	0.18 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   updating status	26.06 ms
   Waiting for query cache lock	0.01 ms
   updating status	0.00 ms
   storing result in query cache	0.01 ms
   cleaning up	0.01 ms

   Stack volání

   #	Volající	Soubor a číslo řádku
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Stejné jako volání v řádku níže.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
   11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:374
   10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
   8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:488
   6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
   5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1070
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

   ---

10. Čas pro dotazy: 1.55 ms Po posledním dotazu: 326.51 ms Dotaz paměti: 0.032 MB Paměť před dotazem: 2.141 MB Vráceno řádků: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `sys_extensions`
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sys_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	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
    After opening tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    After opening tables	0.03 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    updating status	0.03 ms
    Waiting for query cache lock	0.01 ms
    updating status	0.00 ms
    storing result in query cache	0.07 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    22	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    21	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Stejné jako volání v řádku níže.
    20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    18	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    17	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    16	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    15	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    14	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    13	Joomla\CMS\Factory::getDocument()	JROOT/libraries/cms/html/behavior.php:355
    12	JHtmlBehavior::modal()	Stejné jako volání v řádku níže.
    11	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    10	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    9	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/k2/k2.php:41
    8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1080
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

11. Čas pro dotazy: 1.47 ms Po posledním dotazu: 0.21 ms Dotaz paměti: 0.011 MB Paměť před dotazem: 2.139 MB

    UPDATE `sys_extensions`
    
      SET `params` = '{\"mediaversion\":\"5db3ca3f081a899c575097c8130011f8\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Vysvětlení

    VYSVĚTLENÍ není možné pro dotaz: UPDATE `sys_extensions` SET `params` = '{\"mediaversion\":\"5db3ca3f081a899c575097c8130011f8\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profil

    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.00 ms
    After opening tables	0.01 ms
    init	0.07 ms
    updating	0.43 ms
    end	0.01 ms
    Waiting for query cache lock	0.00 ms
    end	0.15 ms
    query end	0.65 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    17	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    16	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    15	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    14	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    13	Joomla\CMS\Factory::getDocument()	JROOT/libraries/cms/html/behavior.php:355
    12	JHtmlBehavior::modal()	Stejné jako volání v řádku níže.
    11	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    10	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    9	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/k2/k2.php:41
    8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1080
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

12. Čas pro dotazy: 0.71 ms Po posledním dotazu: 19.27 ms Dotaz paměti: 0.032 MB Paměť před dotazem: 2.176 MB Vráceno řádků: 7

    SELECT id, home, template, s.params
    
      FROM sys_template_styles as s
    
      LEFT JOIN sys_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	10	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	c1_geowest.s.template,const	1	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	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
    After opening tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    After opening tables	0.03 ms
    init	0.03 ms
    optimizing	0.03 ms
    statistics	0.08 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sending data	0.17 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.03 ms
    Waiting for query cache lock	0.01 ms
    updating status	0.00 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
    20	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
    19	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
    18	Joomla\CMS\HTML\HTMLHelper::script()	Stejné jako volání v řádku níže.
    17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/behavior.php:63
    14	JHtmlBehavior::framework()	JROOT/libraries/cms/html/behavior.php:60
    13	JHtmlBehavior::framework()	JROOT/libraries/cms/html/behavior.php:361
    12	JHtmlBehavior::modal()	Stejné jako volání v řádku níže.
    11	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    10	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    9	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/k2/k2.php:41
    8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1080
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

13. Čas pro dotazy: 0.26 ms Po posledním dotazu: 100.21 ms Dotaz paměti: 0.030 MB Paměť před dotazem: 2.231 MB Vráceno řádků: 1

    SELECT *
    
      FROM sys_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sys_languages	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	1	Using where; Použití filesort

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.06 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    12	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    11	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:323
    10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:55
    9	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:47
    8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1080
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

14. Čas pro dotazy: 0.21 ms Po posledním dotazu: 7.22 ms Dotaz paměti: 0.031 MB Paměť před dotazem: 2.320 MB Vráceno řádků: 39

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `sys_assets`
    
      WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_ckeditor','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_discussions','com_fields','com_finder','com_installer','com_jantivirus','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sys_assets	ALL	idx_asset_name	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	66	Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    11	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    10	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    9	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    8	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    7	Joomla\CMS\User\User->authorise()	JROOT/components/com_k2/k2.php:16
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

15. Čas pro dotazy: 0.14 ms Po posledním dotazu: 13.22 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 2.486 MB Vráceno řádků: 3

    SELECT id 
      FROM sys_k2_categories 
      WHERE published=1 
      AND trash=0 
      AND access IN(1,1,4)

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sys_k2_categories	ref	category,published,access,trash	published	2	const	2	Using where

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    13	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:252
    12	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/itemlist/view.html.php:29
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

16. Čas pro dotazy: 24.48 ms Po posledním dotazu: 0.69 ms Dotaz paměti: 0.037 MB Paměť před dotazem: 2.501 MB Vráceno řádků: 16

    SHOW FULL COLUMNS 
      FROM `sys_users`

    Vysvětlení

    VYSVĚTLENÍ není možné pro dotaz: SHOW FULL COLUMNS FROM `sys_users`

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    Opening tables	23.72 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    After opening tables	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.02 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.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 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.00 ms
    removing tmp table	0.10 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:441
    21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    19	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:40
    18	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
    17	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
    16	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:880
    15	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    14	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    13	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    12	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/views/itemlist/view.html.php:201
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

17. Čas pro dotazy: 0.12 ms Po posledním dotazu: 1.30 ms Dotaz paměti: 0.034 MB Paměť před dotazem: 2.550 MB Vráceno řádků: 1

    SELECT *
    
      FROM `sys_users`
    
      WHERE `id` = 667

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sys_users	const	PRIMARY	PRIMARY	4	const	1

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:86
    16	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
    15	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    14	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    13	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    12	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/views/itemlist/view.html.php:201
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

18. Čas pro dotazy: 0.11 ms Po posledním dotazu: 0.90 ms Dotaz paměti: 0.030 MB Paměť před dotazem: 2.569 MB Vráceno řádků: 1

    SELECT `g`.`id`,`g`.`title`
    
      FROM `sys_usergroups` AS g
    
      INNER JOIN `sys_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 667

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	Using index
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	c1_geowest.m.group_id	1

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
    17	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:111
    16	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
    15	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    14	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    13	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    12	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/views/itemlist/view.html.php:201
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

19. Čas pro dotazy: 0.10 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 2.577 MB Vráceno řádků: 1
    Duplicitní dotazy: #20

    SELECT id, gender, description, image, url, `
      group`, plugins 
      FROM sys_k2_users 
      WHERE userID=667

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sys_k2_users	ref	userID	userID	4	const	1

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/itemlist.php:784
    12	K2ModelItemlist->getUserProfile()	JROOT/components/com_k2/views/itemlist/view.html.php:211
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

20. Čas pro dotazy: 0.10 ms Po posledním dotazu: 0.50 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 2.589 MB Vráceno řádků: 1
    Duplicitní dotazy: #19

    SELECT id, gender, description, image, url, `
      group`, plugins 
      FROM sys_k2_users 
      WHERE userID=667

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sys_k2_users	ref	userID	userID	4	const	1

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    updating status	0.00 ms
    cleaning up	0.00 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1694
    13	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:73
    12	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/views/itemlist/view.html.php:214
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

21. Čas pro dotazy: 46.94 ms Po posledním dotazu: 1.02 ms Dotaz paměti: 0.078 MB Paměť před dotazem: 2.608 MB Vráceno řádků: 5

    SELECT i.*, 
      CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams 
      FROM sys_k2_items as i 
      LEFT JOIN sys_k2_categories AS c 
      ON c.id = i.catid 
      WHERE i.published = 1 
      AND i.access IN(1,1,4) 
      AND i.trash = 0 
      AND c.published = 1 
      AND c.access IN(1,1,4) 
      AND c.trash = 0 
      AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-01-26 10:16:24' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-01-26 10:16:24' ) 
      AND i.created_by=667 
      AND i.created_by_alias='' 
      ORDER BY i.id DESC 
      LIMIT 5, 5

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ref	PRIMARY,category,published,access,trash	published	2	const	2	Using where; Using temporary; Použití filesort
    1	SIMPLE	i	ref	item,catid,created_by	catid	4	c1_geowest.c.id	26	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    checking query cache for query	4.36 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
    After opening tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    After opening tables	0.02 ms
    init	0.07 ms
    optimizing	0.04 ms
    statistics	0.11 ms
    preparing	0.05 ms
    executing	0.01 ms
    Copying to tmp table	0.33 ms
    Copying to tmp table	40.89 ms
    Sorting result	0.36 ms
    Sending data	0.15 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.13 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    removing tmp table	0.14 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.02 ms
    Waiting for query cache lock	0.01 ms
    updating status	0.00 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:342
    12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/itemlist/view.html.php:337
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

22. Čas pro dotazy: 24.07 ms Po posledním dotazu: 0.41 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 2.775 MB Vráceno řádků: 1

    SELECT COUNT(*) 
      FROM sys_k2_items as i 
      LEFT JOIN sys_k2_categories c 
      ON c.id = i.catid 
      WHERE i.published = 1 
      AND i.access IN(1,1,4) 
      AND i.trash = 0 
      AND c.published = 1 
      AND c.access IN(1,1,4) 
      AND c.trash = 0 
      AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-01-26 10:16:24' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-01-26 10:16:24' ) 
      AND i.created_by=667 
      AND i.created_by_alias=''

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ref	PRIMARY,category,published,access,trash	published	2	const	2	Using where
    1	SIMPLE	i	ref	item,catid,created_by	catid	4	c1_geowest.c.id	26	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	22.59 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
    After opening tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    After opening tables	0.03 ms
    init	0.05 ms
    optimizing	0.04 ms
    statistics	0.10 ms
    preparing	0.05 ms
    executing	0.01 ms
    Sending data	0.96 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.02 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.00 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    13	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/itemlist.php:572
    12	K2ModelItemlist->getTotal()	JROOT/components/com_k2/views/itemlist/view.html.php:346
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

23. Čas pro dotazy: 0.92 ms Po posledním dotazu: 1.38 ms Dotaz paměti: 0.034 MB Paměť před dotazem: 2.795 MB Vráceno řádků: 14

    SHOW FULL COLUMNS 
      FROM `sys_k2_categories`

    Vysvětlení

    VYSVĚTLENÍ není možné pro dotaz: SHOW FULL COLUMNS FROM `sys_k2_categories`

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    Opening tables	0.26 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    closing tables	0.01 ms
    executing	0.01 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.11 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:441
    16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:34
    13	TableK2Category->__construct()	JROOT/libraries/src/Table/Table.php:312
    12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/views/itemlist/view.html.php:389
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

24. Čas pro dotazy: 0.11 ms Po posledním dotazu: 0.22 ms Dotaz paměti: 0.033 MB Paměť před dotazem: 2.848 MB Vráceno řádků: 1

    SELECT * 
      FROM sys_k2_categories 
      WHERE id = '9'

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sys_k2_categories	const	PRIMARY	PRIMARY	4	const	1

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:65
    16	TableK2Category->load()	JROOT/components/com_k2/models/item.php:70
    15	K2ModelItem->prepareItem()	Stejné jako volání v řádku níže.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:390
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

25. Čas pro dotazy: 31.86 ms Po posledním dotazu: 2.91 ms Dotaz paměti: 0.030 MB Paměť před dotazem: 2.898 MB Vráceno řádků: 0

    SELECT tag.*
    		
      FROM sys_k2_tags AS tag 
    		JOIN sys_k2_tags_xref AS xref 
      ON tag.id = xref.tagID 
    		
      WHERE tag.published=1 
    		
      AND xref.itemID = 76 
      ORDER BY xref.id ASC

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where; Použití filesort
    1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	c1_geowest.xref.tagID	1	Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    checking query cache for query	31.60 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.13 ms
    sending cached result to clien	0.02 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1255
    16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:103
    15	K2ModelItem->prepareItem()	Stejné jako volání v řádku níže.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:390
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

26. Čas pro dotazy: 0.13 ms Po posledním dotazu: 1.82 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 2.911 MB Vráceno řádků: 1

    SELECT COUNT(*) 
      FROM sys_k2_comments 
      WHERE itemID=76 
      AND published=1

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sys_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1571
    16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:258
    15	K2ModelItem->prepareItem()	Stejné jako volání v řádku níže.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:390
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

27. Čas pro dotazy: 0.20 ms Po posledním dotazu: 69.99 ms Dotaz paměti: 0.042 MB Paměť před dotazem: 2.960 MB Vráceno řádků: 0

    SELECT 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 sys_fields AS a
    
      LEFT JOIN `sys_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN sys_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN sys_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN sys_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN sys_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `sys_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_k2.itemlist' 
      AND (fc.category_id IS NULL OR fc.category_id IN (9,0)) 
      AND a.access IN (1,1,4) 
      AND (a.group_id = 0 OR g.access IN (1,1,4)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Vysvětlení

    id	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; Použití filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	c1_geowest.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	c1_geowest.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	c1_geowest.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	c1_geowest.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	c1_geowest.a.group_id	1	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	c1_geowest.a.id	1	Using where; Using index

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:672
    12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/itemlist/view.html.php:399
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

28. Čas pro dotazy: 3.25 ms Po posledním dotazu: 3.32 ms Dotaz paměti: 0.030 MB Paměť před dotazem: 3.097 MB Vráceno řádků: 0

    SELECT tag.*
    		
      FROM sys_k2_tags AS tag 
    		JOIN sys_k2_tags_xref AS xref 
      ON tag.id = xref.tagID 
    		
      WHERE tag.published=1 
    		
      AND xref.itemID = 75 
      ORDER BY xref.id ASC

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where; Použití filesort
    1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	c1_geowest.xref.tagID	1	Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.00 ms
    checking query cache for query	3.13 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1255
    16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:103
    15	K2ModelItem->prepareItem()	Stejné jako volání v řádku níže.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:390
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

29. Čas pro dotazy: 0.10 ms Po posledním dotazu: 1.52 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 3.111 MB Vráceno řádků: 1

    SELECT COUNT(*) 
      FROM sys_k2_comments 
      WHERE itemID=75 
      AND published=1

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sys_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    updating status	0.00 ms
    cleaning up	0.00 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1571
    16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:258
    15	K2ModelItem->prepareItem()	Stejné jako volání v řádku níže.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:390
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

30. Čas pro dotazy: 0.14 ms Po posledním dotazu: 2.99 ms Dotaz paměti: 0.030 MB Paměť před dotazem: 3.132 MB Vráceno řádků: 0

    SELECT tag.*
    		
      FROM sys_k2_tags AS tag 
    		JOIN sys_k2_tags_xref AS xref 
      ON tag.id = xref.tagID 
    		
      WHERE tag.published=1 
    		
      AND xref.itemID = 74 
      ORDER BY xref.id ASC

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where; Použití filesort
    1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	c1_geowest.xref.tagID	1	Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1255
    16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:103
    15	K2ModelItem->prepareItem()	Stejné jako volání v řádku níže.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:390
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

31. Čas pro dotazy: 0.10 ms Po posledním dotazu: 1.64 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 3.144 MB Vráceno řádků: 1

    SELECT COUNT(*) 
      FROM sys_k2_comments 
      WHERE itemID=74 
      AND published=1

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sys_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    updating status	0.00 ms
    cleaning up	0.00 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1571
    16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:258
    15	K2ModelItem->prepareItem()	Stejné jako volání v řádku níže.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:390
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

32. Čas pro dotazy: 0.32 ms Po posledním dotazu: 2.85 ms Dotaz paměti: 0.030 MB Paměť před dotazem: 3.156 MB Vráceno řádků: 0

    SELECT tag.*
    		
      FROM sys_k2_tags AS tag 
    		JOIN sys_k2_tags_xref AS xref 
      ON tag.id = xref.tagID 
    		
      WHERE tag.published=1 
    		
      AND xref.itemID = 73 
      ORDER BY xref.id ASC

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where; Použití filesort
    1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	c1_geowest.xref.tagID	1	Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    checking query cache for query	0.21 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    updating status	0.00 ms
    cleaning up	0.00 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1255
    16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:103
    15	K2ModelItem->prepareItem()	Stejné jako volání v řádku níže.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:390
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

33. Čas pro dotazy: 0.11 ms Po posledním dotazu: 1.49 ms Dotaz paměti: 0.030 MB Paměť před dotazem: 3.175 MB Vráceno řádků: 1

    SELECT COUNT(*) 
      FROM sys_k2_comments 
      WHERE itemID=73 
      AND published=1

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sys_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    updating status	0.00 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1571
    16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:258
    15	K2ModelItem->prepareItem()	Stejné jako volání v řádku níže.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:390
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

34. Čas pro dotazy: 0.26 ms Po posledním dotazu: 2.80 ms Dotaz paměti: 0.030 MB Paměť před dotazem: 3.191 MB Vráceno řádků: 0

    SELECT tag.*
    		
      FROM sys_k2_tags AS tag 
    		JOIN sys_k2_tags_xref AS xref 
      ON tag.id = xref.tagID 
    		
      WHERE tag.published=1 
    		
      AND xref.itemID = 72 
      ORDER BY xref.id ASC

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where; Použití filesort
    1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	c1_geowest.xref.tagID	1	Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.00 ms
    checking query cache for query	0.15 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    updating status	0.00 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1255
    16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:103
    15	K2ModelItem->prepareItem()	Stejné jako volání v řádku níže.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:390
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

35. Čas pro dotazy: 15.57 ms Po posledním dotazu: 1.47 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 3.204 MB Vráceno řádků: 1

    SELECT COUNT(*) 
      FROM sys_k2_comments 
      WHERE itemID=72 
      AND published=1

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sys_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    checking query cache for query	15.45 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1571
    16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:258
    15	K2ModelItem->prepareItem()	Stejné jako volání v řádku níže.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:390
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:35
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:62
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

36. Čas pro dotazy: 19.79 ms Po posledním dotazu: 38.24 ms Dotaz paměti: 0.031 MB Paměť před dotazem: 3.269 MB Vráceno řádků: 14

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM sys_modules AS m
    
      LEFT JOIN sys_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN sys_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-01-26 10:16:24') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-01-26 10:16:24') 
      AND m.access IN (1,1,4) 
      AND m.client_id = 0 
      AND (mm.menuid = 101 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	20	Using index condition; Using where; Použití filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	c1_geowest.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	c1_geowest.m.module,const	1	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.00 ms
    checking query cache for query	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.00 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
    After opening tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    After opening tables	0.05 ms
    init	0.05 ms
    optimizing	0.04 ms
    statistics	4.18 ms
    preparing	0.07 ms
    executing	0.01 ms
    Sorting result	0.19 ms
    Sending data	0.30 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	14.52 ms
    Waiting for query cache lock	0.01 ms
    updating status	0.00 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    14	JDatabaseDriver->loadObjectList()	Stejné jako volání v řádku níže.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
    11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
    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:581
    8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/beez3/index.php:18
    7	require JROOT/templates/beez3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

37. Čas pro dotazy: 3.38 ms Po posledním dotazu: 22.31 ms Dotaz paměti: 0.031 MB Paměť před dotazem: 3.344 MB Vráceno řádků: 51

    SELECT guest, client_id
    
      FROM sys_session
    
      WHERE client_id = 0

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sys_session	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	50	Using where

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.00 ms
    checking query cache for query	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.01 ms
    After opening tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    After opening tables	0.03 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.09 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	2.88 ms
    Waiting for query cache lock	0.01 ms
    updating status	0.00 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_whosonline/helper.php:45
    11	ModWhosonlineHelper::getOnlineCount()	JROOT/modules/mod_whosonline/mod_whosonline.php:19
    10	include JROOT/modules/mod_whosonline/mod_whosonline.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

38. Čas pro dotazy: 0.99 ms Po posledním dotazu: 0.27 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 3.362 MB Vráceno řádků: 0

    SELECT `a`.`username`,`a`.`userid`,`a`.`client_id`
    
      FROM sys_session AS a
    
      WHERE `a`.`userid` != 0 
      AND `a`.`client_id` = 0
    
      GROUP BY `a`.`username`,`a`.`userid`,`a`.`client_id`

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	range	userid	userid	5	NULL	2	Using index condition; Using where; Using temporary; Použití filesort

    Profil

    Status	Duration
    starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    init	0.00 ms
    checking query cache for query	0.04 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.00 ms
    After opening tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    After opening tables	0.02 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.03 ms
    executing	0.01 ms
    Copying to tmp table	0.03 ms
    Copying to tmp table	0.03 ms
    Sorting result	0.02 ms
    Sending data	0.01 ms
    end	0.01 ms
    removing tmp table	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.00 ms
    storing result in query cache	0.01 ms
    cleaning up	0.02 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_whosonline/helper.php:119
    11	ModWhosonlineHelper::getOnlineUserNames()	JROOT/modules/mod_whosonline/mod_whosonline.php:24
    10	include JROOT/modules/mod_whosonline/mod_whosonline.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

39. Čas pro dotazy: 0.11 ms Po posledním dotazu: 1.47 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 3.375 MB Vráceno řádků: 1

    SELECT `a`.`id`,`a`.`name`,`a`.`username`,`a`.`registerDate`
    
      FROM sys_users AS a
    
      ORDER BY `a`.`registerDate` DESC 
      LIMIT 1

    Vysvětlení

    id	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	38	Použití filesort

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    updating status	0.00 ms
    cleaning up	0.00 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_users_latest/helper.php:56
    11	ModUsersLatestHelper::getUsers()	JROOT/modules/mod_users_latest/mod_users_latest.php:16
    10	include JROOT/modules/mod_users_latest/mod_users_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

40. Čas pro dotazy: 0.17 ms Po posledním dotazu: 10.39 ms Dotaz paměti: 0.042 MB Paměť před dotazem: 3.542 MB Vráceno řádků: 0

    SELECT 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 sys_fields AS a
    
      LEFT JOIN `sys_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN sys_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN sys_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN sys_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN sys_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `sys_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'mod_custom.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (9,0)) 
      AND a.access IN (1,1,4) 
      AND (a.group_id = 0 OR g.access IN (1,1,4)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Vysvětlení

    id	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; Použití filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	c1_geowest.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	c1_geowest.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	c1_geowest.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	c1_geowest.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	c1_geowest.a.group_id	1	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	c1_geowest.a.id	1	Using where; Using index

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    14	JHtmlContent::prepare()	Stejné jako volání v řádku níže.
    13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

41. Čas pro dotazy: 1.35 ms Po posledním dotazu: 1.71 ms Dotaz paměti: 0.031 MB Paměť před dotazem: 3.568 MB Vráceno řádků: 5

    SELECT c.*, i.catid, i.title, i.alias, category.alias as catalias, category.name as categoryname
    		
      FROM sys_k2_comments as c
    		
      LEFT JOIN sys_k2_items as i 
      ON i.id=c.itemID
    		
      LEFT JOIN sys_k2_categories as category 
      ON category.id=i.catid
    		
      WHERE i.published=1
    		
      AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-01-26 10:16:24' )
    		
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-01-26 10:16:24' )
    		
      AND i.trash=0  
      AND i.access IN(1,1,4)  
      AND category.published=1 
      AND category.trash=0  
      AND category.access IN(1,1,4)  
      AND c.published=1  
      ORDER BY c.commentDate DESC 
      LIMIT 0, 5

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ref	itemID,published,latestComments,countComments	latestComments	4	const	18	Using where
    1	SIMPLE	i	eq_ref	PRIMARY,item,catid	PRIMARY	4	c1_geowest.c.itemID	1	Using where
    1	SIMPLE	category	eq_ref	PRIMARY,category,published,access,trash	PRIMARY	4	c1_geowest.i.catid	1	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    checking query cache for query	0.09 ms
    checking permissions	0.01 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
    After opening tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    After opening tables	0.02 ms
    init	0.05 ms
    optimizing	0.04 ms
    statistics	0.12 ms
    preparing	0.05 ms
    executing	0.01 ms
    Sorting result	0.01 ms
    Sending data	0.20 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.00 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_k2_comments/helper.php:92
    11	modK2CommentsHelper::getLatestComments()	JROOT/modules/mod_k2_comments/mod_k2_comments.php:57
    10	include JROOT/modules/mod_k2_comments/mod_k2_comments.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

42. Čas pro dotazy: 0.13 ms Po posledním dotazu: 1.21 ms Dotaz paměti: 0.034 MB Paměť před dotazem: 3.596 MB Vráceno řádků: 1

    SELECT *
    
      FROM `sys_users`
    
      WHERE `id` = 1526

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sys_users	const	PRIMARY	PRIMARY	4	const	1

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    checking query cache for query	0.02 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    updating status	0.00 ms
    cleaning up	0.00 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:86
    17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
    16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/helpers/route.php:50
    12	K2HelperRoute::getUserRoute()	JROOT/modules/mod_k2_comments/helper.php:146
    11	modK2CommentsHelper::getLatestComments()	JROOT/modules/mod_k2_comments/mod_k2_comments.php:57
    10	include JROOT/modules/mod_k2_comments/mod_k2_comments.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

43. Čas pro dotazy: 0.10 ms Po posledním dotazu: 0.14 ms Dotaz paměti: 0.030 MB Paměť před dotazem: 3.612 MB Vráceno řádků: 1

    SELECT `g`.`id`,`g`.`title`
    
      FROM `sys_usergroups` AS g
    
      INNER JOIN `sys_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 1526

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	Using index
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	c1_geowest.m.group_id	1

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    updating status	0.00 ms
    cleaning up	0.00 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
    18	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:111
    17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
    16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/helpers/route.php:50
    12	K2HelperRoute::getUserRoute()	JROOT/modules/mod_k2_comments/helper.php:146
    11	modK2CommentsHelper::getLatestComments()	JROOT/modules/mod_k2_comments/mod_k2_comments.php:57
    10	include JROOT/modules/mod_k2_comments/mod_k2_comments.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

44. Čas pro dotazy: 28.20 ms Po posledním dotazu: 110.79 ms Dotaz paměti: 0.031 MB Paměť před dotazem: 3.641 MB Vráceno řádků: 66

    SELECT i.id 
      FROM sys_k2_items as i 
      LEFT JOIN sys_k2_categories c 
      ON c.id = i.catid 
      WHERE i.published=1  
      AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-01-26 10:16:24' )  
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-01-26 10:16:24' ) 
      AND i.trash=0  
      AND i.access IN(1,1,4)  
      AND c.published=1  
      AND c.trash=0  
      AND c.access IN(1,1,4)

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ref	PRIMARY,category,published,access,trash	published	2	const	2	Using where
    1	SIMPLE	i	ref	item,catid	catid	4	c1_geowest.c.id	26	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.00 ms
    checking query cache for query	0.09 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
    After opening tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    After opening tables	9.74 ms
    init	0.05 ms
    optimizing	0.04 ms
    statistics	0.67 ms
    preparing	0.05 ms
    executing	0.01 ms
    Sending data	1.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    updating status	16.20 ms
    Waiting for query cache lock	0.01 ms
    updating status	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    12	JDatabaseDriver->loadColumn()	JROOT/modules/mod_k2_tools/helper.php:296
    11	modK2ToolsHelper::tagCloud()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:102
    10	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---

45. Čas pro dotazy: 0.12 ms Po posledním dotazu: 0.13 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 3.660 MB Vráceno řádků: 7

    SELECT tag.name, tag.id
            
      FROM sys_k2_tags as tag
            
      LEFT JOIN sys_k2_tags_xref AS xref 
      ON xref.tagID = tag.id 
            
      WHERE xref.itemID IN (56,12,13,14,15,23,16,17,18,20,21,22,24,39,25,26,27,28,30,31,32,33,34,35,36,37,40,41,42,45,46,47,55,57,59,60,52,53,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,6,7,8,9,10,11,38) 
            
      AND tag.published = 1

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	xref	ALL	tagID,itemID	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	11	Using where
    1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	c1_geowest.xref.tagID	1	Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    updating status	0.00 ms
    cleaning up	0.00 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_k2_tools/helper.php:304
    11	modK2ToolsHelper::tagCloud()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:102
    10	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

    ---