Log inn/ut

Joomlas feilsøkingskonsoll

Økt

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1714018221,
                "last": 1714018221,
                "now": 1714018221
            },
            "client": {
                "forwarded": "18.226.166.214"
            },
            "token": "5VXzF5NsIMpuCfWd9yWEeHlYWEplBW0p"
        },
        "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
        }
    }
}

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

#	Oppkaller	Fil og linjenummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Samme som oppkall i linjen nedenfor.
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

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

#	Oppkaller	Fil og linjenummer
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

'EXPLAIN' er ikke mulig på spørringen: INSERT INTO `c29oj_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3730643538373161393262383932343963393633313736643335643431666263', 1, 1714018221, 0, '', 0)

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 for update	0.02 ms
Update	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.03 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Oppkaller	Fil og linjenummer
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

[Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

Spørringstid: 1.01 ms Etter siste spørring: 0.43 ms Spørreminne: 0.040 MB Minne før spørring: 1.083 MB Rader funnet: 40

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `c29oj_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c29oj_extensions	ref	extension	extension	82	const	28	Using index condition; Using where

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.12 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.39 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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Oppkaller	Fil og linjenummer
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}()	Samme som oppkall i linjen nedenfor.
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

Spørringstid: 0.39 ms Etter siste spørring: 0.49 ms Spørreminne: 0.021 MB Minne før spørring: 1.118 MB Rader funnet: 6

SELECT id, rules

  FROM `c29oj_viewlevels`

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c29oj_viewlevels	ALL	NULL	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	6

Profil

Status	Duration
Starting	0.03 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.01 ms
Preparing	0.01 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.04 ms
Reset for next command	0.02 ms

Call Stack

#	Oppkaller	Fil og linjenummer
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

[Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

Spørringstid: 0.51 ms Etter siste spørring: 0.10 ms Spørreminne: 0.021 MB Minne før spørring: 1.131 MB Rader funnet: 1

SELECT b.id

  FROM c29oj_usergroups AS a

  LEFT JOIN c29oj_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 1

Forklar

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

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.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 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
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Call Stack

#	Oppkaller	Fil og linjenummer
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

[Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

Spørringstid: 1.95 ms Etter siste spørring: 0.14 ms Spørreminne: 0.030 MB Minne før spørring: 1.152 MB Rader funnet: 99

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM c29oj_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c29oj_extensions	ALL	extension	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	257	Using where; Bruker filsortering

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.03 ms
Statistics	0.17 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

Call Stack

#	Oppkaller	Fil og linjenummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Samme som oppkall i linjen nedenfor.
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:356
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

[Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

Spørringstid: 1.69 ms Etter siste spørring: 5.98 ms Spørreminne: 0.048 MB Minne før spørring: 1.627 MB Rader funnet: 24

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 c29oj_menu AS m

  LEFT JOIN c29oj_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

Forklar

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	1	Using index condition; Using where; Bruker filsortering
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	rosenborg_park_.m.component_id	1	Using where

Profil

Status	Duration
Starting	0.13 ms
checking permissions	0.02 ms
Opening tables	0.04 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.10 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.78 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.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.05 ms

Call Stack

#	Oppkaller	Fil og linjenummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
16	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Samme som oppkall i linjen nedenfor.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
13	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
12	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
11	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
10	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
9	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
8	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/plugins/system/headtag/headtag.php:34
7	plgSystemHeadTag->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

Spørringstid: 0.69 ms Etter siste spørring: 9.41 ms Spørreminne: 0.021 MB Minne før spørring: 1.827 MB Rader funnet: 1

SELECT `template`

  FROM `c29oj_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c29oj_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	1	Using where

Profil

Status	Duration
Starting	0.07 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.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 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
Unlocking tables	0.01 ms
closing tables	0.04 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Oppkaller	Fil og linjenummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:247
9	plgSystemHelix3->getTemplateName()	JROOT/plugins/system/helix3/helix3.php:41
8	plgSystemHelix3->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

Spørringstid: 1.30 ms Etter siste spørring: 3.67 ms Spørreminne: 0.021 MB Minne før spørring: 2.133 MB Rader funnet: 1

SELECT id, home, template, s.params

  FROM c29oj_template_styles as s

  LEFT JOIN c29oj_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

Forklar

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	1
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	rosenborg_park_.s.template,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.13 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.06 ms
Statistics	0.24 ms
Preparing	0.07 ms
Executing	0.01 ms
Sending data	0.15 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.02 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.08 ms
Reset for next command	0.04 ms

Call Stack

#	Oppkaller	Fil og linjenummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:33
9	jsn_template_framework_class_loader()	JROOT/plugins/system/jsntplframework/jsntplframework.php:187
8	PlgSystemJSNTPLFramework->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

[Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

Spørringstid: 1.67 ms Etter siste spørring: 1.54 ms Spørreminne: 0.022 MB Minne før spørring: 2.181 MB Rader funnet: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `c29oj_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Forklar

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

Profil

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

Call Stack

#	Oppkaller	Fil og linjenummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Samme som oppkall i linjen nedenfor.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

Spørringstid: 1.39 ms Etter siste spørring: 0.15 ms Spørreminne: 0.005 MB Minne før spørring: 2.171 MB

UPDATE `c29oj_extensions`

  SET `params` = '{\"mediaversion\":\"7b340c416c99f43e04ba0dda630e66ee\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Forklar

'EXPLAIN' er ikke mulig på spørringen: UPDATE `c29oj_extensions` SET `params` = '{\"mediaversion\":\"7b340c416c99f43e04ba0dda630e66ee\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init for update	0.71 ms
Updating	0.16 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.05 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.07 ms
Reset for next command	0.03 ms

Call Stack

#	Oppkaller	Fil og linjenummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

Spørringstid: 0.69 ms Etter siste spørring: 0.35 ms Spørreminne: 0.019 MB Minne før spørring: 2.193 MB Rader funnet: 1

SELECT *

  FROM c29oj_languages

  WHERE published=1

  ORDER BY ordering ASC

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c29oj_languages	system	NULL	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	1

Profil

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

Call Stack

#	Oppkaller	Fil og linjenummer
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

Spørringstid: 1.94 ms Etter siste spørring: 42.46 ms Spørreminne: 0.027 MB Minne før spørring: 2.371 MB Rader funnet: 1

Duplikat-spørringer: #17

SELECT *

  FROM `c29oj_extensions`

  WHERE `type` = 'plugin' 
  AND `element` = 'helix3' 
  AND `folder` = 'system'

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c29oj_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profil

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

Call Stack

#	Oppkaller	Fil og linjenummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
23	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:277
22	plgSystemHelix3::getVersion()	JROOT/plugins/system/helix3/helix3.php:91
21	plgSystemHelix3->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
18	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
17	UsersModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
16	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
15	UsersModelRegistration->getForm()	JROOT/components/com_users/models/registration.php:262
14	UsersModelRegistration->getData()	JROOT/components/com_users/models/registration.php:356
13	UsersModelRegistration->loadFormData()	JROOT/libraries/src/MVC/Model/FormModel.php:235
12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
11	UsersModelRegistration->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
6	require_once JROOT/components/com_users/users.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

Spørringstid: 7.73 ms Etter siste spørring: 54.04 ms Spørreminne: 0.027 MB Minne før spørring: 2.407 MB Rader funnet: 1

Duplikat-spørringer: #18 #19

SELECT *

  FROM c29oj_wf_profiles

  WHERE published = 1

  ORDER BY ordering ASC

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c29oj_wf_profiles	ALL	NULL	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	4	Using where; Bruker filsortering

Profil

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

Call Stack

#	Oppkaller	Fil og linjenummer
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jce/editor/libraries/classes/application.php:230
24	WFApplication->getProfile()	JROOT/administrator/components/com_jce/helpers/browser.php:74
23	WfBrowserHelper::getMediaFieldOptions()	JROOT/plugins/system/jce/jce.php:54
22	PlgSystemJce->getMediaRedirectOptions()	JROOT/plugins/system/jce/jce.php:215
21	PlgSystemJce->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
18	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
17	UsersModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
16	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
15	UsersModelRegistration->getForm()	JROOT/components/com_users/models/registration.php:262
14	UsersModelRegistration->getData()	JROOT/components/com_users/models/registration.php:356
13	UsersModelRegistration->loadFormData()	JROOT/libraries/src/MVC/Model/FormModel.php:235
12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
11	UsersModelRegistration->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
6	require_once JROOT/components/com_users/users.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

Spørringstid: 4.13 ms Etter siste spørring: 12.62 ms Spørreminne: 0.028 MB Minne før spørring: 2.498 MB Rader funnet: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM c29oj_fields AS a

  LEFT JOIN `c29oj_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN c29oj_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN c29oj_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN c29oj_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN c29oj_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_users.user' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Bruker filsortering
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	rosenborg_park_.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	rosenborg_park_.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	rosenborg_park_.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	rosenborg_park_.a.group_id	1	Using where

Profil

Status	Duration
Starting	0.44 ms
checking permissions	0.03 ms
Opening tables	0.37 ms
After opening tables	0.03 ms
System lock	0.05 ms
table lock	0.03 ms
init	0.17 ms
Optimizing	0.12 ms
Statistics	0.46 ms
Preparing	0.12 ms
Creating tmp table	0.19 ms
Sorting result	0.04 ms
Executing	0.02 ms
Sending data	1.15 ms
Creating sort index	0.09 ms
Removing tmp table	0.22 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.07 ms
Starting cleanup	0.02 ms
Freeing items	0.04 ms
Updating status	0.14 ms
Reset for next command	0.08 ms

Call Stack

#	Oppkaller	Fil og linjenummer
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
26	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
25	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
24	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
23	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
22	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
21	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
18	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
17	UsersModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
16	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
15	UsersModelRegistration->getForm()	JROOT/components/com_users/models/registration.php:262
14	UsersModelRegistration->getData()	JROOT/components/com_users/models/registration.php:356
13	UsersModelRegistration->loadFormData()	JROOT/libraries/src/MVC/Model/FormModel.php:235
12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
11	UsersModelRegistration->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
6	require_once JROOT/components/com_users/users.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

Spørringstid: 2.15 ms Etter siste spørring: 9.16 ms Spørreminne: 0.026 MB Minne før spørring: 2.539 MB Rader funnet: 1

Duplikat-spørringer: #14

SELECT *

  FROM `c29oj_extensions`

  WHERE `type` = 'plugin' 
  AND `element` = 'helix3' 
  AND `folder` = 'system'

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c29oj_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profil

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

Call Stack

#	Oppkaller	Fil og linjenummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:277
18	plgSystemHelix3::getVersion()	JROOT/plugins/system/helix3/helix3.php:91
17	plgSystemHelix3->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
13	UsersModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
11	UsersModelRegistration->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
6	require_once JROOT/components/com_users/users.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

Spørringstid: 0.93 ms Etter siste spørring: 0.83 ms Spørreminne: 0.026 MB Minne før spørring: 2.550 MB Rader funnet: 1

Duplikat-spørringer: #15 #19

SELECT *

  FROM c29oj_wf_profiles

  WHERE published = 1

  ORDER BY ordering ASC

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c29oj_wf_profiles	ALL	NULL	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	4	Using where; Bruker filsortering

Profil

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

Call Stack

#	Oppkaller	Fil og linjenummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_jce/editor/libraries/classes/application.php:230
20	WFApplication->getProfile()	JROOT/administrator/components/com_jce/helpers/browser.php:74
19	WfBrowserHelper::getMediaFieldOptions()	JROOT/plugins/system/jce/jce.php:54
18	PlgSystemJce->getMediaRedirectOptions()	JROOT/plugins/system/jce/jce.php:215
17	PlgSystemJce->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
13	UsersModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
11	UsersModelRegistration->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
6	require_once JROOT/components/com_users/users.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

Spørringstid: 0.87 ms Etter siste spørring: 0.85 ms Spørreminne: 0.028 MB Minne før spørring: 2.562 MB Rader funnet: 1

Duplikat-spørringer: #15 #18

SELECT *

  FROM c29oj_wf_profiles

  WHERE published = 1

  ORDER BY ordering ASC

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c29oj_wf_profiles	ALL	NULL	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	4	Using where; Bruker filsortering

Profil

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

Call Stack

#	Oppkaller	Fil og linjenummer
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/components/com_jce/editor/libraries/classes/application.php:230
25	WFApplication->getProfile()	JROOT/administrator/components/com_jce/helpers/browser.php:74
24	WfBrowserHelper::getMediaFieldOptions()	JROOT/plugins/system/jce/jce.php:54
23	PlgSystemJce->getMediaRedirectOptions()	JROOT/plugins/system/jce/jce.php:215
22	PlgSystemJce->onContentPrepareForm()	JROOT/plugins/system/jce/jce.php:35
21	PlgSystemJce->onPlgSystemJceContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
18	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/content/jce/jce.php:22
17	PlgContentJce->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
13	UsersModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
11	UsersModelRegistration->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
6	require_once JROOT/components/com_users/users.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

Spørringstid: 1.21 ms Etter siste spørring: 56.58 ms Spørreminne: 0.020 MB Minne før spørring: 2.788 MB Rader funnet: 1

SELECT *

  FROM `c29oj_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '17'

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c29oj_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profil

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

Call Stack

#	Oppkaller	Fil og linjenummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
8	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:79
7	plgSystemHelix3->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

[Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

Spørringstid: 6.24 ms Etter siste spørring: 7.51 ms Spørreminne: 0.024 MB Minne før spørring: 2.839 MB Rader funnet: 4

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM c29oj_modules AS m

  LEFT JOIN c29oj_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN c29oj_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-04-25 04:10:21') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-25 04:10:21') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 124 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	5	const,const	44	Using where; Bruker filsortering
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	rosenborg_park_.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	rosenborg_park_.m.id	1	Using where; Using index

Profil

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

Call Stack

#	Oppkaller	Fil og linjenummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	Samme som oppkall i linjen nedenfor.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/j51_ashley/php/config.php:6
8	require JROOT/templates/j51_ashley/php/config.php	JROOT/templates/j51_ashley/index.php:11
7	require JROOT/templates/j51_ashley/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

17 spørre type(r) logget, sortert etter forekomster.

VELG tabeller:

3 × SELECT * 
  FROM c29oj_wf_profiles

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

2 × SELECT * 
  FROM `c29oj_extensions`

1 × SELECT `data` 
  FROM `c29oj_session`

1 × SELECT `session_id` 
  FROM `c29oj_session`

1 × SELECT id, rules 
  FROM `c29oj_viewlevels

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM c29oj_extensions

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 c29oj_menu AS m 
  LEFT JOIN c29oj_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `template` 
  FROM `c29oj_template_styles`

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

```
1 × SELECT * 
  FROM c29oj_languages
```

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM c29oj_fields AS a 
  LEFT JOIN `c29oj_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN c29oj_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN c29oj_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN c29oj_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN c29oj_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT * 
  FROM `c29oj_template_styles`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM c29oj_modules AS m 
  LEFT JOIN c29oj_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN c29oj_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

ANDRE tabeller:

1 × INSERT INTO `c29oj_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3730643538373161393262383932343963393633313736643335643431666263', 1, 1714018221, 0, '', 0

1 × UPDATE `c29oj_extensions` 
  SET `params` = '{\"mediaversion\":\"7b340c416c99f43e04ba0dda630e66ee\"}'

Joomlas feilsøkingskonsoll

Økt

Profileringinformasjon

Tid

Minne

Minneforbruk

Database-spørringer

21 spørring(er) logget 37.94 ms

5 duplikat ble funnet.

17 spørre type(r) logget, sortert etter forekomster.

VELG tabeller:

ANDRE tabeller: