Apartments Joško

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1737019703,
                "last": 1737019703,
                "now": 1737019703
            },
            "token": "t3ZZzPvXe9MpCM6bQ3xElEXvx1ylWOZy"
        },
        "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": "hr-HR"
        }
    }
}

Vrijeme

Memorija

8 Upita zapisano 13.30 ms

1. Vrijeme upita: 1.83 ms Memorija upita: 0.023 MB memorija prije upita: 4.169 MB Redaka vraćeno: 0

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

   Objašnjenje

   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.20 ms
   Executing hook on transaction	0.02 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.91 ms
   init	0.02 ms
   System lock	0.03 ms
   optimizing	0.02 ms
   statistics	0.27 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.05 ms
   freeing items	0.08 ms
   cleaning up	0.02 ms

   Slijed poziva funkcija

   #	Pozivatelj	Datoteka i broj linije
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Isto kao i poziv u donjem retku.
   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

   [Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

   ---

2. Vrijeme upita: 0.51 ms Nakon posljednjeg upita: 1.08 ms Memorija upita: 0.020 MB memorija prije upita: 4.265 MB Redaka vraćeno: 0

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

   Objašnjenje

   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.10 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.07 ms
   optimizing	0.02 ms
   statistics	0.05 ms
   executing	0.01 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.06 ms
   cleaning up	0.01 ms

   Slijed poziva funkcija

   #	Pozivatelj	Datoteka i broj linije
   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

   [Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

   ---

3. Vrijeme upita: 1.84 ms Nakon posljednjeg upita: 0.09 ms Memorija upita: 0.004 MB memorija prije upita: 4.270 MB

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

   Objašnjenje

   OBJAŠNJENJE što je nemoguće kod upita: INSERT INTO `suc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3337323231633836623533646463656634383430383638333230326333303431', 1, 1737019703, 0, '', 0)

   Profil

   Status	Duration
   starting	0.08 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.11 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	1.23 ms
   closing tables	0.01 ms
   freeing items	0.11 ms
   cleaning up	0.01 ms

   Slijed poziva funkcija

   #	Pozivatelj	Datoteka i broj linije
   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

   [Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

   ---

4. Vrijeme upita: 1.72 ms Nakon posljednjeg upita: 6.60 ms Memorija upita: 0.021 MB memorija prije upita: 4.830 MB Redaka vraćeno: 5

   SELECT id, rules
   
     FROM `suc_viewlevels`

   Objašnjenje

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	suc_viewlevels	NULL	ALL	NULL	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	5	100.00	NULL

   Profil

   Status	Duration
   starting	0.13 ms
   Executing hook on transaction	0.04 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.98 ms
   init	0.03 ms
   System lock	0.04 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.02 ms
   executing	0.04 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.05 ms
   freeing items	0.10 ms
   cleaning up	0.01 ms

   Slijed poziva funkcija

   #	Pozivatelj	Datoteka i broj linije
   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

   [Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

   ---

5. Vrijeme upita: 1.38 ms Nakon posljednjeg upita: 0.45 ms Memorija upita: 0.021 MB memorija prije upita: 4.842 MB Redaka vraćeno: 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

   Objašnjenje

   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.12 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.66 ms
   init	0.01 ms
   System lock	0.02 ms
   optimizing	0.07 ms
   statistics	0.07 ms
   preparing	0.03 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.02 ms
   freeing items	0.07 ms
   cleaning up	0.01 ms

   Slijed poziva funkcija

   #	Pozivatelj	Datoteka i broj linije
   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

   [Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

   ---

6. Vrijeme upita: 2.91 ms Nakon posljednjeg upita: 33.80 ms Memorija upita: 0.006 MB memorija prije upita: 10.783 MB

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

   Objašnjenje

   OBJAŠNJENJE što je nemoguće kod upita: UPDATE `suc_extensions` SET `params` = '{\"mediaversion\":\"3795ccaa7e34e23c6488e7780aa46786\"}' WHERE `type` = 'library' AND `element` = 'joomla'

   Profil

   Status	Duration
   starting	0.14 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.02 ms
   Opening tables	0.89 ms
   init	0.01 ms
   System lock	0.09 ms
   updating	0.07 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	1.11 ms
   closing tables	0.08 ms
   freeing items	0.20 ms
   cleaning up	0.03 ms

   Slijed poziva funkcija

   #	Pozivatelj	Datoteka i broj linije
   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

   [Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

   ---

7. Vrijeme upita: 1.83 ms Nakon posljednjeg upita: 12.02 ms Memorija upita: 0.021 MB memorija prije upita: 11.833 MB Redaka vraćeno: 9

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

   Objašnjenje

   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	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	810	0.93	Using where

   Profil

   Status	Duration
   starting	0.13 ms
   Executing hook on transaction	0.01 ms
   starting	0.02 ms
   checking permissions	0.03 ms
   Opening tables	0.94 ms
   init	0.04 ms
   System lock	0.03 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.02 ms
   executing	0.33 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.10 ms
   cleaning up	0.03 ms

   Slijed poziva funkcija

   #	Pozivatelj	Datoteka i broj linije
   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

   [Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

   ---

8. Vrijeme upita: 1.27 ms Nakon posljednjeg upita: 1.28 ms Memorija upita: 0.021 MB memorija prije upita: 11.932 MB Redaka vraćeno: 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 = 592

   Objašnjenje

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	NULL	NULL	no matching row in const table

   Profil

   Status	Duration
   starting	0.11 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.71 ms
   init	0.03 ms
   System lock	0.03 ms
   optimizing	0.02 ms
   statistics	0.07 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.04 ms
   freeing items	0.07 ms
   cleaning up	0.01 ms

   Slijed poziva funkcija

   #	Pozivatelj	Datoteka i broj linije
   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

   [Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

   ---

8 Tipova upita zapisano, razvrstani su prema broju pojavljivanja.

ODABERI tablice:

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`

OSTALE tablice:

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

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