Janíkovská šípkarská liga

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1579403570,
                "last": 1579403570,
                "now": 1579403570
            },
            "token": "0fwDwBAtyFw8v4VVXLrlHg69fB1x8Ufv"
        },
        "registry": {
            "jevents": {
                "moduleid108": {
                    "shownEventIds": [
                        [
                            "4055",
                            "4046",
                            "4065",
                            "4075",
                            "4056",
                            "4047",
                            "4066",
                            "4076",
                            "4057",
                            "4048"
                        ]
                    ],
                    "page": 0,
                    "firstEventDate": "2020-01-20 18:00:00",
                    "lastEventDate": "2020-02-06 17:00:00"
                }
            },
            "published_fv_ses": "0"
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Čas

Pamäť

Zaznamenané dotazy: 60 63.01 ms

1. Čas dotazu: 0.40 ms Pamäť pre dotazy: 0.025 MB pamäť pred dotazom: 1.208 MB Vrátené riadky: 0

   SELECT `data`
   
     FROM `cwdeu_session`
   
     WHERE `session_id` = '7d7ecf57f37bef83696deb6feb6baadb'

   Vysvetlenie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	cwdeu_session	const	PRIMARY	PRIMARY	194	const	1

   Profil

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   System lock	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.00 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Rovnaké, ako volanie o riadok nižšie.
   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:758
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

   ---

2. Čas dotazu: 0.37 ms Po ostatnom dotaze: 0.40 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 1.286 MB Vrátené riadky: 0

   SELECT `session_id`
   
     FROM `cwdeu_session`
   
     WHERE `session_id` = '7d7ecf57f37bef83696deb6feb6baadb' 
     LIMIT 1

   Vysvetlenie

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

   Profil

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   System lock	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.00 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

   ---

3. Čas dotazu: 0.40 ms Po ostatnom dotaze: 0.08 ms Pamäť pre dotazy: 0.004 MB pamäť pred dotazom: 1.291 MB

   INSERT INTO `cwdeu_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('7d7ecf57f37bef83696deb6feb6baadb', 1, 1579403570, 0, '', 0)

   Vysvetlenie

   Nie je možné VYSVETLENIE na dotaz: INSERT INTO `cwdeu_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('7d7ecf57f37bef83696deb6feb6baadb', 1, 1579403570, 0, '', 0)

   Profil

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   init	0.01 ms
   update	0.08 ms
   Waiting for query cache lock	0.01 ms
   update	0.01 ms
   end	0.00 ms
   query end	0.07 ms
   closing tables	0.02 ms
   freeing items	0.03 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

   ---

4. Čas dotazu: 0.95 ms Po ostatnom dotaze: 0.52 ms Pamäť pre dotazy: 0.035 MB pamäť pred dotazom: 1.326 MB Vrátené riadky: 39

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

   Vysvetlenie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	cwdeu_extensions	ref	extension	extension	82	const	39	Using where

   Profil

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   System lock	0.01 ms
   init	0.03 ms
   optimizing	0.02 ms
   statistics	0.07 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	0.45 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.05 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Rovnaké, ako volanie o riadok nižšie.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

   ---

5. Čas dotazu: 0.39 ms Po ostatnom dotaze: 0.51 ms Pamäť pre dotazy: 0.023 MB pamäť pred dotazom: 1.369 MB Vrátené riadky: 5

   SELECT id, rules
   
     FROM `cwdeu_viewlevels`

   Vysvetlenie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	cwdeu_viewlevels	ALL	NULL	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	5

   Profil

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   System lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.07 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.03 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

   ---

6. Čas dotazu: 0.45 ms Po ostatnom dotaze: 0.08 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 1.381 MB Vrátené riadky: 2

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

   Vysvetlenie

   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	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where; Using index

   Profil

   Status	Duration
   starting	0.05 ms
   checking permissions	0.00 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   System lock	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.08 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	0.04 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.03 ms
   freeing items	0.03 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

   ---

7. Čas dotazu: 2.01 ms Po ostatnom dotaze: 0.11 ms Pamäť pre dotazy: 0.034 MB pamäť pred dotazom: 1.404 MB Vrátené riadky: 89

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

   Vysvetlenie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	cwdeu_extensions	ref	extension	extension	82	const	116	Using where; Pomocou filesort

   Profil

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   init	0.03 ms
   optimizing	0.02 ms
   statistics	0.06 ms
   preparing	0.03 ms
   executing	0.00 ms
   Sorting result	0.84 ms
   Sending data	0.73 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.03 ms
   freeing items	0.04 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Rovnaké, ako volanie o riadok nižšie.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

   ---

8. Čas dotazu: 0.74 ms Po ostatnom dotaze: 5.07 ms Pamäť pre dotazy: 0.024 MB pamäť pred dotazom: 1.866 MB Vrátené riadky: 0
   Duplicitné dotazy: #9

   SELECT `manifest_cache`
   
     FROM `cwdeu_extensions`
   
     WHERE `type` = 'component' 
     AND `name` = 'com_admintools'

   Vysvetlenie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	cwdeu_extensions	ref	extension	extension	82	const	39	Using where

   Profil

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   System lock	0.01 ms
   init	0.02 ms
   optimizing	0.02 ms
   statistics	0.06 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	0.32 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.03 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   13	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
   12	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
   11	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:159
   10	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
   9	FOF30\Container\Container::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:813
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
   7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

   ---

9. Čas dotazu: 0.71 ms Po ostatnom dotaze: 1.98 ms Pamäť pre dotazy: 0.024 MB pamäť pred dotazom: 1.958 MB Vrátené riadky: 0
   Duplicitné dotazy: #8

   SELECT `manifest_cache`
   
     FROM `cwdeu_extensions`
   
     WHERE `type` = 'component' 
     AND `name` = 'com_admintools'

   Vysvetlenie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	cwdeu_extensions	ref	extension	extension	82	const	39	Using where

   Profil

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   System lock	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.06 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	0.29 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.03 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   13	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
   12	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
   11	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:290
   10	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
   9	FOF30\Container\Container::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:813
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
   7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

   ---

10. Čas dotazu: 0.28 ms Po ostatnom dotaze: 0.10 ms Pamäť pre dotazy: 0.023 MB pamäť pred dotazom: 1.964 MB Vrátené riadky: 0

    SELECT `value`
    
      FROM `cwdeu_admintools_storage`
    
      WHERE `key` = 'cparams'

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.00 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:123
    12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:53
    11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:41
    10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:278
    9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:831
    8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
    7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

11. Čas dotazu: 0.39 ms Po ostatnom dotaze: 0.21 ms Pamäť pre dotazy: 0.024 MB pamäť pred dotazom: 1.973 MB Vrátené riadky: 0

    SELECT *
    
      FROM `cwdeu_admintools_wafexceptions`
    
      WHERE NOT(`option` LIKE 'com_%')

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cwdeu_admintools_wafexceptions	ALL	NULL	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	Using where

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:549
    10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:460
    9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:843
    8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
    7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

12. Čas dotazu: 0.93 ms Po ostatnom dotaze: 5.17 ms Pamäť pre dotazy: 0.023 MB pamäť pred dotazom: 2.068 MB Vrátené riadky: 1

    SHOW VARIABLES LIKE "collation_database"

    Vysvetlenie

    Nie je možné VYSVETLENIE na dotaz: SHOW VARIABLES LIKE "collation_database"

    Profil

    Status	Duration
    starting	0.03 ms
    Opening tables	0.04 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.56 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.02 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/mysqli.php:342
    11	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
    10	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
    8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

13. Čas dotazu: 0.39 ms Po ostatnom dotaze: 0.11 ms Pamäť pre dotazy: 0.023 MB pamäť pred dotazom: 2.077 MB Vrátené riadky: 0

    SELECT `source`,`keepurlparams`
    
      FROM `cwdeu_admintools_redirects`
    
      WHERE ((`dest` = 'extraliga/oblastne-ligy/janikovska-sipkarska-liga') OR (`dest` = 'extraliga/oblastne-ligy/janikovska-sipkarska-liga') OR ('extraliga/oblastne-ligy/janikovska-sipkarska-liga' LIKE `dest`)) 
      AND `published` = '1'
    
      ORDER BY `ordering` DESC 
      LIMIT 1

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cwdeu_admintools_redirects	ALL	NULL	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	Using where; Pomocou filesort

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.04 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1767
    11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:89
    10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
    8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

14. Čas dotazu: 3.22 ms Po ostatnom dotaze: 0.79 ms Pamäť pre dotazy: 0.093 MB pamäť pred dotazom: 2.184 MB Vrátené riadky: 51

    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 cwdeu_menu AS m
    
      LEFT JOIN cwdeu_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

    Vysvetlenie

    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	91	Using where; Pomocou filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	db65955xsipky.m.component_id	1

    Profil

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.01 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.58 ms
    Sending data	0.99 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.04 ms
    freeing items	0.64 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Rovnaké, ako volanie o riadok nižšie.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
    13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
    11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
    10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
    8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
    6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

15. Čas dotazu: 0.71 ms Po ostatnom dotaze: 3.71 ms Pamäť pre dotazy: 0.024 MB pamäť pred dotazom: 2.535 MB Vrátené riadky: 4

    SELECT id, home, template, s.params
    
      FROM cwdeu_template_styles as s
    
      LEFT JOIN cwdeu_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

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	6	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	db65955xsipky.s.template,const	1	Using where

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.17 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.04 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:320
    9	T3::detect()	JROOT/plugins/system/t3/t3.php:81
    8	plgSystemT3->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:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

16. Čas dotazu: 0.57 ms Po ostatnom dotaze: 3.93 ms Pamäť pre dotazy: 0.025 MB pamäť pred dotazom: 2.722 MB Vrátené riadky: 1

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

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cwdeu_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where

    Profil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.11 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Rovnaké, ako volanie o riadok nižšie.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1119
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

17. Čas dotazu: 0.55 ms Po ostatnom dotaze: 0.13 ms Pamäť pre dotazy: 0.005 MB pamäť pred dotazom: 2.714 MB

    UPDATE `cwdeu_extensions`
    
      SET `params` = '{\"mediaversion\":\"5358a27af509cf20c4d886328820ca8f\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Vysvetlenie

    Nie je možné VYSVETLENIE na dotaz: UPDATE `cwdeu_extensions` SET `params` = '{\"mediaversion\":\"5358a27af509cf20c4d886328820ca8f\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.10 ms
    Updating	0.10 ms
    end	0.01 ms
    Waiting for query cache lock	0.00 ms
    end	0.03 ms
    query end	0.07 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1119
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

18. Čas dotazu: 0.98 ms Po ostatnom dotaze: 0.39 ms Pamäť pre dotazy: 0.025 MB pamäť pred dotazom: 2.750 MB Vrátené riadky: 1

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

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cwdeu_languages	ALL	NULL	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	Using where; Pomocou filesort

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.03 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.05 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

19. Čas dotazu: 1.65 ms Po ostatnom dotaze: 2.69 ms Pamäť pre dotazy: 0.031 MB pamäť pred dotazom: 2.946 MB Vrátené riadky: 39

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

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cwdeu_assets	range	idx_asset_name	idx_asset_name	202	NULL	40	Using where

    Profil

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.10 ms
    optimizing	0.01 ms
    statistics	0.28 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.85 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
    13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

20. Čas dotazu: 5.17 ms Po ostatnom dotaze: 0.19 ms Pamäť pre dotazy: 0.164 MB pamäť pred dotazom: 2.997 MB Vrátené riadky: 925

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `cwdeu_assets`
    
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cwdeu_assets	ALL	idx_asset_name,idx_parent_id	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1001	Using where

    Profil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.03 ms
    optimizing	0.01 ms
    statistics	0.13 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	3.82 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.73 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
    13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

21. Čas dotazu: 1.57 ms Po ostatnom dotaze: 2.33 ms Pamäť pre dotazy: 0.038 MB pamäť pred dotazom: 3.692 MB Vrátené riadky: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
    SELECT COUNT(i.`id`)
    
      FROM `cwdeu_content` AS `i`
    
      WHERE i.`catid` = c.id 
      AND i.state = 1) AS numitems
    
      FROM `cwdeu_categories` AS `s`
    
      INNER JOIN `cwdeu_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.published = 1 
      AND s.id = 64
    
      ORDER BY c.lft

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Pomocou filesort
    1	PRIMARY	c	ALL	cat_idx,idx_left_right	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	72	Using where
    2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_catid	4	db65955xsipky.c.id	11	Using where

    Profil

    Status	Duration
    starting	0.17 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.01 ms
    init	0.09 ms
    optimizing	0.03 ms
    statistics	0.16 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.30 ms
    Sending data	0.10 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.06 ms
    executing	0.00 ms
    Sending data	0.06 ms
    executing	0.00 ms
    Sending data	0.13 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.04 ms
    freeing items	0.05 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
    13	ContentModelCategory->getCategory()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

22. Čas dotazu: 4.52 ms Po ostatnom dotaze: 1.72 ms Pamäť pre dotazy: 0.089 MB pamäť pred dotazom: 3.868 MB Vrátené riadky: 9

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM cwdeu_content AS a
    
      LEFT JOIN cwdeu_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN cwdeu_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN cwdeu_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN cwdeu_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN cwdeu_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid = 64 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-19 03:12:50') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-19 03:12:50')
    
      ORDER BY  c.lft,   
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
      LIMIT 9

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Pomocou filesort
    1	SIMPLE	a	index_merge	idx_access,idx_state,idx_catid	idx_catid,idx_state	4,1	NULL	8	Using intersect(idx_catid,idx_state); Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	db65955xsipky.a.created_by	1
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	db65955xsipky.a.modified_by	1
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	db65955xsipky.a.id	1

    Profil

    Status	Duration
    starting	0.27 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    System lock	0.02 ms
    init	0.15 ms
    optimizing	0.03 ms
    statistics	0.19 ms
    preparing	0.05 ms
    executing	0.00 ms
    Sorting result	2.25 ms
    Sending data	0.58 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.06 ms
    freeing items	0.07 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

23. Čas dotazu: 0.63 ms Po ostatnom dotaze: 0.62 ms Pamäť pre dotazy: 0.036 MB pamäť pred dotazom: 4.048 MB Vrátené riadky: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `cwdeu_contentitem_tag_map` AS m 
    
      INNER JOIN `cwdeu_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 828 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	db65955xsipky.m.tag_id	1	Using where

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.01 ms
    init	0.06 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

24. Čas dotazu: 0.59 ms Po ostatnom dotaze: 0.19 ms Pamäť pre dotazy: 0.036 MB pamäť pred dotazom: 4.068 MB Vrátené riadky: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `cwdeu_contentitem_tag_map` AS m 
    
      INNER JOIN `cwdeu_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 821 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	db65955xsipky.m.tag_id	1	Using where

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.06 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

25. Čas dotazu: 0.59 ms Po ostatnom dotaze: 0.17 ms Pamäť pre dotazy: 0.036 MB pamäť pred dotazom: 4.089 MB Vrátené riadky: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `cwdeu_contentitem_tag_map` AS m 
    
      INNER JOIN `cwdeu_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 812 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	db65955xsipky.m.tag_id	1	Using where

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.01 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

26. Čas dotazu: 0.59 ms Po ostatnom dotaze: 0.17 ms Pamäť pre dotazy: 0.036 MB pamäť pred dotazom: 4.110 MB Vrátené riadky: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `cwdeu_contentitem_tag_map` AS m 
    
      INNER JOIN `cwdeu_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 808 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	db65955xsipky.m.tag_id	1	Using where

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.01 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

27. Čas dotazu: 0.61 ms Po ostatnom dotaze: 0.16 ms Pamäť pre dotazy: 0.036 MB pamäť pred dotazom: 4.131 MB Vrátené riadky: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `cwdeu_contentitem_tag_map` AS m 
    
      INNER JOIN `cwdeu_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 804 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	db65955xsipky.m.tag_id	1	Using where

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.01 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

28. Čas dotazu: 0.59 ms Po ostatnom dotaze: 0.16 ms Pamäť pre dotazy: 0.036 MB pamäť pred dotazom: 4.152 MB Vrátené riadky: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `cwdeu_contentitem_tag_map` AS m 
    
      INNER JOIN `cwdeu_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 796 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	db65955xsipky.m.tag_id	1	Using where

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

29. Čas dotazu: 0.51 ms Po ostatnom dotaze: 0.16 ms Pamäť pre dotazy: 0.036 MB pamäť pred dotazom: 4.172 MB Vrátené riadky: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `cwdeu_contentitem_tag_map` AS m 
    
      INNER JOIN `cwdeu_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 792 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	db65955xsipky.m.tag_id	1	Using where

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

30. Čas dotazu: 0.47 ms Po ostatnom dotaze: 0.16 ms Pamäť pre dotazy: 0.036 MB pamäť pred dotazom: 4.193 MB Vrátené riadky: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `cwdeu_contentitem_tag_map` AS m 
    
      INNER JOIN `cwdeu_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 787 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	db65955xsipky.m.tag_id	1	Using where

    Profil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

31. Čas dotazu: 0.60 ms Po ostatnom dotaze: 0.16 ms Pamäť pre dotazy: 0.036 MB pamäť pred dotazom: 4.214 MB Vrátené riadky: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `cwdeu_contentitem_tag_map` AS m 
    
      INNER JOIN `cwdeu_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 781 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	db65955xsipky.m.tag_id	1	Using where

    Profil

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.01 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

32. Čas dotazu: 1.87 ms Po ostatnom dotaze: 1.13 ms Pamäť pre dotazy: 0.026 MB pamäť pred dotazom: 4.323 MB Vrátené riadky: 1

    SELECT COUNT(*)
    
      FROM cwdeu_content AS a
    
      LEFT JOIN cwdeu_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN cwdeu_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN cwdeu_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN cwdeu_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN cwdeu_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid = 64 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-19 03:12:50') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-19 03:12:50')

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	SIMPLE	a	index_merge	idx_access,idx_state,idx_catid	idx_catid,idx_state	4,1	NULL	8	Using intersect(idx_catid,idx_state); Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	db65955xsipky.a.created_by	1	Using index
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	db65955xsipky.a.modified_by	1	Using index
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using index
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	db65955xsipky.a.id	1	Using index

    Profil

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    System lock	0.02 ms
    init	0.06 ms
    optimizing	0.03 ms
    statistics	0.18 ms
    preparing	0.05 ms
    executing	0.01 ms
    Sending data	1.10 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.05 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    17	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
    16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
    15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
    14	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

33. Čas dotazu: 0.54 ms Po ostatnom dotaze: 0.18 ms Pamäť pre dotazy: 0.036 MB pamäť pred dotazom: 4.334 MB Vrátené riadky: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `cwdeu_contentitem_tag_map` AS m 
    
      INNER JOIN `cwdeu_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.category' 
      AND `m`.`content_item_id` = 64 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	db65955xsipky.m.tag_id	1	Using where

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

34. Čas dotazu: 1.26 ms Po ostatnom dotaze: 12.09 ms Pamäť pre dotazy: 0.039 MB pamäť pred dotazom: 5.646 MB Vrátené riadky: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `cwdeu_categories` AS `s`
    
      INNER JOIN `cwdeu_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 64
    
      ORDER BY c.lft

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Pomocou filesort
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	72	Using where

    Profil

    Status	Duration
    starting	0.14 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.07 ms
    optimizing	0.03 ms
    statistics	0.21 ms
    preparing	0.04 ms
    executing	0.00 ms
    Sorting result	0.32 ms
    Sending data	0.14 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
    17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

35. Čas dotazu: 0.93 ms Po ostatnom dotaze: 0.17 ms Pamäť pre dotazy: 0.037 MB pamäť pred dotazom: 5.668 MB Vrátené riadky: 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 cwdeu_fields AS a
    
      LEFT JOIN `cwdeu_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN cwdeu_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN cwdeu_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN cwdeu_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN cwdeu_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `cwdeu_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (64,0,67)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Vysvetlenie

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

    Profil

    Status	Duration
    starting	0.17 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    System lock	0.01 ms
    init	0.09 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.05 ms
    executing	0.00 ms
    Sorting result	0.05 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

36. Čas dotazu: 1.27 ms Po ostatnom dotaze: 45.03 ms Pamäť pre dotazy: 0.030 MB pamäť pred dotazom: 6.974 MB Vrátené riadky: 7

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM cwdeu_modules AS m
    
      LEFT JOIN cwdeu_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN cwdeu_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 <= '2020-01-19 03:12:50') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-01-19 03:12:50') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 192 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	9	Using where; Pomocou filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	db65955xsipky.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	db65955xsipky.m.module,const	1	Using where

    Profil

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    System lock	0.01 ms
    init	0.07 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.05 ms
    executing	0.01 ms
    Sorting result	0.18 ms
    Sending data	0.33 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.06 ms
    freeing items	0.05 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    19	JDatabaseDriver->loadObjectList()	Rovnaké, ako volanie o riadok nižšie.
    18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452
    16	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382
    15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87
    14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:645
    12	T3Template->countModules()	JROOT/templates/purity_iii/tpls/blocks/header.php:62
    11	include JROOT/templates/purity_iii/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:195
    10	T3Template->loadBlock()	JROOT/templates/purity_iii/tpls/default.php:37
    9	include JROOT/templates/purity_iii/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:221
    8	T3Template->loadLayout()	JROOT/templates/purity_iii/index.php:35
    7	require JROOT/templates/purity_iii/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:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

37. Čas dotazu: 1.34 ms Po ostatnom dotaze: 27.32 ms Pamäť pre dotazy: 0.034 MB pamäť pred dotazom: 9.419 MB Vrátené riadky: 18

    SHOW FULL COLUMNS 
      FROM `cwdeu_jev_users`

    Vysvetlenie

    Nie je možné VYSVETLENIE na dotaz: SHOW FULL COLUMNS FROM `cwdeu_jev_users`

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.30 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.02 ms
    checking permissions	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    Sending data	0.20 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.11 ms
    closing tables	0.00 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    20	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:69
    19	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:2308
    18	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1201
    17	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:50
    16	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
    15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
    14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:923
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/alternative/latest.php:28
    11	AlternativeModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/plugins/system/t3/includes/joomla4/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:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

38. Čas dotazu: 1.05 ms Po ostatnom dotaze: 1.66 ms Pamäť pre dotazy: 0.041 MB pamäť pred dotazom: 9.550 MB Vrátené riadky: 6

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `cwdeu_categories` AS `c`
    
      WHERE (c.extension='com_jevents' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1
    
      ORDER BY c.lft

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	range	cat_idx,idx_access	cat_idx	207	NULL	8	Using where; Pomocou filesort

    Profil

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.06 ms
    optimizing	0.02 ms
    statistics	0.15 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.15 ms
    Sending data	0.21 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    21	Joomla\CMS\Categories\Categories->_load()	JROOT/components/com_jevents/helpers/category.php:47
    20	JEventsCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    19	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:77
    18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:886
    17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
    16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
    15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
    14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:923
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/alternative/latest.php:28
    11	AlternativeModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/plugins/system/t3/includes/joomla4/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:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

39. Čas dotazu: 0.71 ms Po ostatnom dotaze: 0.20 ms Pamäť pre dotazy: 0.027 MB pamäť pred dotazom: 9.586 MB Vrátené riadky: 5

    SELECT c.id
    
      FROM cwdeu_categories AS c
    
      WHERE c.access   IN (1,1,5)
     
      AND c.published = 1
      
      AND c.language in ('sk-SK','*')
     
      AND c.extension = 'com_jevents'
     
    
      ORDER BY c.lft asc

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	range	cat_idx,idx_access,idx_language	cat_idx	207	NULL	6	Using where; Pomocou filesort

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.15 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.14 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    19	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:186
    18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:886
    17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
    16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
    15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
    14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:923
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/alternative/latest.php:28
    11	AlternativeModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/plugins/system/t3/includes/joomla4/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:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

40. Čas dotazu: 4.89 ms Po ostatnom dotaze: 0.82 ms Pamäť pre dotazy: 0.067 MB pamäť pred dotazom: 9.640 MB Vrátené riadky: 10

    SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created 
     , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
     , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
     , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
     , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
     
      FROM cwdeu_jevents_repetition as rpt
     
      INNER JOIN cwdeu_jevents_vevent as ev 
      ON rpt.eventid = ev.ev_id
     
      INNER JOIN cwdeu_jevents_icsfile as icsf 
      ON icsf.ics_id=ev.icsid 
     
      INNER JOIN cwdeu_jevents_vevdetail as det 
      ON det.evdet_id = rpt.eventdetail_id
     
      LEFT JOIN cwdeu_jevents_rrule as rr 
      ON rr.eventid = rpt.eventid
     
      WHERE ev.catid IN(-1,26,34,35,46,69)
     
      AND rpt.endrepeat >= '2020-01-19 04:12:50' 
      AND rpt.startrepeat <= '2020-02-18 23:59:59'
     
      AND (rpt.startrepeat >= '2020-01-19 00:00:00' OR  det.multiday=1) 
      AND ev.state=1
     
      AND ev.access  IN (1,1,5)  
      AND icsf.state=1 
     
      AND icsf.access  IN (1,1,5)
     
      GROUP BY rpt.startrepeat , rpt.rp_id
    						
      ORDER BY rpt.startrepeat ASC 
      LIMIT 10

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	icsf	ref	PRIMARY,stateidx	stateidx	1	const	1	Using where; Using temporary; Pomocou filesort
    1	SIMPLE	ev	ref	PRIMARY,icsid,stateidx,evaccess	stateidx	1	const	37	Using where
    1	SIMPLE	rpt	ref	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	eventid	4	db65955xsipky.ev.ev_id	1	Using where
    1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	db65955xsipky.rpt.eventdetail_id	1	Using where
    1	SIMPLE	rr	ref	eventid	eventid	4	db65955xsipky.rpt.eventid	1

    Profil

    Status	Duration
    starting	0.18 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    System lock	0.02 ms
    init	0.14 ms
    optimizing	0.04 ms
    statistics	0.20 ms
    preparing	0.06 ms
    Creating tmp table	0.52 ms
    executing	0.00 ms
    Copying to tmp table	2.22 ms
    Sorting result	0.25 ms
    Sending data	0.58 ms
    end	0.01 ms
    removing tmp table	0.11 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.08 ms
    freeing items	0.06 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2584
    15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:73
    14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1423
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/alternative/latest.php:28
    11	AlternativeModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/plugins/system/t3/includes/joomla4/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:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

41. Čas dotazu: 2.69 ms Po ostatnom dotaze: 4.68 ms Pamäť pre dotazy: 0.051 MB pamäť pred dotazom: 10.289 MB Vrátené riadky: 0

    SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created 
     , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
     , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
     , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
     , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
     
      FROM cwdeu_jevents_repetition as rpt
     
      INNER JOIN cwdeu_jevents_vevent as ev 
      ON rpt.eventid = ev.ev_id
     
      INNER JOIN cwdeu_jevents_icsfile as icsf 
      ON icsf.ics_id=ev.icsid 
     
      INNER JOIN cwdeu_jevents_vevdetail as det 
      ON det.evdet_id = rpt.eventdetail_id
     
      LEFT JOIN cwdeu_jevents_rrule as rr 
      ON rr.eventid = rpt.eventid
     
      WHERE ev.catid IN(-1,26,34,35,46,69)
     
      AND rpt.endrepeat >= '2020-01-19 00:00:00' 
      AND rpt.startrepeat <= '2020-01-19 04:12:50'
     
      AND (rpt.startrepeat >= '2020-01-19 00:00:00' OR  det.multiday=1) 
      AND ev.state=1
     
      AND ev.access  IN (1,1,5)  
      AND icsf.state=1 
     
      AND icsf.access  IN (1,1,5)
     
      GROUP BY rpt.startrepeat , rpt.rp_id
    							
      ORDER BY rpt.startrepeat desc 
      LIMIT 10

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	icsf	ref	PRIMARY,stateidx	stateidx	1	const	1	Using where; Using temporary; Pomocou filesort
    1	SIMPLE	ev	ref	PRIMARY,icsid,stateidx,evaccess	stateidx	1	const	37	Using where
    1	SIMPLE	rpt	ref	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	eventid	4	db65955xsipky.ev.ev_id	1	Using where
    1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	db65955xsipky.rpt.eventdetail_id	1	Using where
    1	SIMPLE	rr	ref	eventid	eventid	4	db65955xsipky.rpt.eventid	1

    Profil

    Status	Duration
    starting	0.18 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    System lock	0.01 ms
    init	0.14 ms
    optimizing	0.04 ms
    statistics	0.19 ms
    preparing	0.06 ms
    Creating tmp table	0.49 ms
    executing	0.00 ms
    Copying to tmp table	0.96 ms
    Sorting result	0.03 ms
    Sending data	0.12 ms
    end	0.01 ms
    removing tmp table	0.09 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.06 ms
    freeing items	0.05 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2584
    15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:73
    14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1466
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/alternative/latest.php:28
    11	AlternativeModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/plugins/system/t3/includes/joomla4/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:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

42. Čas dotazu: 3.60 ms Po ostatnom dotaze: 0.13 ms Pamäť pre dotazy: 0.063 MB pamäť pred dotazom: 10.298 MB Vrátené riadky: 8

    SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created 
     , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
     , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
     , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
     , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
     
      FROM cwdeu_jevents_repetition as rpt
     
      INNER JOIN cwdeu_jevents_vevent as ev 
      ON rpt.eventid = ev.ev_id
     
      INNER JOIN cwdeu_jevents_icsfile as icsf 
      ON icsf.ics_id=ev.icsid 
     
      INNER JOIN cwdeu_jevents_vevdetail as det 
      ON det.evdet_id = rpt.eventdetail_id
     
      LEFT JOIN cwdeu_jevents_rrule as rr 
      ON rr.eventid = rpt.eventid
     
      WHERE ev.catid IN(-1,26,34,35,46,69)
     
      AND rpt.endrepeat >= '2020-01-19 00:00:00' 
      AND rpt.startrepeat <= '2020-01-19 04:12:50'
     
      AND (rpt.startrepeat <= '2020-01-19 00:00:00'OR  det.multiday=1) 
      AND ev.state=1
     
      AND ev.access  IN (1,1,5)  
      AND icsf.state=1 
     
      AND icsf.access  IN (1,1,5)
     
      GROUP BY rpt.startrepeat , rpt.rp_id
    							
      ORDER BY rpt.startrepeat asc 
      LIMIT 10

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	icsf	ref	PRIMARY,stateidx	stateidx	1	const	1	Using where; Using temporary; Pomocou filesort
    1	SIMPLE	ev	ref	PRIMARY,icsid,stateidx,evaccess	stateidx	1	const	37	Using where
    1	SIMPLE	rpt	ref	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	eventid	4	db65955xsipky.ev.ev_id	1	Using where
    1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	db65955xsipky.rpt.eventdetail_id	1	Using where
    1	SIMPLE	rr	ref	eventid	eventid	4	db65955xsipky.rpt.eventid	1

    Profil

    Status	Duration
    starting	0.16 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    System lock	0.01 ms
    init	0.13 ms
    optimizing	0.03 ms
    statistics	0.17 ms
    preparing	0.05 ms
    Creating tmp table	0.46 ms
    executing	0.00 ms
    Copying to tmp table	1.43 ms
    Sorting result	0.14 ms
    Sending data	0.49 ms
    end	0.01 ms
    removing tmp table	0.10 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.06 ms
    freeing items	0.06 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2584
    15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:73
    14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1508
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/alternative/latest.php:28
    11	AlternativeModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/plugins/system/t3/includes/joomla4/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:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

43. Čas dotazu: 0.82 ms Po ostatnom dotaze: 5.43 ms Pamäť pre dotazy: 0.034 MB pamäť pred dotazom: 10.574 MB Vrátené riadky: 7

    SELECT c.* 
      FROM cwdeu_categories as c 
      WHERE extension='com_jevents' 
      order by c.lft asc

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ref	cat_idx	cat_idx	202	const	7	Using where; Pomocou filesort

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.04 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.15 ms
    Sending data	0.21 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/commonfunctions.php:92
    14	JEV_CommonFunctions::getCategoryData()	JROOT/components/com_jevents/libraries/commonfunctions.php:117
    13	JEV_CommonFunctions::setColor()	JROOT/components/com_jevents/libraries/jeventcal.php:313
    12	jEventCal->bgcolor()	JROOT/modules/mod_jevents_latest/tmpl/alternative/latest.php:93
    11	AlternativeModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/plugins/system/t3/includes/joomla4/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:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

44. Čas dotazu: 0.45 ms Po ostatnom dotaze: 6.38 ms Pamäť pre dotazy: 0.035 MB pamäť pred dotazom: 10.538 MB Vrátené riadky: 0
    Duplicitné dotazy: #47  #53  #58

    SELECT *
    
      FROM cwdeu_banners
    
      WHERE '2020-01-19 03:12:50' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	NULL	Impossible WHERE

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.06 ms
    optimizing	0.02 ms
    executing	0.05 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
    11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/t3/includes/joomla4/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:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

45. Čas dotazu: 0.80 ms Po ostatnom dotaze: 0.77 ms Pamäť pre dotazy: 0.027 MB pamäť pred dotazom: 10.608 MB Vrátené riadky: 1

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM cwdeu_banners as a
    
      LEFT JOIN cwdeu_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-19 03:12:50') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-19 03:12:50') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (15)
    
      ORDER BY a.sticky DESC,a.ordering 
      LIMIT 5

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_banner_catid	idx_banner_catid	4	const	1	Using where; Pomocou filesort
    1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	db65955xsipky.a.cid	1

    Profil

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.01 ms
    init	0.07 ms
    optimizing	0.03 ms
    statistics	0.08 ms
    preparing	0.04 ms
    executing	0.00 ms
    Sorting result	0.07 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:205
    12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/t3/includes/joomla4/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:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

46. Čas dotazu: 0.47 ms Po ostatnom dotaze: 0.09 ms Pamäť pre dotazy: 0.006 MB pamäť pred dotazom: 10.621 MB

    UPDATE cwdeu_banners
    
      SET impmade = (impmade + 1)
    
      WHERE id IN (5)

    Vysvetlenie

    Nie je možné VYSVETLENIE na dotaz: UPDATE cwdeu_banners SET impmade = (impmade + 1) WHERE id IN (5)

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.05 ms
    Updating	0.09 ms
    end	0.01 ms
    Waiting for query cache lock	0.00 ms
    end	0.01 ms
    query end	0.09 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:249
    12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/t3/includes/joomla4/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:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

47. Čas dotazu: 0.45 ms Po ostatnom dotaze: 0.92 ms Pamäť pre dotazy: 0.035 MB pamäť pred dotazom: 10.623 MB Vrátené riadky: 0
    Duplicitné dotazy: #44  #53  #58

    SELECT *
    
      FROM cwdeu_banners
    
      WHERE '2020-01-19 03:12:50' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	NULL	Impossible WHERE

    Profil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.06 ms
    optimizing	0.02 ms
    executing	0.05 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
    11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/t3/includes/joomla4/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:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

48. Čas dotazu: 0.78 ms Po ostatnom dotaze: 0.13 ms Pamäť pre dotazy: 0.028 MB pamäť pred dotazom: 10.633 MB Vrátené riadky: 4

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM cwdeu_banners as a
    
      LEFT JOIN cwdeu_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-19 03:12:50') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-19 03:12:50') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (16)
    
      ORDER BY a.sticky DESC,a.ordering 
      LIMIT 5

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_banner_catid	idx_banner_catid	4	const	6	Using where; Pomocou filesort
    1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	db65955xsipky.a.cid	1

    Profil

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.06 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.04 ms
    executing	0.00 ms
    Sorting result	0.10 ms
    Sending data	0.12 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:205
    12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/t3/includes/joomla4/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:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

49. Čas dotazu: 0.52 ms Po ostatnom dotaze: 0.12 ms Pamäť pre dotazy: 0.006 MB pamäť pred dotazom: 10.684 MB

    UPDATE cwdeu_banners
    
      SET impmade = (impmade + 1)
    
      WHERE id IN (27,23,21,9)

    Vysvetlenie

    Nie je možné VYSVETLENIE na dotaz: UPDATE cwdeu_banners SET impmade = (impmade + 1) WHERE id IN (27,23,21,9)

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.05 ms
    Updating	0.15 ms
    end	0.01 ms
    Waiting for query cache lock	0.00 ms
    end	0.01 ms
    query end	0.08 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:249
    12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/t3/includes/joomla4/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:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

50. Čas dotazu: 0.51 ms Po ostatnom dotaze: 0.06 ms Pamäť pre dotazy: 0.006 MB pamäť pred dotazom: 10.691 MB

    UPDATE cwdeu_banner_tracks
    
      SET `count` = (`count` + 1)
    
      WHERE track_type=1 
      AND banner_id=27 
      AND track_date='2020-01-19 03'

    Vysvetlenie

    Nie je možné VYSVETLENIE na dotaz: UPDATE cwdeu_banner_tracks SET `count` = (`count` + 1) WHERE track_type=1 AND banner_id=27 AND track_date='2020-01-19 03'

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.16 ms
    Updating	0.06 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.01 ms
    query end	0.06 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:287
    12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/t3/includes/joomla4/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:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

51. Čas dotazu: 0.48 ms Po ostatnom dotaze: 0.05 ms Pamäť pre dotazy: 0.006 MB pamäť pred dotazom: 10.697 MB

    UPDATE cwdeu_banner_tracks
    
      SET `count` = (`count` + 1)
    
      WHERE track_type=1 
      AND banner_id=23 
      AND track_date='2020-01-19 03'

    Vysvetlenie

    Nie je možné VYSVETLENIE na dotaz: UPDATE cwdeu_banner_tracks SET `count` = (`count` + 1) WHERE track_type=1 AND banner_id=23 AND track_date='2020-01-19 03'

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.15 ms
    Updating	0.05 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.01 ms
    query end	0.06 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:287
    12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/t3/includes/joomla4/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:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

52. Čas dotazu: 0.46 ms Po ostatnom dotaze: 0.05 ms Pamäť pre dotazy: 0.006 MB pamäť pred dotazom: 10.703 MB

    UPDATE cwdeu_banner_tracks
    
      SET `count` = (`count` + 1)
    
      WHERE track_type=1 
      AND banner_id=21 
      AND track_date='2020-01-19 03'

    Vysvetlenie

    Nie je možné VYSVETLENIE na dotaz: UPDATE cwdeu_banner_tracks SET `count` = (`count` + 1) WHERE track_type=1 AND banner_id=21 AND track_date='2020-01-19 03'

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.13 ms
    Updating	0.05 ms
    end	0.01 ms
    Waiting for query cache lock	0.00 ms
    end	0.01 ms
    query end	0.06 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:287
    12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/t3/includes/joomla4/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:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

53. Čas dotazu: 0.45 ms Po ostatnom dotaze: 0.93 ms Pamäť pre dotazy: 0.035 MB pamäť pred dotazom: 10.700 MB Vrátené riadky: 0
    Duplicitné dotazy: #44  #47  #58

    SELECT *
    
      FROM cwdeu_banners
    
      WHERE '2020-01-19 03:12:50' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	NULL	Impossible WHERE

    Profil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.06 ms
    optimizing	0.02 ms
    executing	0.06 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695