Apartments Žile

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1747109854,
                "last": 1747109854,
                "now": 1747109854
            },
            "token": "6rQ5fOdm0bBix9gCYmeF0DoszHHPFugj"
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "sk-SK"
        }
    }
}

Čas

Pamäť

Zaznamenané dotazy: 8 25.16 ms

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

   SELECT `data`
   
     FROM `suc_session`
   
     WHERE `session_id` = X'3832326665363765326532346439386535343166373830346431376530313664'

   Vysvetlenie

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	suc_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

   Profil

   Status	Duration
   starting	0.11 ms
   Executing hook on transaction	0.02 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.90 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.01 ms
   statistics	0.80 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.08 ms
   cleaning up	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:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [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.55 ms Po ostatnom dotaze: 1.15 ms Pamäť pre dotazy: 0.020 MB pamäť pred dotazom: 4.265 MB Vrátené riadky: 0

   SELECT `session_id`
   
     FROM `suc_session`
   
     WHERE `session_id` = X'3832326665363765326532346439386535343166373830346431376530313664' 
     LIMIT 1

   Vysvetlenie

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	suc_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

   Profil

   Status	Duration
   starting	0.09 ms
   Executing hook on transaction	0.01 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   init	0.01 ms
   System lock	0.05 ms
   optimizing	0.02 ms
   statistics	0.04 ms
   executing	0.03 ms
   end	0.03 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.09 ms
   cleaning up	0.01 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:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Čas dotazu: 1.67 ms Po ostatnom dotaze: 0.09 ms Pamäť pre dotazy: 0.004 MB pamäť pred dotazom: 4.270 MB

   INSERT INTO `suc_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3832326665363765326532346439386535343166373830346431376530313664', 1, 1747109854, 0, '', 0)

   Vysvetlenie

   Nie je možné VYSVETLENIE na dotaz: INSERT INTO `suc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3832326665363765326532346439386535343166373830346431376530313664', 1, 1747109854, 0, '', 0)

   Profil

   Status	Duration
   starting	0.09 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.02 ms
   update	0.12 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	1.22 ms
   closing tables	0.01 ms
   freeing items	0.06 ms
   cleaning up	0.01 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:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Čas dotazu: 3.28 ms Po ostatnom dotaze: 4.83 ms Pamäť pre dotazy: 0.021 MB pamäť pred dotazom: 4.830 MB Vrátené riadky: 5

   SELECT id, rules
   
     FROM `suc_viewlevels`

   Vysvetlenie

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

   Profil

   Status	Duration
   starting	0.33 ms
   Executing hook on transaction	0.03 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	1.99 ms
   init	0.05 ms
   System lock	0.08 ms
   optimizing	0.03 ms
   statistics	0.05 ms
   preparing	0.05 ms
   executing	0.09 ms
   end	0.03 ms
   query end	0.02 ms
   waiting for handler commit	0.03 ms
   closing tables	0.04 ms
   freeing items	0.22 ms
   cleaning up	0.04 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:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

5. Čas dotazu: 3.16 ms Po ostatnom dotaze: 0.23 ms Pamäť pre dotazy: 0.021 MB pamäť pred dotazom: 4.842 MB Vrátené riadky: 2

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

   Vysvetlenie

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

   Profil

   Status	Duration
   starting	0.28 ms
   Executing hook on transaction	0.02 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   Opening tables	1.72 ms
   init	0.04 ms
   System lock	0.06 ms
   optimizing	0.05 ms
   statistics	0.18 ms
   preparing	0.08 ms
   executing	0.09 ms
   end	0.02 ms
   query end	0.02 ms
   waiting for handler commit	0.03 ms
   closing tables	0.11 ms
   freeing items	0.27 ms
   cleaning up	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:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Čas dotazu: 5.98 ms Po ostatnom dotaze: 32.40 ms Pamäť pre dotazy: 0.006 MB pamäť pred dotazom: 10.788 MB

   UPDATE `suc_extensions`
   
     SET `params` = '{\"mediaversion\":\"4ec8137d99fa145ff15d57fdedf6666e\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Vysvetlenie

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

   Profil

   Status	Duration
   starting	0.49 ms
   Executing hook on transaction	0.11 ms
   starting	0.07 ms
   checking permissions	0.02 ms
   Opening tables	2.38 ms
   init	0.05 ms
   System lock	0.26 ms
   updating	0.19 ms
   end	0.02 ms
   query end	0.03 ms
   waiting for handler commit	1.72 ms
   closing tables	0.06 ms
   freeing items	0.26 ms
   cleaning up	0.03 ms

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
   8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
   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:225
   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: 6.53 ms Po ostatnom dotaze: 11.54 ms Pamäť pre dotazy: 0.021 MB pamäť pred dotazom: 11.826 MB Vrátené riadky: 9

   SELECT language,id
   
     FROM `suc_menu`
   
     WHERE home = 1 
     AND published = 1 
     AND client_id = 0

   Vysvetlenie

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

   Profil

   Status	Duration
   starting	0.37 ms
   Executing hook on transaction	0.02 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	2.97 ms
   init	0.05 ms
   System lock	0.07 ms
   optimizing	0.04 ms
   statistics	0.35 ms
   preparing	0.08 ms
   executing	1.88 ms
   end	0.03 ms
   query end	0.02 ms
   waiting for handler commit	0.02 ms
   closing tables	0.03 ms
   freeing items	0.25 ms
   cleaning up	0.06 ms

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
   8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
   7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
   6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Čas dotazu: 1.81 ms Po ostatnom dotaze: 2.82 ms Pamäť pre dotazy: 0.021 MB pamäť pred dotazom: 11.925 MB Vrátené riadky: 0

   SELECT `c2`.`language`,`c2`.`id`
   
     FROM `suc_menu` AS `c`
   
     INNER JOIN `suc_associations` AS `a` 
     ON a.id = c.`id` 
     AND a.context='com_menus.item'
   
     INNER JOIN `suc_associations` AS `a2` 
     ON `a`.`key` = `a2`.`key`
   
     INNER JOIN `suc_menu` AS `c2` 
     ON a2.id = c2.`id`
   
     WHERE c.id = 596

   Vysvetlenie

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	NULL	NULL	NULL	NULL	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	NULL	NULL	no matching row in const table

   Profil

   Status	Duration
   starting	0.15 ms
   Executing hook on transaction	0.02 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.94 ms
   init	0.02 ms
   System lock	0.04 ms
   optimizing	0.02 ms
   statistics	0.15 ms
   executing	0.02 ms
   end	0.02 ms
   query end	0.03 ms
   waiting for handler commit	0.02 ms
   closing tables	0.02 ms
   freeing items	0.09 ms
   cleaning up	0.04 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/Language/Associations.php:115
   9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
   8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:768
   7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
   6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

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

VYBERTE tabuľky:

1. 1 × SELECT `data` 
     FROM `suc_session`

2. 1 × SELECT `session_id` 
     FROM `suc_session`

3. 1 × SELECT id, rules 
     FROM `suc_viewlevels

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

5. 1 × SELECT language,id 
     FROM `suc_menu`

6. 1 × SELECT `c2`.`language`,`c2`.`id` 
     FROM `suc_menu` AS `c` 
     INNER JOIN `suc_associations` AS `a` 
     ON a.id = c.`id` 
     AND a.context='com_menus.item' 
     INNER JOIN `suc_associations` AS `a2` 
     ON `a`.`key` = `a2`.`key` 
     INNER JOIN `suc_menu` AS `c2` 
     ON a2.id = c2.`id`

ĎALŠIE tabuľky:

1. 1 × INSERT INTO `suc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  (X'3832326665363765326532346439386535343166373830346431376530313664', 1, 1747109854, 0, '', 0

2. 1 × UPDATE `suc_extensions` 
     SET `params` = '{\"mediaversion\":\"4ec8137d99fa145ff15d57fdedf6666e\"}'