{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1579403404,
                "last": 1579403404,
                "now": 1579403404
            },
            "token": "VrS6PhCDBK7rfWcT3T5F95Nz0MjOkhZo"
        },
        "registry": {
            "com_contact": {
                "contact": {
                    "data": {
                        "catid": "4"
                    }
                }
            },
            "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: 58 61.40 ms

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

   SELECT `data`
   
     FROM `cwdeu_session`
   
     WHERE `session_id` = '0ef78360c89c147bf2dd72173999f588'

   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.04 ms
   preparing	0.01 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.40 ms Po ostatnom dotaze: 0.37 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 1.285 MB Vrátené riadky: 0

   SELECT `session_id`
   
     FROM `cwdeu_session`
   
     WHERE `session_id` = '0ef78360c89c147bf2dd72173999f588' 
     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.01 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
   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.38 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 
   ('0ef78360c89c147bf2dd72173999f588', 1, 1579403404, 0, '', 0)

   Vysvetlenie

   Nie je možné VYSVETLENIE na dotaz: INSERT INTO `cwdeu_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('0ef78360c89c147bf2dd72173999f588', 1, 1579403404, 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.00 ms
   update	0.01 ms
   end	0.00 ms
   query end	0.06 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
   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.98 ms Po ostatnom dotaze: 0.53 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.01 ms
   Sending data	0.45 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
   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.43 ms Po ostatnom dotaze: 0.48 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.53 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.06 ms
   checking permissions	0.01 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.08 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	0.05 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
   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.403 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.85 ms
   Sending data	0.71 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.75 ms Po ostatnom dotaze: 4.77 ms Pamäť pre dotazy: 0.024 MB pamäť pred dotazom: 1.865 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.01 ms
   statistics	0.06 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	0.30 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.03 ms
   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.75 ms Po ostatnom dotaze: 2.01 ms Pamäť pre dotazy: 0.024 MB pamäť pred dotazom: 1.957 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.30 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.29 ms Po ostatnom dotaze: 0.11 ms Pamäť pre dotazy: 0.023 MB pamäť pred dotazom: 1.963 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.42 ms Po ostatnom dotaze: 0.20 ms Pamäť pre dotazy: 0.024 MB pamäť pred dotazom: 1.972 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.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: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.96 ms Po ostatnom dotaze: 5.12 ms Pamäť pre dotazy: 0.023 MB pamäť pred dotazom: 2.067 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.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.57 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.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
    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.38 ms Po ostatnom dotaze: 0.11 ms Pamäť pre dotazy: 0.023 MB pamäť pred dotazom: 2.076 MB Vrátené riadky: 0

    SELECT `source`,`keepurlparams`
    
      FROM `cwdeu_admintools_redirects`
    
      WHERE ((`dest` = 'kontakty') OR (`dest` = 'kontakty') OR ('kontakty' 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.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.01 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.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
    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.31 ms Po ostatnom dotaze: 0.77 ms Pamäť pre dotazy: 0.093 MB pamäť pred dotazom: 2.183 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.57 ms
    Sending data	0.99 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.04 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
    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.72 ms Po ostatnom dotaze: 3.78 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.04 ms
    optimizing	0.02 ms
    statistics	0.08 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.56 ms Po ostatnom dotaze: 3.87 ms Pamäť pre dotazy: 0.025 MB pamäť pred dotazom: 2.721 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.10 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.06 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
    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.51 ms Po ostatnom dotaze: 0.13 ms Pamäť pre dotazy: 0.005 MB pamäť pred dotazom: 2.713 MB

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

    Vysvetlenie

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

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.10 ms
    Updating	0.10 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
    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.53 ms Po ostatnom dotaze: 0.39 ms Pamäť pre dotazy: 0.025 MB pamäť pred dotazom: 2.749 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.01 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.03 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.70 ms Po ostatnom dotaze: 7.16 ms Pamäť pre dotazy: 0.031 MB pamäť pred dotazom: 3.138 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.11 ms
    optimizing	0.01 ms
    statistics	0.28 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.84 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
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/components/com_contact/models/contact.php:62
    14	ContactModelContact->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_contact/models/contact.php:165
    12	ContactModelContact->getItem()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Čas dotazu: 2.72 ms Po ostatnom dotaze: 0.50 ms Pamäť pre dotazy: 0.038 MB pamäť pred dotazom: 3.201 MB Vrátené riadky: 1

    SELECT a.*, 
      CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
    
      FROM cwdeu_contact_details AS a
    
      LEFT JOIN cwdeu_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN cwdeu_categories as parent 
      ON parent.id = c.parent_id
    
      WHERE a.id = 1 
      AND (a.published = 1 OR a.published =2) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-19 03:10:04') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-19 03:10:04')

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

    Profil

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.52 ms
    System lock	0.01 ms
    init	0.11 ms
    optimizing	0.03 ms
    statistics	1.39 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.10 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.07 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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    13	JDatabaseDriver->loadObject()	JROOT/components/com_contact/models/contact.php:225
    12	ContactModelContact->getItem()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Čas dotazu: 0.63 ms Po ostatnom dotaze: 0.55 ms Pamäť pre dotazy: 0.035 MB pamäť pred dotazom: 3.251 MB Vrátené riadky: 0
    Duplicitné dotazy: #26  #30

    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_contact.contact' 
      AND `m`.`content_item_id` = 1 
      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.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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_contact/models/contact.php:255
    12	ContactModelContact->getItem()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Čas dotazu: 1.37 ms Po ostatnom dotaze: 3.36 ms Pamäť pre dotazy: 0.033 MB pamäť pred dotazom: 3.666 MB Vrátené riadky: 16

    SHOW FULL COLUMNS 
      FROM `cwdeu_users`

    Vysvetlenie

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.31 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.03 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.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.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    Sending data	0.16 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.14 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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    19	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:40
    18	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
    17	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_users/models/user.php:64
    16	UsersModelUser->getTable()	JROOT/libraries/src/MVC/Model/AdminModel.php:939
    15	Joomla\CMS\MVC\Model\AdminModel->getItem()	JROOT/administrator/components/com_users/models/user.php:89
    14	UsersModelUser->getItem()	JROOT/components/com_contact/models/contact.php:395
    13	ContactModelContact->buildContactExtendedData()	JROOT/components/com_contact/models/contact.php:291
    12	ContactModelContact->getItem()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [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.90 ms Po ostatnom dotaze: 12.48 ms Pamäť pre dotazy: 0.039 MB pamäť pred dotazom: 4.242 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
    
      WHERE a.context = 'com_users.user' 
      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

    Profil

    Status	Duration
    starting	0.15 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.01 ms
    Opening tables	0.05 ms
    System lock	0.02 ms
    init	0.08 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sorting result	0.04 ms
    Sending data	0.07 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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    18	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:285
    17	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:288
    16	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT/components/com_contact/models/contact.php:411
    13	ContactModelContact->buildContactExtendedData()	JROOT/components/com_contact/models/contact.php:291
    12	ContactModelContact->getItem()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [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.87 ms Po ostatnom dotaze: 13.71 ms Pamäť pre dotazy: 0.039 MB pamäť pred dotazom: 5.327 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
    
      WHERE a.context = 'com_contact.mail' 
      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

    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.00 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    System lock	0.01 ms
    init	0.08 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.05 ms
    executing	0.01 ms
    Sorting result	0.04 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.01 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/src/MVC/Model/BaseDatabaseModel.php:308
    22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    19	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:285
    18	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:288
    17	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:321
    14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:242
    13	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_contact/models/contact.php:82
    12	ContactModelContact->getForm()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:83
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Čas dotazu: 1.48 ms Po ostatnom dotaze: 1.29 ms Pamäť pre dotazy: 0.038 MB pamäť pred dotazom: 5.479 MB Vrátené riadky: 1

    SELECT a.*, 
      CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
    
      FROM `cwdeu_contact_details` 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
    
      WHERE a.access IN (1,1,5) 
      AND a.catid = 4 
      AND c.access IN (1,1,5) 
      AND a.published = 1
    
      ORDER BY a.name asc

    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	ref	idx_access,idx_state,idx_catid	idx_state	1	const	1	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	Using index

    Profil

    Status	Duration
    starting	0.13 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.01 ms
    init	0.11 ms
    optimizing	0.02 ms
    statistics	0.54 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sorting result	0.09 ms
    Sending data	0.17 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_contact/models/category.php:91
    11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:125
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [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.51 ms Po ostatnom dotaze: 0.12 ms Pamäť pre dotazy: 0.035 MB pamäť pred dotazom: 5.507 MB Vrátené riadky: 0
    Duplicitné dotazy: #21  #30

    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_contact.contact' 
      AND `m`.`content_item_id` = 1 
      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.07 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.07 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
    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/components/com_contact/models/category.php:107
    11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:125
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Čas dotazu: 1.08 ms Po ostatnom dotaze: 9.43 ms Pamäť pre dotazy: 0.038 MB pamäť pred dotazom: 6.302 MB Vrátené riadky: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `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_contact' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 4
    
      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	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	4	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.20 ms
    preparing	0.04 ms
    executing	0.00 ms
    Sorting result	0.11 ms
    Sending data	0.12 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
    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_contact/views/contact/view.html.php:304
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [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.97 ms Po ostatnom dotaze: 0.24 ms Pamäť pre dotazy: 0.037 MB pamäť pred dotazom: 6.317 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_contact.contact' 
      AND (fc.category_id IS NULL OR fc.category_id IN (4,0)) 
      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.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    System lock	0.01 ms
    init	0.10 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.05 ms
    executing	0.00 ms
    Sorting result	0.04 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.01 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_contact/views/contact/view.html.php:304
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Čas dotazu: 1.06 ms Po ostatnom dotaze: 2.53 ms Pamäť pre dotazy: 0.040 MB pamäť pred dotazom: 6.544 MB Vrátené riadky: 1

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `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 = 4
    
      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
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	8	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.00 ms
    Sending data	0.18 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 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
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    26	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    24	ContentRouter->getCategorySegment()	Rovnaké, ako volanie o riadok nižšie.
    23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
    16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
    15	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/fb_tw_plus1/fb_tw_plus1.php:275
    14	plgContentfb_tw_plus1->InjectCode()	JROOT/plugins/content/fb_tw_plus1/fb_tw_plus1.php:71
    13	plgContentfb_tw_plus1->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_contact/views/contact/view.html.php:304
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [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.67 ms Po ostatnom dotaze: 0.77 ms Pamäť pre dotazy: 0.034 MB pamäť pred dotazom: 6.557 MB Vrátené riadky: 0
    Duplicitné dotazy: #21  #26

    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_contact.contact' 
      AND `m`.`content_item_id` = 1 
      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.02 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_contact/views/contact/view.html.php:350
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Čas dotazu: 2.14 ms Po ostatnom dotaze: 1.03 ms Pamäť pre dotazy: 0.037 MB pamäť pred dotazom: 6.588 MB Vrátené riadky: 43

    SHOW FULL COLUMNS 
      FROM `cwdeu_contact_details`

    Vysvetlenie

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.29 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.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.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.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.02 ms
    checking permissions	0.02 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.03 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    Sending data	0.40 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.11 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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_contact/tables/contact.php:39
    13	ContactTableContact->__construct()	JROOT/libraries/src/Table/Table.php:312
    12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_contact/models/contact.php:628
    11	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:368
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Čas dotazu: 0.63 ms Po ostatnom dotaze: 1.23 ms Pamäť pre dotazy: 0.038 MB pamäť pred dotazom: 6.775 MB Vrátené riadky: 1

    SELECT *
    
      FROM cwdeu_contact_details
    
      WHERE `id` = '1'

    Vysvetlenie

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

    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
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.08 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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    12	Joomla\CMS\Table\Table->load()	JROOT/components/com_contact/models/contact.php:629
    11	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:368
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [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.53 ms Po ostatnom dotaze: 0.14 ms Pamäť pre dotazy: 0.007 MB pamäť pred dotazom: 6.788 MB

    UPDATE cwdeu_contact_details
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '1'

    Vysvetlenie

    Nie je možné VYSVETLENIE na dotaz: UPDATE cwdeu_contact_details SET `hits` = (`hits` + 1) WHERE `id` = '1'

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.06 ms
    Updating	0.10 ms
    end	0.01 ms
    Waiting for query cache lock	0.00 ms
    end	0.01 ms
    query end	0.07 ms
    closing tables	0.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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1242
    12	Joomla\CMS\Table\Table->hit()	JROOT/components/com_contact/models/contact.php:630
    11	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:368
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [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.40 ms Po ostatnom dotaze: 10.84 ms Pamäť pre dotazy: 0.030 MB pamäť pred dotazom: 7.255 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:10:04') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-01-19 03:10:04') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 106 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.06 ms
    executing	0.00 ms
    Sorting result	0.25 ms
    Sending data	0.35 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.05 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
    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.]

    ---

35. Čas dotazu: 2.60 ms Po ostatnom dotaze: 26.43 ms Pamäť pre dotazy: 0.034 MB pamäť pred dotazom: 9.698 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.07 ms
    checking permissions	0.01 ms
    Opening tables	1.15 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.03 ms
    checking permissions	0.06 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.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.02 ms
    checking permissions	0.04 ms
    Sending data	0.24 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.28 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
    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.]

    ---

36. Čas dotazu: 1.29 ms Po ostatnom dotaze: 1.54 ms Pamäť pre dotazy: 0.041 MB pamäť pred dotazom: 9.828 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.16 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.07 ms
    optimizing	0.02 ms
    statistics	0.19 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.18 ms
    Sending data	0.26 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.]

    ---

37. Čas dotazu: 0.78 ms Po ostatnom dotaze: 0.22 ms Pamäť pre dotazy: 0.027 MB pamäť pred dotazom: 9.865 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.16 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.13 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.00 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.]

    ---

38. Čas dotazu: 5.57 ms Po ostatnom dotaze: 0.87 ms Pamäť pre dotazy: 0.067 MB pamäť pred dotazom: 9.918 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:10:05' 
      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.20 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.02 ms
    init	0.16 ms
    optimizing	0.05 ms
    statistics	0.22 ms
    preparing	0.06 ms
    Creating tmp table	0.83 ms
    executing	0.00 ms
    Copying to tmp table	2.24 ms
    Sorting result	0.26 ms
    Sending data	0.61 ms
    end	0.01 ms
    removing tmp table	0.12 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.09 ms
    freeing items	0.06 ms
    logging slow query	0.01 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.]

    ---

39. Čas dotazu: 3.06 ms Po ostatnom dotaze: 5.66 ms Pamäť pre dotazy: 0.051 MB pamäť pred dotazom: 10.567 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:10:05'
     
      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.21 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    System lock	0.02 ms
    init	0.16 ms
    optimizing	0.04 ms
    statistics	0.22 ms
    preparing	0.06 ms
    Creating tmp table	0.51 ms
    executing	0.00 ms
    Copying to tmp table	1.03 ms
    Sorting result	0.04 ms
    Sending data	0.12 ms
    end	0.01 ms
    removing tmp table	0.09 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.07 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: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.]

    ---

40. Čas dotazu: 3.79 ms Po ostatnom dotaze: 0.16 ms Pamäť pre dotazy: 0.063 MB pamäť pred dotazom: 10.577 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:10:05'
     
      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.17 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.02 ms
    init	0.13 ms
    optimizing	0.04 ms
    statistics	0.18 ms
    preparing	0.06 ms
    Creating tmp table	0.48 ms
    executing	0.00 ms
    Copying to tmp table	1.44 ms
    Sorting result	0.20 ms
    Sending data	0.50 ms
    end	0.01 ms
    removing tmp table	0.10 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.07 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
    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.]

    ---

41. Čas dotazu: 0.94 ms Po ostatnom dotaze: 6.62 ms Pamäť pre dotazy: 0.034 MB pamäť pred dotazom: 10.868 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.07 ms
    preparing	0.02 ms
    executing	0.01 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.]

    ---

42. Čas dotazu: 0.58 ms Po ostatnom dotaze: 7.03 ms Pamäť pre dotazy: 0.035 MB pamäť pred dotazom: 10.833 MB Vrátené riadky: 0
    Duplicitné dotazy: #45  #51  #56

    SELECT *
    
      FROM cwdeu_banners
    
      WHERE '2020-01-19 03:10:04' >= '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.01 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.]

    ---

43. Čas dotazu: 0.87 ms Po ostatnom dotaze: 0.86 ms Pamäť pre dotazy: 0.027 MB pamäť pred dotazom: 10.903 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:10:04') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-19 03:10:04') 
      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.11 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.05 ms
    executing	0.01 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.]

    ---

44. Čas dotazu: 0.47 ms Po ostatnom dotaze: 0.10 ms Pamäť pre dotazy: 0.006 MB pamäť pred dotazom: 10.916 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.04 ms
    Updating	0.08 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.]

    ---

45. Čas dotazu: 0.55 ms Po ostatnom dotaze: 0.93 ms Pamäť pre dotazy: 0.035 MB pamäť pred dotazom: 10.918 MB Vrátené riadky: 0
    Duplicitné dotazy: #42  #51  #56

    SELECT *
    
      FROM cwdeu_banners
    
      WHERE '2020-01-19 03:10:04' >= '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.]

    ---

46. Čas dotazu: 0.84 ms Po ostatnom dotaze: 0.15 ms Pamäť pre dotazy: 0.028 MB pamäť pred dotazom: 10.928 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:10:04') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-19 03:10:04') 
      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.11 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.03 ms
    statistics	0.08 ms
    preparing	0.05 ms
    executing	0.01 ms
    Sorting result	0.10 ms
    Sending data	0.12 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.]

    ---

47. Čas dotazu: 0.54 ms Po ostatnom dotaze: 0.10 ms Pamäť pre dotazy: 0.006 MB pamäť pred dotazom: 10.947 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.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
    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.]

    ---

48. Čas dotazu: 0.55 ms Po ostatnom dotaze: 0.06 ms Pamäť pre dotazy: 0.006 MB pamäť pred dotazom: 10.954 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.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.]

    ---

49. Čas dotazu: 0.49 ms Po ostatnom dotaze: 0.05 ms Pamäť pre dotazy: 0.006 MB pamäť pred dotazom: 10.960 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.14 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.]

    ---

50. Čas dotazu: 0.50 ms Po ostatnom dotaze: 0.05 ms Pamäť pre dotazy: 0.006 MB pamäť pred dotazom: 10.966 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.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 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.]

    ---

51. Čas dotazu: 0.55 ms Po ostatnom dotaze: 1.03 ms Pamäť pre dotazy: 0.035 MB pamäť pred dotazom: 10.964 MB Vrátené riadky: 0
    Duplicitné dotazy: #42  #45  #56

    SELECT *
    
      FROM cwdeu_banners
    
      WHERE '2020-01-19 03:10:04' >= '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.]

    ---

52. Čas dotazu: 0.88 ms Po ostatnom dotaze: 0.15 ms Pamäť pre dotazy: 0.028 MB pamäť pred dotazom: 10.974 MB Vrátené riadky: 5

    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:10:04') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-19 03:10:04') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (17)
    
      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	10	Using where; Pomocou filesort
    1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	db65955xsipky.a.cid	1

    Profil

    Status	Duration
    starting	0.11 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.03 ms
    statistics	0.08 ms
    preparing	0.04 ms
    executing	0.00 ms
    Sorting result	0.12 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.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.]

    ---

53. Čas dotazu: 0.55 ms Po ostatnom dotaze: 0.10 ms Pamäť pre dotazy: 0.006 MB pamäť pred dotazom: 10.996 MB

    UPDATE cwdeu_banners
    
      SET impmade = (impmade + 1)
    
      WHERE id IN (4,16,15,26,22)

    Vysvetlenie

    Nie je možné VYSVETLENIE na dotaz: UPDATE cwdeu_banners SET impmade = (impmade + 1) WHERE id IN (4,16,15,26,22)

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.06 ms
    Updating	0.18 ms
    end	0.01 ms
    Waiting for query cache lock	0.00 ms
    end	0.01 ms
    query end	0.07 ms
    closing tables	0.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.]

    ---

54. Čas dotazu: 0.52 ms Po ostatnom dotaze: 0.05 ms Pamäť pre dotazy: 0.006 MB pamäť pred dotazom: 11.002 MB

    UPDATE cwdeu_banner_tracks
    
      SET `count` = (`count` + 1)
    
      WHERE track_type=1 
      AND banner_id=26 
      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=26 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.14 ms
    Updating	0.06 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.]

    ---

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

    UPDATE cwdeu_banner_tracks
    
      SET `count` = (`count` + 1)
    
      WHERE track_type=1 
      AND banner_id=22 
      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=22 AND track_date='2020-01-19 03'

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 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.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/components/co