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

Čas

Pamäť

Zaznamenané dotazy: 28 66.04 ms

1. Čas dotazu: 0.38 ms Pamäť pre dotazy: 0.023 MB pamäť pred dotazom: 3.689 MB Vrátené riadky: 0

   SELECT `data`
   
     FROM `mw4r8_session`
   
     WHERE `session_id` = X'3331683761653263716e65613035686d317175716c6a306c6664'

   Vysvetlenie

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

   Profil

   Status	Duration
   Starting	0.07 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.05 ms
   Preparing	0.01 ms
   Executing	0.02 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.00 ms
   closing tables	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.03 ms

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   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.29 ms Po ostatnom dotaze: 1.58 ms Pamäť pre dotazy: 0.020 MB pamäť pred dotazom: 3.798 MB Vrátené riadky: 0

   SELECT `session_id`
   
     FROM `mw4r8_session`
   
     WHERE `session_id` = X'3331683761653263716e65613035686d317175716c6a306c6664' 
     LIMIT 1

   Vysvetlenie

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

   Profil

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.02 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.02 ms

   Zásobník volaní

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

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

   ---

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

   INSERT INTO `mw4r8_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3331683761653263716e65613035686d317175716c6a306c6664', 1, 1732170553, 0, '', 0)

   Vysvetlenie

   Nie je možné VYSVETLENIE na dotaz: INSERT INTO `mw4r8_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3331683761653263716e65613035686d317175716c6a306c6664', 1, 1732170553, 0, '', 0)

   Profil

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init for update	0.02 ms
   Update	0.06 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	26.07 ms
   closing tables	0.02 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.02 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.68 ms Po ostatnom dotaze: 3.31 ms Pamäť pre dotazy: 0.024 MB pamäť pred dotazom: 4.102 MB Vrátené riadky: 39

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `mw4r8_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	mw4r8_extensions	ref	extension	extension	82	const	39	Using index condition; Using where

   Profil

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.03 ms
   Optimizing	0.03 ms
   Statistics	0.08 ms
   Preparing	0.05 ms
   Executing	0.01 ms
   Sending data	0.23 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.02 ms
   Reset for next command	0.02 ms

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	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.32 ms Po ostatnom dotaze: 2.84 ms Pamäť pre dotazy: 0.021 MB pamäť pred dotazom: 4.314 MB Vrátené riadky: 5

   SELECT id, rules
   
     FROM `mw4r8_viewlevels`

   Vysvetlenie

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

   Profil

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.02 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.04 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.02 ms

   Zásobník volaní

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

   [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.35 ms Po ostatnom dotaze: 0.10 ms Pamäť pre dotazy: 0.021 MB pamäť pred dotazom: 4.325 MB Vrátené riadky: 1

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

   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	1	Using where; Using index

   Profil

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.06 ms
   Preparing	0.01 ms
   Unlocking tables	0.01 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.02 ms
   Reset for next command	0.02 ms

   Zásobník volaní

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

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

   ---

7. Čas dotazu: 0.81 ms Po ostatnom dotaze: 0.65 ms Pamäť pre dotazy: 0.030 MB pamäť pred dotazom: 4.396 MB Vrátené riadky: 104

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

   Vysvetlenie

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

   Profil

   Status	Duration
   Starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.04 ms
   Preparing	0.02 ms
   Sorting result	0.01 ms
   Executing	0.01 ms
   Sending data	0.01 ms
   Creating sort index	0.46 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.02 ms
   Reset for next command	0.02 ms

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	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.97 ms Po ostatnom dotaze: 23.22 ms Pamäť pre dotazy: 0.048 MB pamäť pred dotazom: 6.311 MB Vrátené riadky: 22

   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 mw4r8_menu AS m
   
     LEFT JOIN mw4r8_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	108	Using index condition; Using where; Pomocou filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	c42msnab.m.component_id	1	Using where

   Profil

   Status	Duration
   Starting	0.10 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.04 ms
   Optimizing	0.02 ms
   Statistics	0.07 ms
   Preparing	0.03 ms
   Sorting result	0.01 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Creating sort index	0.42 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.00 ms
   closing tables	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.03 ms
   Reset for next command	0.03 ms

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	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.]

   ---

9. Čas dotazu: 0.34 ms Po ostatnom dotaze: 12.66 ms Pamäť pre dotazy: 0.027 MB pamäť pred dotazom: 7.400 MB Vrátené riadky: 1

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

   Vysvetlenie

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

   Profil

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.06 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   22	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
   21	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Rovnaké, ako volanie o riadok nižšie.
   20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
   18	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
   17	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
   16	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
   15	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   14	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   13	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_acymailing/compat/joomla.php:235
   12	acymailing_addScript()	JROOT/administrator/components/com_acymailing/compat/joomla.php:37
   11	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:14
   10	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:21
   9	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:32
   8	plgSystemRegacymailing->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.]

   ---

10. Čas dotazu: 23.61 ms Po ostatnom dotaze: 0.14 ms Pamäť pre dotazy: 0.009 MB pamäť pred dotazom: 7.395 MB

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

    Vysvetlenie

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

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init for update	0.05 ms
    Updating	0.05 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	23.34 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    17	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    16	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    15	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    14	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    13	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_acymailing/compat/joomla.php:235
    12	acymailing_addScript()	JROOT/administrator/components/com_acymailing/compat/joomla.php:37
    11	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:14
    10	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:21
    9	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:32
    8	plgSystemRegacymailing->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.]

    ---

11. Čas dotazu: 0.42 ms Po ostatnom dotaze: 5.79 ms Pamäť pre dotazy: 0.027 MB pamäť pred dotazom: 8.051 MB Vrátené riadky: 81

    SELECT * 
      FROM mw4r8_acymailing_config

    Vysvetlenie

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

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.10 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
    12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:392
    11	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1369
    10	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:21
    9	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:32
    8	plgSystemRegacymailing->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.]

    ---

12. Čas dotazu: 0.45 ms Po ostatnom dotaze: 3.41 ms Pamäť pre dotazy: 0.020 MB pamäť pred dotazom: 8.363 MB Vrátené riadky: 2

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

    Vysvetlenie

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

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Zásobník volaní

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

    [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.55 ms Po ostatnom dotaze: 0.25 ms Pamäť pre dotazy: 0.019 MB pamäť pred dotazom: 8.375 MB Vrátené riadky: 4

    SELECT id, home, template, s.params
    
      FROM mw4r8_template_styles as s
    
      LEFT JOIN mw4r8_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	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	4
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	c42msnab.s.template,const	1	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.08 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Čas dotazu: 0.71 ms Po ostatnom dotaze: 55.03 ms Pamäť pre dotazy: 0.029 MB pamäť pred dotazom: 10.656 MB Vrátené riadky: 115

    SHOW TABLES

    Vysvetlenie

    Nie je možné VYSVETLENIE na dotaz: SHOW TABLES

    Profil

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    checking permissions	0.30 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    19	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
    18	JDatabaseDriverMysqli->getTableList()	JROOT/libraries/fof/database/driver/joomla.php:252
    17	FOFDatabaseDriverJoomla->getTableList()	JROOT/libraries/fof/table/table.php:2085
    16	FOFTable->getTableFields()	JROOT/libraries/fof/table/table.php:536
    15	FOFTable->__construct()	JROOT/libraries/fof/table/table.php:433
    14	FOFTable::getAnInstance()	JROOT/libraries/fof/model/model.php:2037
    13	FOFModel->_createTable()	JROOT/libraries/fof/model/model.php:1994
    12	FOFModel->getTable()	JROOT/libraries/fof/model/model.php:1153
    11	FOFModel->getItem()	JROOT/components/com_spkgarten/models/courses.php:82
    10	SpkgartenModelCourses->getItem()	JROOT/libraries/fof/controller/controller.php:1195
    9	FOFController->read()	JROOT/libraries/fof/controller/controller.php:967
    8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:327
    7	FOFDispatcher->dispatch()	JROOT/components/com_spkgarten/spkgarten.php:34
    6	require_once JROOT/components/com_spkgarten/spkgarten.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.]

    ---

15. Čas dotazu: 0.95 ms Po ostatnom dotaze: 0.10 ms Pamäť pre dotazy: 0.029 MB pamäť pred dotazom: 10.678 MB Vrátené riadky: 23

    SHOW FULL COLUMNS 
      FROM `mw4r8_spkgarten_courses`

    Vysvetlenie

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

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    Opening tables	0.29 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    checking permissions	0.12 ms
    closing tables	0.01 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.12 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof/database/driver/joomla.php:230
    17	FOFDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/fof/table/table.php:2170
    16	FOFTable->getTableFields()	JROOT/libraries/fof/table/table.php:536
    15	FOFTable->__construct()	JROOT/libraries/fof/table/table.php:433
    14	FOFTable::getAnInstance()	JROOT/libraries/fof/model/model.php:2037
    13	FOFModel->_createTable()	JROOT/libraries/fof/model/model.php:1994
    12	FOFModel->getTable()	JROOT/libraries/fof/model/model.php:1153
    11	FOFModel->getItem()	JROOT/components/com_spkgarten/models/courses.php:82
    10	SpkgartenModelCourses->getItem()	JROOT/libraries/fof/controller/controller.php:1195
    9	FOFController->read()	JROOT/libraries/fof/controller/controller.php:967
    8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:327
    7	FOFDispatcher->dispatch()	JROOT/components/com_spkgarten/spkgarten.php:34
    6	require_once JROOT/components/com_spkgarten/spkgarten.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.]

    ---

16. Čas dotazu: 0.47 ms Po ostatnom dotaze: 9.62 ms Pamäť pre dotazy: 0.024 MB pamäť pred dotazom: 10.766 MB Vrátené riadky: 1

    SELECT mw4r8_spkgarten_courses.*
    
      FROM mw4r8_spkgarten_courses
    
      WHERE `mw4r8_spkgarten_courses`.`spkgarten_course_id` = '2'

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	mw4r8_spkgarten_courses	const	PRIMARY	PRIMARY	8	const	1

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/libraries/fof/database/driver/joomla.php:292
    13	FOFDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/fof/table/table.php:949
    12	FOFTable->load()	JROOT/libraries/fof/model/model.php:1154
    11	FOFModel->getItem()	JROOT/components/com_spkgarten/models/courses.php:82
    10	SpkgartenModelCourses->getItem()	JROOT/libraries/fof/controller/controller.php:1195
    9	FOFController->read()	JROOT/libraries/fof/controller/controller.php:967
    8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:327
    7	FOFDispatcher->dispatch()	JROOT/components/com_spkgarten/spkgarten.php:34
    6	require_once JROOT/components/com_spkgarten/spkgarten.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.]

    ---

17. Čas dotazu: 0.72 ms Po ostatnom dotaze: 17.35 ms Pamäť pre dotazy: 0.030 MB pamäť pred dotazom: 11.026 MB Vrátené riadky: 39

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `mw4r8_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_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_spkgarten','com_sppagebuilder','com_spsimpleportfolio','com_tags','com_templates','com_users','com_wrapper')

    Vysvetlenie

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

    Profil

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.01 ms
    Statistics	0.11 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.23 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.03 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    21	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    20	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    19	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    18	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    17	Joomla\CMS\User\User->authorise()	JROOT/libraries/fof/integration/joomla/platform.php:584
    16	FOFIntegrationJoomlaPlatform->authorise()	JROOT/libraries/fof/view/raw.php:80
    15	FOFViewRaw->__construct()	JROOT/libraries/fof/view/html.php:53
    14	FOFViewHtml->__construct()	JROOT/libraries/fof/controller/controller.php:2805
    13	FOFController->createView()	JROOT/libraries/fof/controller/controller.php:2500
    12	FOFController->getView()	JROOT/libraries/fof/controller/controller.php:2402
    11	FOFController->getThisView()	JROOT/libraries/fof/controller/controller.php:1025
    10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1218
    9	FOFController->read()	JROOT/libraries/fof/controller/controller.php:967
    8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:327
    7	FOFDispatcher->dispatch()	JROOT/components/com_spkgarten/spkgarten.php:34
    6	require_once JROOT/components/com_spkgarten/spkgarten.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.]

    ---

18. Čas dotazu: 0.80 ms Po ostatnom dotaze: 1.77 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 11.121 MB Vrátené riadky: 1
    Duplicitné dotazy: #20  #25  #26  #27

    SELECT `id`
    
      FROM `mw4r8_menu`
    
      WHERE `link` LIKE '%option=com_spkgarten&view=courses%' 
      AND `published` = '1'

    Vysvetlenie

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

    Profil

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.44 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_spkgarten/helpers/helper.php:22
    12	SpkgartenbHelper::getItemid()	JROOT/components/com_spkgarten/views/course/view.html.php:24
    11	SpkgartenViewCourse->display()	JROOT/libraries/fof/controller/controller.php:1125
    10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1218
    9	FOFController->read()	JROOT/libraries/fof/controller/controller.php:967
    8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:327
    7	FOFDispatcher->dispatch()	JROOT/components/com_spkgarten/spkgarten.php:34
    6	require_once JROOT/components/com_spkgarten/spkgarten.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.]

    ---

19. Čas dotazu: 0.53 ms Po ostatnom dotaze: 1.90 ms Pamäť pre dotazy: 0.023 MB pamäť pred dotazom: 11.168 MB Vrátené riadky: 1

    SELECT a.*
    
      FROM `mw4r8_spkgarten_classes` AS `a`
    
      WHERE `a`.`enabled` = '1' 
      AND a.language in ('sk-SK','*') 
      AND `a`.`access` IN (1,1)
    
      ORDER BY `a`.`ordering` DESC

    Vysvetlenie

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

    Profil

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.08 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_spkgarten/models/courses.php:140
    12	SpkgartenModelCourses::getClasses()	JROOT/components/com_spkgarten/views/course/view.html.php:32
    11	SpkgartenViewCourse->display()	JROOT/libraries/fof/controller/controller.php:1125
    10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1218
    9	FOFController->read()	JROOT/libraries/fof/controller/controller.php:967
    8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:327
    7	FOFDispatcher->dispatch()	JROOT/components/com_spkgarten/spkgarten.php:34
    6	require_once JROOT/components/com_spkgarten/spkgarten.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: 0.73 ms Po ostatnom dotaze: 0.08 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 11.178 MB Vrátené riadky: 1
    Duplicitné dotazy: #18  #25  #26  #27

    SELECT `id`
    
      FROM `mw4r8_menu`
    
      WHERE `link` LIKE '%option=com_spkgarten&view=courses%' 
      AND `published` = '1'

    Vysvetlenie

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

    Profil

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.41 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_spkgarten/helpers/helper.php:22
    12	SpkgartenbHelper::getItemid()	JROOT/components/com_spkgarten/views/course/view.html.php:35
    11	SpkgartenViewCourse->display()	JROOT/libraries/fof/controller/controller.php:1125
    10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1218
    9	FOFController->read()	JROOT/libraries/fof/controller/controller.php:967
    8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:327
    7	FOFDispatcher->dispatch()	JROOT/components/com_spkgarten/spkgarten.php:34
    6	require_once JROOT/components/com_spkgarten/spkgarten.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.50 ms Po ostatnom dotaze: 0.16 ms Pamäť pre dotazy: 0.023 MB pamäť pred dotazom: 11.187 MB Vrátené riadky: 2

    SELECT `spkgarten_teacher_id`,`title`,`slug`,`designation`,`image`,`website`,`social_facebook`,`social_twitter`,`social_gplus`,`social_linkedin`
    
      FROM `mw4r8_spkgarten_teachers`
    
      WHERE `enabled` = 1 
      AND `spkgarten_teacher_id` IN (2,15)
    
      ORDER BY ordering DESC

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	mw4r8_spkgarten_teachers	range	PRIMARY	PRIMARY	8	NULL	2	Using where; Pomocou filesort

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.09 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_spkgarten/models/courses.php:168
    12	SpkgartenModelCourses::getCourseTeachers()	JROOT/components/com_spkgarten/views/course/view.html.php:39
    11	SpkgartenViewCourse->display()	JROOT/libraries/fof/controller/controller.php:1125
    10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1218
    9	FOFController->read()	JROOT/libraries/fof/controller/controller.php:967
    8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:327
    7	FOFDispatcher->dispatch()	JROOT/components/com_spkgarten/spkgarten.php:34
    6	require_once JROOT/components/com_spkgarten/spkgarten.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: 0.74 ms Po ostatnom dotaze: 0.07 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 11.195 MB Vrátené riadky: 1
    Duplicitné dotazy: #23

    SELECT `id`
    
      FROM `mw4r8_menu`
    
      WHERE `link` LIKE '%option=com_spkgarten&view=teachers%' 
      AND `published` = '1'

    Vysvetlenie

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

    Profil

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.42 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_spkgarten/helpers/helper.php:22
    12	SpkgartenbHelper::getItemid()	JROOT/components/com_spkgarten/views/course/view.html.php:42
    11	SpkgartenViewCourse->display()	JROOT/libraries/fof/controller/controller.php:1125
    10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1218
    9	FOFController->read()	JROOT/libraries/fof/controller/controller.php:967
    8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:327
    7	FOFDispatcher->dispatch()	JROOT/components/com_spkgarten/spkgarten.php:34
    6	require_once JROOT/components/com_spkgarten/spkgarten.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.76 ms Po ostatnom dotaze: 0.14 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 11.202 MB Vrátené riadky: 1
    Duplicitné dotazy: #22

    SELECT `id`
    
      FROM `mw4r8_menu`
    
      WHERE `link` LIKE '%option=com_spkgarten&view=teachers%' 
      AND `published` = '1'

    Vysvetlenie

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

    Profil

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.40 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_spkgarten/helpers/helper.php:22
    12	SpkgartenbHelper::getItemid()	JROOT/components/com_spkgarten/views/course/view.html.php:42
    11	SpkgartenViewCourse->display()	JROOT/libraries/fof/controller/controller.php:1125
    10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1218
    9	FOFController->read()	JROOT/libraries/fof/controller/controller.php:967
    8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:327
    7	FOFDispatcher->dispatch()	JROOT/components/com_spkgarten/spkgarten.php:34
    6	require_once JROOT/components/com_spkgarten/spkgarten.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.54 ms Po ostatnom dotaze: 0.16 ms Pamäť pre dotazy: 0.024 MB pamäť pred dotazom: 11.210 MB Vrátené riadky: 2

    SELECT a.*
    
      FROM `mw4r8_spkgarten_courses` AS `a`
    
      WHERE a.teachers LIKE '%2%' OR a.teachers LIKE '%15%' 
      AND `a`.`enabled` = '1'
    
      ORDER BY `a`.`created_on` DESC 
      LIMIT 3

    Vysvetlenie

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

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.11 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_spkgarten/models/courses.php:195
    12	SpkgartenModelCourses->getRelated()	JROOT/components/com_spkgarten/views/course/view.html.php:46
    11	SpkgartenViewCourse->display()	JROOT/libraries/fof/controller/controller.php:1125
    10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1218
    9	FOFController->read()	JROOT/libraries/fof/controller/controller.php:967
    8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:327
    7	FOFDispatcher->dispatch()	JROOT/components/com_spkgarten/spkgarten.php:34
    6	require_once JROOT/components/com_spkgarten/spkgarten.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Čas dotazu: 0.74 ms Po ostatnom dotaze: 0.07 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 11.221 MB Vrátené riadky: 1
    Duplicitné dotazy: #18  #20  #26  #27

    SELECT `id`
    
      FROM `mw4r8_menu`
    
      WHERE `link` LIKE '%option=com_spkgarten&view=courses%' 
      AND `published` = '1'

    Vysvetlenie

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

    Profil

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.43 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_spkgarten/helpers/helper.php:22
    12	SpkgartenbHelper::getItemid()	JROOT/components/com_spkgarten/views/course/view.html.php:50
    11	SpkgartenViewCourse->display()	JROOT/libraries/fof/controller/controller.php:1125
    10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1218
    9	FOFController->read()	JROOT/libraries/fof/controller/controller.php:967
    8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:327
    7	FOFDispatcher->dispatch()	JROOT/components/com_spkgarten/spkgarten.php:34
    6	require_once JROOT/components/com_spkgarten/spkgarten.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.74 ms Po ostatnom dotaze: 0.14 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 11.229 MB Vrátené riadky: 1
    Duplicitné dotazy: #18  #20  #25  #27

    SELECT `id`
    
      FROM `mw4r8_menu`
    
      WHERE `link` LIKE '%option=com_spkgarten&view=courses%' 
      AND `published` = '1'

    Vysvetlenie

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

    Profil

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.42 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_spkgarten/helpers/helper.php:22
    12	SpkgartenbHelper::getItemid()	JROOT/components/com_spkgarten/views/course/view.html.php:50
    11	SpkgartenViewCourse->display()	JROOT/libraries/fof/controller/controller.php:1125
    10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1218
    9	FOFController->read()	JROOT/libraries/fof/controller/controller.php:967
    8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:327
    7	FOFDispatcher->dispatch()	JROOT/components/com_spkgarten/spkgarten.php:34
    6	require_once JROOT/components/com_spkgarten/spkgarten.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Čas dotazu: 0.73 ms Po ostatnom dotaze: 0.09 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 11.235 MB Vrátené riadky: 1
    Duplicitné dotazy: #18  #20  #25  #26

    SELECT `id`
    
      FROM `mw4r8_menu`
    
      WHERE `link` LIKE '%option=com_spkgarten&view=courses%' 
      AND `published` = '1'

    Vysvetlenie

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

    Profil

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.41 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_spkgarten/helpers/helper.php:22
    12	SpkgartenbHelper::getItemid()	JROOT/components/com_spkgarten/views/course/view.html.php:53
    11	SpkgartenViewCourse->display()	JROOT/libraries/fof/controller/controller.php:1125
    10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1218
    9	FOFController->read()	JROOT/libraries/fof/controller/controller.php:967
    8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:327
    7	FOFDispatcher->dispatch()	JROOT/components/com_spkgarten/spkgarten.php:34
    6	require_once JROOT/components/com_spkgarten/spkgarten.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.87 ms Po ostatnom dotaze: 60.88 ms Pamäť pre dotazy: 0.026 MB pamäť pred dotazom: 13.169 MB Vrátené riadky: 11

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM mw4r8_modules AS m
    
      LEFT JOIN mw4r8_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN mw4r8_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 <= '2024-11-21 06:29:13') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-21 06:29:13') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 547 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	14	Using index condition; Using where; Pomocou filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	c42msnab.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	c42msnab.m.module,const	1	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.09 ms
    Preparing	0.05 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.26 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.03 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	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/Helper/ModuleHelper.php:432
    14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
    11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:512
    10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:459
    9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:268
    8	Helix3::generatelayout()	JROOT/templates/shaper_kidzy/index.php:165
    7	require JROOT/templates/shaper_kidzy/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21 zaznamenaných typov dotazov, zoradené podľa výskytu udalosti.

VYBERTE tabuľky:

1. 7 × SELECT `id` 
     FROM `mw4r8_menu`

2. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
     FROM `mw4r8_extensions`

3. 1 × SELECT `data` 
     FROM `mw4r8_session`

4. 1 × SELECT mw4r8_spkgarten_courses.* 
     FROM mw4r8_spkgarten_courses

5. 1 × SELECT a.* 
     FROM `mw4r8_spkgarten_courses` AS `a`

6. 1 × SELECT `spkgarten_teacher_id`,`title`,`slug`,`designation`,`image`,`website`,`social_facebook`,`social_twitter`,`social_gplus`,`social_linkedin` 
     FROM `mw4r8_spkgarten_teachers`

7. 1 × SELECT a.* 
     FROM `mw4r8_spkgarten_classes` AS `a`

8. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
     FROM `mw4r8_assets`

9. 1 × SELECT * 
     FROM mw4r8_languages

10. 1 × SELECT id, home, template, s.params 
      FROM mw4r8_template_styles as s 
      LEFT JOIN mw4r8_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id

11. 1 × SELECT `session_id` 
      FROM `mw4r8_session`

12. 1 × SELECT * 
      FROM mw4r8_acymailing_confi

13. 1 × 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 mw4r8_menu AS m 
      LEFT JOIN mw4r8_extensions AS e 
      ON m.component_id = e.extension_id

14. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM mw4r8_extensions

15. 1 × SELECT b.id 
      FROM mw4r8_usergroups AS a 
      LEFT JOIN mw4r8_usergroups AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt

16. 1 × SELECT id, rules 
      FROM `mw4r8_viewlevels

17. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM mw4r8_modules AS m 
      LEFT JOIN mw4r8_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN mw4r8_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id