Kontakt oss

Joomlas feilsøkingskonsoll

Økt

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1727720531,
                "last": 1727720531,
                "now": 1727720531
            },
            "token": "aCmgS3NW11hBEB5TIRBc5M8jjwlX8PdH"
        },
        "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
        },
        "chapelco-115dd85a444bf3b293ed50dfe9b75703-name": null,
        "chapelco-115dd85a444bf3b293ed50dfe9b75703-logo-type": null,
        "chapelco-115dd85a444bf3b293ed50dfe9b75703-logo-custom-image": null,
        "chapelco-115dd85a444bf3b293ed50dfe9b75703-main-body": null,
        "chapelco-115dd85a444bf3b293ed50dfe9b75703-main-accent": null,
        "chapelco-115dd85a444bf3b293ed50dfe9b75703-main-accent2": null,
        "chapelco-115dd85a444bf3b293ed50dfe9b75703-main-showcasebg": null,
        "chapelco-115dd85a444bf3b293ed50dfe9b75703-contentstyle": null,
        "chapelco-115dd85a444bf3b293ed50dfe9b75703-font-family": null,
        "chapelco-115dd85a444bf3b293ed50dfe9b75703-font-size-is": null,
        "chapelco-115dd85a444bf3b293ed50dfe9b75703-menu-type": null,
        "chapelco-115dd85a444bf3b293ed50dfe9b75703-layout-mode": null
    }
}

Profileringinformasjon

Tid

Minne

Tid: 3.89 ms / 3.89 ms Minne: 0.409 MB / 0.74 MB Application: afterLoad

Tid: 47.68 ms / 51.57 ms Minne: 1.298 MB / 2.04 MB Application: afterInitialise

Tid: 6.71 ms / 58.28 ms Minne: 0.410 MB / 2.45 MB Application: Before Access::preloadComponents (all components)

Tid: 1.85 ms / 60.13 ms Minne: 0.056 MB / 2.50 MB Application: After Access::preloadComponents (all components)

Tid: 0.02 ms / 60.15 ms Minne: -0.003 MB / 2.50 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Tid: 0.12 ms / 60.27 ms Minne: 0.008 MB / 2.51 MB Application: After Access::getAssetRules (id:1 name:root.1)

Tid: 0.05 ms / 60.32 ms Minne: -0.020 MB / 2.49 MB Application: afterRoute

Tid: 5.72 ms / 66.04 ms Minne: 0.068 MB / 2.56 MB Application: beforeRenderComponent com_contact

Tid: 10.21 ms / 76.24 ms Minne: 0.150 MB / 2.71 MB Application: Before Access::getAssetRules (id:7 name:com_contact)

Tid: 0.09 ms / 76.33 ms Minne: 0.007 MB / 2.72 MB Application: After Access::getAssetRules (id:7 name:com_contact)

Tid: 31.13 ms / 107.46 ms Minne: 0.359 MB / 3.07 MB Application: afterRenderComponent com_contact

Tid: 0.71 ms / 108.17 ms Minne: 0.009 MB / 3.08 MB Application: afterDispatch

Tid: 13.95 ms / 122.12 ms Minne: 0.786 MB / 3.87 MB Application: beforeRenderModule mod_roknavmenu ()

Tid: 3.23 ms / 125.35 ms Minne: 0.174 MB / 4.04 MB Application: afterRenderModule mod_roknavmenu ()

Tid: 3.33 ms / 128.68 ms Minne: 0.005 MB / 4.05 MB Application: beforeRenderModule mod_menu (Footer Menu)

Tid: 0.33 ms / 129.00 ms Minne: 0.007 MB / 4.06 MB Application: afterRenderModule mod_menu (Footer Menu)

Tid: 0.05 ms / 129.05 ms Minne: -0.002 MB / 4.05 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Tid: 0.45 ms / 129.50 ms Minne: 0.011 MB / 4.07 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Tid: 0.05 ms / 129.54 ms Minne: -0.004 MB / 4.06 MB Application: beforeRenderModule mod_custom (yxlogo)

Tid: 0.17 ms / 129.72 ms Minne: 0.005 MB / 4.07 MB Application: afterRenderModule mod_custom (yxlogo)

Tid: 3.30 ms / 133.02 ms Minne: 0.061 MB / 4.13 MB Application: afterRender

Totalt antall database-spørringer: 47.82 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	yx_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:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:804
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:364
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	yx_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:806
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:364
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 `yx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6d75727530666e7139346e73716a3075326f3733736a326a6b74', 1, 1727720531, 0, '', 0)

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
update	0.27 ms
Waiting for query cache lock	0.01 ms
update	0.05 ms
end	0.01 ms
query end	2.99 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.05 ms
updating status	0.04 ms
cleaning up	0.01 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:806
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:364
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.45 ms Etter siste spørring: 0.64 ms Spørreminne: 0.040 MB Minne før spørring: 1.076 MB Rader funnet: 40

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

  FROM `yx_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	yx_extensions	ref	extension	extension	82	const	41	Using index condition; Using where

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.07 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.14 ms
preparing	0.04 ms
executing	0.00 ms
Sending data	0.48 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.05 ms
cleaning up	0.01 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:203
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.72 ms Etter siste spørring: 0.69 ms Spørreminne: 0.021 MB Minne før spørring: 1.111 MB Rader funnet: 4

SELECT id, rules

  FROM `yx_viewlevels`

Forklar

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.07 ms
cleaning up	0.01 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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.84 ms Etter siste spørring: 0.15 ms Spørreminne: 0.021 MB Minne før spørring: 1.122 MB Rader funnet: 2

SELECT b.id

  FROM yx_usergroups AS a

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

  WHERE a.id = 9

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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using where; Using index

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.07 ms
cleaning up	0.01 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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.10 ms Etter siste spørring: 0.25 ms Spørreminne: 0.030 MB Minne før spørring: 1.144 MB Rader funnet: 93

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

  FROM yx_extensions

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

  ORDER BY ordering

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	yx_extensions	ref	extension	extension	82	const	121	Using index condition; Using where; Bruker filsortering

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.19 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.12 ms
cleaning up	0.01 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:354
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:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.92 ms Etter siste spørring: 6.76 ms Spørreminne: 0.022 MB Minne før spørring: 1.586 MB Rader funnet: 1

Duplikat-spørringer: #9

SELECT template

  FROM yx_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Forklar

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.17 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:645
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:203
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.62 ms Etter siste spørring: 0.13 ms Spørreminne: 0.023 MB Minne før spørring: 1.594 MB Rader funnet: 1

Duplikat-spørringer: #8

SELECT template

  FROM yx_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Forklar

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

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.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:645
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:203
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.55 ms Etter siste spørring: 0.95 ms Spørreminne: 0.021 MB Minne før spørring: 1.700 MB Rader funnet: 2

SELECT extension, file, type

  FROM yx_rokcommon_configs

  ORDER BY priority

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	yx_rokcommon_configs	ALL	NULL	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	2	Bruker filsortering

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Oppkaller	Fil og linjenummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:645
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:203
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.44 ms Etter siste spørring: 4.15 ms Spørreminne: 0.026 MB Minne før spørring: 1.852 MB Rader funnet: 18

SHOW FULL COLUMNS 
  FROM `yx_extensions`

Forklar

'EXPLAIN' er ikke mulig på spørringen: SHOW FULL COLUMNS FROM `yx_extensions`

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.40 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
checking permissions	0.07 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.14 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
8	plgSystemRokSprocket->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:646
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:203
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.72 ms Etter siste spørring: 0.41 ms Spørreminne: 0.021 MB Minne før spørring: 1.880 MB Rader funnet: 1

SELECT `extension_id`

  FROM `yx_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Forklar

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.04 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.08 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
8	plgSystemRokSprocket->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:646
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:203
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.63 ms Etter siste spørring: 0.15 ms Spørreminne: 0.021 MB Minne før spørring: 1.886 MB Rader funnet: 1

Duplikat-spørringer: #15

SELECT *

  FROM yx_extensions

  WHERE `extension_id` = '753'

Forklar

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Oppkaller	Fil og linjenummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
8	plgSystemRokSprocket->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:646
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:203
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.58 ms Etter siste spørring: 0.05 ms Spørreminne: 0.021 MB Minne før spørring: 1.891 MB Rader funnet: 1

SELECT `extension_id`

  FROM `yx_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Forklar

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.03 ms
updating status	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Oppkaller	Fil og linjenummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
8	plgSystemRokSprocket->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:646
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:203
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.04 ms Spørreminne: 0.021 MB Minne før spørring: 1.897 MB Rader funnet: 1

Duplikat-spørringer: #13

SELECT *

  FROM yx_extensions

  WHERE `extension_id` = '753'

Forklar

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.00 ms
Unlocking tables	0.03 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
8	plgSystemRokSprocket->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:646
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:203
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.83 ms Etter siste spørring: 5.73 ms Spørreminne: 0.099 MB Minne før spørring: 2.066 MB Rader funnet: 34

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

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

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.07 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.80 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.06 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Samme som oppkall i linjen nedenfor.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:395
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:511
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1119
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:203
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.25 ms Etter siste spørring: 1.65 ms Spørreminne: 0.055 MB Minne før spørring: 2.372 MB Rader funnet: 17

Duplikat-spørringer: #31 #32

SELECT id, home, template, s.params

  FROM yx_template_styles as s

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

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 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.10 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.47 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.05 ms
updating status	0.03 ms
cleaning up	0.01 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/t3/includes/core/t3.php:320
9	T3::detect()	JROOT/plugins/system/t3/t3.php:81
8	plgSystemT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1168
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:203
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.74 ms Etter siste spørring: 1.79 ms Spørreminne: 0.026 MB Minne før spørring: 2.452 MB Rader funnet: 40

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `yx_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_chronoforums','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gantry','com_installer','com_jaextmanager','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_roksprocket','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	yx_assets	range	idx_asset_name	idx_asset_name	202	NULL	41	Using index condition

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.09 ms
optimizing	0.02 ms
statistics	0.22 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.85 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
14	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
13	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
12	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
11	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
10	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/sourcerer/helper.php:44
9	plgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:96
8	plgSystemSourcerer->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:1168
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:203
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.65 ms Etter siste spørring: 0.33 ms Spørreminne: 0.022 MB Minne før spørring: 2.509 MB Rader funnet: 1

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

  FROM `yx_extensions`

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

Forklar

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.07 ms
cleaning up	0.01 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:1131
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:203
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: 3.32 ms Etter siste spørring: 0.21 ms Spørreminne: 0.005 MB Minne før spørring: 2.499 MB

UPDATE `yx_extensions`

  SET `params` = '{\"mediaversion\":\"0fdaea59f638ccbdcd53036ef1956119\"}'

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

Forklar

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.10 ms
updating	0.09 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	2.63 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.09 ms
cleaning up	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:1131
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:203
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.75 ms Etter siste spørring: 0.45 ms Spørreminne: 0.019 MB Minne før spørring: 2.529 MB Rader funnet: 0

SELECT *

  FROM yx_languages

  WHERE published=1

  ORDER BY ordering ASC

Forklar

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.05 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.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.05 ms
updating status	0.03 ms
cleaning up	0.00 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:203
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: 3.57 ms Etter siste spørring: 11.73 ms Spørreminne: 0.025 MB Minne før spørring: 2.721 MB Rader funnet: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
SELECT COUNT(i.`id`)

  FROM `yx_contact_details` AS `i`

  WHERE i.`catid` = c.id 
  AND i.published = 1) AS numitems

  FROM `yx_categories` AS `s`

  INNER JOIN `yx_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_contact' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 66

  ORDER BY c.lft

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	PRIMARY	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	4	Using index condition; Using where; Bruker filsortering
2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_catid	4	infoyxno_stage.c.id	6	Using where

Profil

Status	Duration
starting	0.22 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	1.62 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.14 ms
optimizing	0.08 ms
statistics	0.23 ms
preparing	0.01 ms
Unlocking tables	0.04 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.07 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.23 ms
executing	0.01 ms
Sending data	0.06 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.05 ms
freeing items	0.01 ms
removing tmp table	0.01 ms
freeing items	0.02 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_contact/models/category.php:335
13	ContactModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_contact/views/category/view.html.php:54
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.44 ms Etter siste spørring: 0.61 ms Spørreminne: 0.024 MB Minne før spørring: 2.738 MB Rader funnet: 0

SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM `yx_contact_details` AS a

  LEFT JOIN yx_categories AS c 
  ON c.id = a.catid

  LEFT JOIN yx_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN yx_users AS uam 
  ON uam.id = a.modified_by

  WHERE a.access IN (1,1,5) 
  AND a.catid = 66 
  AND c.access IN (1,1,5) 
  AND a.published = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-30 18:22:11') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-30 18:22:11')

  ORDER BY name ASC 
  LIMIT 20

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	1	Using where; Bruker filsortering
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	infoyxno_stage.a.created_by	1	Using where

Profil

Status	Duration
starting	0.18 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.01 ms
init	0.10 ms
optimizing	0.14 ms
statistics	0.13 ms
preparing	0.01 ms
Unlocking tables	0.05 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
Creating sort index	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_contact/models/category.php:91
13	ContactModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_contact/views/category/view.html.php:54
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.28 ms Spørreminne: 0.024 MB Minne før spørring: 2.757 MB Rader funnet: 1

SELECT COUNT(*)

  FROM `yx_contact_details` AS a

  LEFT JOIN yx_categories AS c 
  ON c.id = a.catid

  LEFT JOIN yx_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN yx_users AS uam 
  ON uam.id = a.modified_by

  WHERE a.access IN (1,1,5) 
  AND a.catid = 66 
  AND c.access IN (1,1,5) 
  AND a.published = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-30 18:22:11') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-30 18:22:11')

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	1	Using where

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.13 ms
preparing	0.01 ms
Unlocking tables	0.04 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.07 ms
cleaning up	0.04 ms

Call Stack

#	Oppkaller	Fil og linjenummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
14	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
13	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:145
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_contact/views/category/view.html.php:54
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.97 ms Etter siste spørring: 0.76 ms Spørreminne: 0.022 MB Minne før spørring: 2.862 MB Rader funnet: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `yx_contentitem_tag_map` AS m 

  INNER JOIN `yx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_contact.category' 
  AND `m`.`content_item_id` = 66 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	infoyxno_stage.m.tag_id	1	Using where

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.08 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.09 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.03 ms
updating status	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_contact/views/category/view.html.php:54
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.91 ms Etter siste spørring: 3.24 ms Spørreminne: 0.028 MB Minne før spørring: 2.932 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 yx_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_contact.categories' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

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	infoyxno_stage.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	infoyxno_stage.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	infoyxno_stage.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	infoyxno_stage.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	infoyxno_stage.a.group_id	1	Using where

Profil

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.09 ms
optimizing	0.05 ms
statistics	0.14 ms
preparing	0.06 ms
Creating tmp table	0.10 ms
Sorting result	0.04 ms
executing	0.01 ms
Sending data	0.40 ms
Creating sort index	0.04 ms
removing tmp table	0.08 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.03 ms
updating status	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
24	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
23	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
22	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
21	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
20	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:25
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
16	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
15	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/components/com_contact/views/category/tmpl/default.php:13
14	include JROOT/components/com_contact/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_contact/views/category/view.html.php:83
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.50 ms Etter siste spørring: 4.38 ms Spørreminne: 0.030 MB Minne før spørring: 3.040 MB Rader funnet: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `yx_categories` AS `s`

  INNER JOIN `yx_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_contact' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 66

  ORDER BY c.lft

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	4	Using index condition; Using where; Bruker filsortering

Profil

Status	Duration
starting	0.18 ms
checking permissions	0.01 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.08 ms
optimizing	0.05 ms
statistics	0.22 ms
preparing	0.01 ms
Unlocking tables	0.05 ms
Sorting result	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
Creating sort index	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.05 ms
updating status	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
27	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
26	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
25	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
24	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
22	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
21	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:324
20	PlgSystemFields->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:28
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
16	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
15	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/components/com_contact/views/category/tmpl/default.php:13
14	include JROOT/components/com_contact/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_contact/views/category/view.html.php:83
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.91 ms Etter siste spørring: 0.22 ms Spørreminne: 0.028 MB Minne før spørring: 3.056 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 yx_fields AS a

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

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

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

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

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

  LEFT JOIN `yx_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_contact.categories' 
  AND (fc.category_id IS NULL OR fc.category_id IN (66,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

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	infoyxno_stage.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	infoyxno_stage.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	infoyxno_stage.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	infoyxno_stage.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	infoyxno_stage.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	infoyxno_stage.a.id	1	Using where; Using index; Distinct

Profil

Status	Duration
starting	0.22 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.10 ms
optimizing	0.07 ms
statistics	0.20 ms
preparing	0.09 ms
Creating tmp table	0.07 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.34 ms
Creating sort index	0.03 ms
removing tmp table	0.06 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.03 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
25	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
24	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
22	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
21	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:324
20	PlgSystemFields->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:28
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
16	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
15	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/components/com_contact/views/category/tmpl/default.php:13
14	include JROOT/components/com_contact/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_contact/views/category/view.html.php:83
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.55 ms Etter siste spørring: 0.44 ms Spørreminne: 0.029 MB Minne før spørring: 3.071 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 yx_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_contact.category.title' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

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	infoyxno_stage.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	infoyxno_stage.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	infoyxno_stage.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	infoyxno_stage.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	infoyxno_stage.a.group_id	1	Using where

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.14 ms
preparing	0.05 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.31 ms
Creating sort index	0.03 ms
removing tmp table	0.06 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
28	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
27	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
26	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
25	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
24	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
21	JHtmlContent::prepare()	Samme som oppkall i linjen nedenfor.
20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/layouts/joomla/content/category_default.php:57
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
16	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
15	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/components/com_contact/views/category/tmpl/default.php:13
14	include JROOT/components/com_contact/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_contact/views/category/view.html.php:83
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.63 ms Etter siste spørring: 1.08 ms Spørreminne: 0.029 MB Minne før spørring: 3.086 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 yx_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_contact.category.description' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

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	infoyxno_stage.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	infoyxno_stage.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	infoyxno_stage.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	infoyxno_stage.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	infoyxno_stage.a.group_id	1	Using where

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.06 ms
optimizing	0.05 ms
statistics	0.11 ms
preparing	0.04 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.35 ms
Creating sort index	0.03 ms
removing tmp table	0.06 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.06 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
28	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
27	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
26	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
25	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
24	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
21	JHtmlContent::prepare()	Samme som oppkall i linjen nedenfor.
20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/layouts/joomla/content/category_default.php:73
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
16	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
15	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/components/com_contact/views/category/tmpl/default.php:13
14	include JROOT/components/com_contact/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_contact/views/category/view.html.php:83
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.33 ms Etter siste spørring: 7.71 ms Spørreminne: 0.057 MB Minne før spørring: 3.598 MB Rader funnet: 17

Duplikat-spørringer: #17 #32

SELECT id, home, template, s.params

  FROM yx_template_styles as s

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.04 ms
executing	0.00 ms
Sending data	0.38 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Oppkaller	Fil og linjenummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
15	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:65
14	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
13	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
12	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
11	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
10	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
9	include JROOT/libraries/gantry/gantry.php	JROOT/templates/rt_chapelco/lib/gantry/gantry.php:21
8	require_once JROOT/templates/rt_chapelco/lib/gantry/gantry.php	JROOT/templates/rt_chapelco/index.php:16
7	require JROOT/templates/rt_chapelco/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
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:209
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.10 ms Etter siste spørring: 0.91 ms Spørreminne: 0.058 MB Minne før spørring: 3.679 MB Rader funnet: 17

Duplikat-spørringer: #17 #31

SELECT id, home, template, s.params

  FROM yx_template_styles as s

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

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.04 ms
executing	0.00 ms
Sending data	0.40 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
16	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/gantrytemplate.class.php:590
15	GantryTemplate::getTemplateParams()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69
14	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
13	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
12	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
11	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
10	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
9	include JROOT/libraries/gantry/gantry.php	JROOT/templates/rt_chapelco/lib/gantry/gantry.php:21
8	require_once JROOT/templates/rt_chapelco/lib/gantry/gantry.php	JROOT/templates/rt_chapelco/index.php:16
7	require JROOT/templates/rt_chapelco/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
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:209
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.40 ms Etter siste spørring: 4.61 ms Spørreminne: 0.026 MB Minne før spørring: 3.862 MB Rader funnet: 3

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

  FROM yx_modules AS m

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

  LEFT JOIN yx_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-09-30 18:22:11') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-30 18:22:11') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 189 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	range	PRIMARY,published,newsfeeds	published	5	NULL	8	Using index condition; Using where; Bruker filsortering
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	infoyxno_stage.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	infoyxno_stage.m.module,const	1	Using index condition; Using where

Profil

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.06 ms
optimizing	0.05 ms
statistics	0.09 ms
preparing	0.06 ms
Sorting result	0.01 ms
executing	0.03 ms
Sending data	0.02 ms
Creating sort index	0.30 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.04 ms
updating status	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	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/Helper/ModuleHelper.php:432
13	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
12	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
11	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
10	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/libraries/gantry/core/gantry.class.php:804
9	Gantry->getJoomlaModuleCount()	JROOT/libraries/gantry/core/gantry.class.php:757
8	Gantry->countModules()	JROOT/templates/rt_chapelco/index.php:61
7	require JROOT/templates/rt_chapelco/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
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:209
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.73 ms Etter siste spørring: 1.95 ms Spørreminne: 0.025 MB Minne før spørring: 3.986 MB Rader funnet: 1

SELECT ts.template

  FROM yx_template_styles AS ts

  INNER JOIN yx_menu AS m 
  ON ts.id=m.template_style_id

  WHERE m.id = 189 
  AND m.template_style_id != 0

Forklar

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.05 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:101
16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/rt_chapelco/features/dropdownmenu.php:58
10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
8	Gantry->displayModules()	JROOT/templates/rt_chapelco/index.php:74
7	require JROOT/templates/rt_chapelco/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
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:209
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.36 ms Etter siste spørring: 6.51 ms Spørreminne: 0.026 MB Minne før spørring: 4.071 MB Rader funnet: 6

SHOW FULL COLUMNS 
  FROM `yx_template_styles`

Forklar

'EXPLAIN' er ikke mulig på spørringen: SHOW FULL COLUMNS FROM `yx_template_styles`

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.28 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.10 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
freeing items	0.01 ms
updating status	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
16	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
15	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
14	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
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:209
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.66 ms Etter siste spørring: 0.20 ms Spørreminne: 0.023 MB Minne før spørring: 4.089 MB Rader funnet: 1

SELECT *

  FROM yx_template_styles

  WHERE `id` = '15'

Forklar

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.00 ms
Unlocking tables	0.03 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.03 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
14	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/gantry/gantry.php:168
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
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:209
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]

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

VELG tabeller:

3 × 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 yx_fields AS a 
  LEFT JOIN `yx_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN yx_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN yx_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN yx_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN yx_fields_groups AS g 
  ON g.id = a.group_id

3 × SELECT id, home, template, s.params 
  FROM yx_template_styles as s 
  LEFT JOIN yx_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

2 × SELECT template 
  FROM yx_template_styles as s

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

2 × SELECT `extension_id` 
  FROM `yx_extensions`

```
2 × SELECT * 
  FROM yx_extensions
```

1 × SELECT `data` 
  FROM `yx_session`

1 × SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email 
  FROM `yx_contact_details` AS a 
  LEFT JOIN yx_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN yx_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN yx_users AS uam 
  ON uam.id = a.modified_by

1 × SELECT ts.template 
  FROM yx_template_styles AS ts 
  INNER JOIN yx_menu AS m 
  ON ts.id=m.template_style_id

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

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 yx_fields AS a 
  LEFT JOIN `yx_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN yx_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN yx_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN yx_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN yx_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `yx_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `yx_categories` AS `s` 
  INNER JOIN `yx_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `yx_contentitem_tag_map` AS m  
  INNER JOIN `yx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT COUNT(*) 
  FROM `yx_contact_details` AS a 
  LEFT JOIN yx_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN yx_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN yx_users AS uam 
  ON uam.id = a.modified_by

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `yx_assets`

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`) 
  FROM `yx_contact_details` AS `i`

```
1 × SELECT * 
  FROM yx_languages
```

1 × SELECT `session_id` 
  FROM `yx_session`

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

1 × SELECT extension, file, type 
  FROM yx_rokcommon_configs

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

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

1 × SELECT id, rules 
  FROM `yx_viewlevels

1 × SELECT * 
  FROM yx_template_styles

ANDRE tabeller:

1 × INSERT INTO `yx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6d75727530666e7139346e73716a3075326f3733736a326a6b74', 1, 1727720531, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `yx_extensions

1 × UPDATE `yx_extensions` 
  SET `params` = '{\"mediaversion\":\"0fdaea59f638ccbdcd53036ef1956119\"}'

1 × SHOW FULL COLUMNS 
  FROM `yx_template_styles

YX

Joomlas feilsøkingskonsoll

Økt

Profileringinformasjon

Tid

Minne

Minneforbruk

Database-spørringer

36 spørring(er) logget 47.82 ms

7 duplikat ble funnet.

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

VELG tabeller:

ANDRE tabeller: