Følg oss på Facebook

Villekulla Barneogungdomsteater

Meny

Joomlas feilsøkingskonsoll

Økt

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1778425538,
                "last": 1778425538,
                "now": 1778425538
            },
            "token": "dl6yXzSNaXRpjRu1bPVdJ8DxbZj0C2rw"
        },
        "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
        },
        "com_mailto": {
            "links": {
                "cb1187880bb446dd62ab3e3baf9c053376bc44d6": {
                    "link": "https://www.villekullabarneteater.no/index.php/om-villekulla/folg-oss-pa-facebook",
                    "expiry": 1778425538
                }
            }
        }
    }
}

Profileringinformasjon

Tid

Minne

Tid: 42.31 ms / 42.31 ms Minne: 1.996 MB / 2.38 MB Application: afterLoad

Tid: 139.04 ms / 181.35 ms Minne: 5.124 MB / 7.51 MB Application: afterInitialise

Tid: 61.31 ms / 242.66 ms Minne: 1.623 MB / 9.13 MB Application: afterRoute

Tid: 1.45 ms / 244.10 ms Minne: 0.024 MB / 9.15 MB Application: beforeRenderComponent com_k2

Tid: 0.72 ms / 244.82 ms Minne: 0.027 MB / 9.18 MB Application: Before Access::preloadComponents (all components)

Tid: 5.58 ms / 250.41 ms Minne: 0.053 MB / 9.23 MB Application: After Access::preloadComponents (all components)

Tid: 0.08 ms / 250.49 ms Minne: -0.003 MB / 9.23 MB Application: Before Access::getAssetRules (id:1809 name:com_k2)

Tid: 1.53 ms / 252.02 ms Minne: 0.026 MB / 9.26 MB Application: After Access::getAssetRules (id:1809 name:com_k2)

Tid: 131.31 ms / 383.33 ms Minne: 3.475 MB / 12.73 MB Application: afterRenderComponent com_k2

Tid: 3.02 ms / 386.35 ms Minne: 0.098 MB / 12.83 MB Application: afterDispatch

Tid: 24.25 ms / 410.60 ms Minne: 0.370 MB / 13.20 MB Application: beforeRenderModule mod_login (Login)

Tid: 11.98 ms / 422.58 ms Minne: 0.909 MB / 14.11 MB Application: afterRenderModule mod_login (Login)

Tid: 0.28 ms / 422.86 ms Minne: 0.023 MB / 14.13 MB Application: beforeRenderModule mod_zentools2 (Banner - Backgrunn)

Tid: 9.30 ms / 432.16 ms Minne: 0.279 MB / 14.41 MB Application: afterRenderModule mod_zentools2 (Banner - Backgrunn)

Tid: 0.15 ms / 432.31 ms Minne: -0.058 MB / 14.35 MB Application: beforeRenderModule mod_custom (Footer)

Tid: 4.28 ms / 436.58 ms Minne: 0.021 MB / 14.37 MB Application: afterRenderModule mod_custom (Footer)

Tid: 0.08 ms / 436.66 ms Minne: -0.001 MB / 14.37 MB Application: beforeRenderModule mod_menu (Footer)

Tid: 5.46 ms / 442.12 ms Minne: 0.137 MB / 14.51 MB Application: afterRenderModule mod_menu (Footer)

Tid: 0.13 ms / 442.25 ms Minne: -0.003 MB / 14.50 MB Application: beforeRenderModule mod_menu (Main Menu)

Tid: 12.07 ms / 454.32 ms Minne: 0.072 MB / 14.58 MB Application: afterRenderModule mod_menu (Main Menu)

Tid: 0.12 ms / 454.44 ms Minne: -0.005 MB / 14.57 MB Application: beforeRenderModule mod_custom (Logo)

Tid: 0.69 ms / 455.13 ms Minne: 0.003 MB / 14.58 MB Application: afterRenderModule mod_custom (Logo)

Tid: 36.95 ms / 492.08 ms Minne: 0.348 MB / 14.92 MB Application: afterRender

Totalt antall database-spørringer: 98.71 ms

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

#	Oppkaller	Fil og linjenummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Samme som oppkall i linjen nedenfor.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

#	Oppkaller	Fil og linjenummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Profil

Status	Duration
starting	0.18 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.02 ms
update	0.26 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.87 ms
closing tables	0.05 ms
freeing items	0.15 ms
cleaning up	0.02 ms

Call Stack

#	Oppkaller	Fil og linjenummer
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Spørringstid: 3.03 ms Etter siste spørring: 5.33 ms Spørreminne: 0.040 MB Minne før spørring: 4.441 MB Rader funnet: 39

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

  FROM `cni5j_extensions`

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

Forklar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cni5j_extensions	NULL	ref	extension	extension	62	const	39	1.00	Using where

Profil

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

Call Stack

#	Oppkaller	Fil og linjenummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Samme som oppkall i linjen nedenfor.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 1.98 ms Etter siste spørring: 5.28 ms Spørreminne: 0.021 MB Minne før spørring: 4.703 MB Rader funnet: 4

SELECT id, rules

  FROM `cni5j_viewlevels`

Forklar

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

Profil

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

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

Spørringstid: 2.40 ms Etter siste spørring: 0.22 ms Spørreminne: 0.021 MB Minne før spørring: 4.714 MB Rader funnet: 2

SELECT b.id

  FROM cni5j_usergroups AS a

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

  WHERE a.id = 9

Forklar

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

Profil

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

Call Stack

#	Oppkaller	Fil og linjenummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 3.23 ms Etter siste spørring: 1.45 ms Spørreminne: 0.030 MB Minne før spørring: 4.783 MB Rader funnet: 97

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

  FROM cni5j_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cni5j_extensions	NULL	ref	extension	extension	62	const	131	0.60	Using where; Bruker filsortering

Profil

Status	Duration
starting	0.32 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.09 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.13 ms
preparing	0.07 ms
executing	1.99 ms
end	0.03 ms
query end	0.02 ms
waiting for handler commit	0.03 ms
closing tables	0.03 ms
freeing items	0.22 ms
cleaning up	0.02 ms

Call Stack

#	Oppkaller	Fil og linjenummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Samme som oppkall i linjen nedenfor.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 3.10 ms Etter siste spørring: 58.08 ms Spørreminne: 0.023 MB Minne før spørring: 7.334 MB Rader funnet: 21

SELECT *

  FROM cni5j_rsform_config

Forklar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cni5j_rsform_config	NULL	ALL	NULL	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	21	100.00	NULL

Profil

Status	Duration
starting	0.25 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	1.97 ms
init	0.03 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.26 ms
end	0.04 ms
query end	0.02 ms
closing tables	0.05 ms
freeing items	0.17 ms
cleaning up	0.02 ms

Call Stack

#	Oppkaller	Fil og linjenummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:97
9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28
8	plgSystemRsformdeletesubmissions->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 6.36 ms Etter siste spørring: 6.63 ms Spørreminne: 0.048 MB Minne før spørring: 7.695 MB Rader funnet: 21

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

  LEFT JOIN cni5j_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	153	6.86	Using where; Bruker filsortering
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	villekul_db2.m.component_id	1	100.00	Using where

Profil

Status	Duration
starting	0.35 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	3.21 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.27 ms
preparing	0.11 ms
executing	1.73 ms
end	0.03 ms
query end	0.02 ms
waiting for handler commit	0.03 ms
closing tables	0.09 ms
freeing items	0.19 ms
cleaning up	0.02 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:78
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:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
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:533
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:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 1.32 ms Etter siste spørring: 21.19 ms Spørreminne: 0.024 MB Minne før spørring: 8.451 MB Rader funnet: 1

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

  FROM `cni5j_extensions`

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

Forklar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cni5j_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	NULL

Profil

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

Call Stack

#	Oppkaller	Fil og linjenummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{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/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:389
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 1.89 ms Etter siste spørring: 0.38 ms Spørreminne: 0.006 MB Minne før spørring: 8.443 MB

UPDATE `cni5j_extensions`

  SET `params` = '{\"mediaversion\":\"4e45c5964fa091893171a6a4a662f90b\"}'

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

Forklar

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

Profil

Status	Duration
starting	0.22 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
init	0.02 ms
System lock	0.18 ms
updating	0.27 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.69 ms
closing tables	0.03 ms
freeing items	0.21 ms
cleaning up	0.02 ms

Call Stack

#	Oppkaller	Fil og linjenummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:389
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 3.49 ms Etter siste spørring: 9.10 ms Spørreminne: 0.022 MB Minne før spørring: 8.815 MB Rader funnet: 1

SELECT *

  FROM cni5j_languages

  WHERE published=1

  ORDER BY ordering ASC

Forklar

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

Profil

Status	Duration
starting	0.26 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	2.33 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.07 ms
executing	0.21 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.18 ms
cleaning up	0.02 ms

Call Stack

#	Oppkaller	Fil og linjenummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
12	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
11	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:254
10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:244
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:405
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 3.91 ms Etter siste spørring: 6.39 ms Spørreminne: 0.027 MB Minne før spørring: 9.117 MB Rader funnet: 22

SELECT id, home, template, s.params

  FROM cni5j_template_styles as s

  LEFT JOIN cni5j_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	62	const	5	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	152	villekul_db2.e.element	4	91.67	Using index condition; Using where

Profil

Status	Duration
starting	0.29 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	2.05 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.33 ms
preparing	0.10 ms
executing	0.50 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.09 ms
freeing items	0.17 ms
cleaning up	0.02 ms

Call Stack

#	Oppkaller	Fil og linjenummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
17	Joomla\CMS\HTML\HTMLHelper::script()	Samme som oppkall i linjen nedenfor.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	Samme som oppkall i linjen nedenfor.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_k2/helpers/html.php:268
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:405
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 5.00 ms Etter siste spørring: 5.31 ms Spørreminne: 0.025 MB Minne før spørring: 9.184 MB Rader funnet: 39

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

  FROM `cni5j_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_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_k2','com_k2store','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_rsform','com_search','com_sigpro','com_tags','com_templates','com_users','com_wrapper')

Forklar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cni5j_assets	NULL	range	idx_asset_name	idx_asset_name	152	NULL	40	100.00	Using index condition

Profil

Status	Duration
starting	0.33 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	2.35 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.26 ms
preparing	0.06 ms
executing	1.43 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.07 ms
freeing items	0.17 ms
cleaning up	0.02 ms

Call Stack

#	Oppkaller	Fil og linjenummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
11	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
10	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
9	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
8	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
7	Joomla\CMS\User\User->authorise()	JROOT/components/com_k2/k2.php:15
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 4.30 ms Etter siste spørring: 23.28 ms Spørreminne: 0.022 MB Minne før spørring: 10.095 MB Rader funnet: 6

SELECT id 
  FROM cni5j_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1,5)

Forklar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cni5j_k2_categories	NULL	ref	category,published,access,trash	published	2	const	6	100.00	Using where

Profil

Status	Duration
starting	0.26 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	2.79 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.39 ms
preparing	0.06 ms
executing	0.24 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.05 ms
freeing items	0.17 ms
cleaning up	0.02 ms

Call Stack

#	Oppkaller	Fil og linjenummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:225
12	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/item/view.html.php:37
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 4.45 ms Etter siste spørring: 0.25 ms Spørreminne: 0.023 MB Minne før spørring: 10.102 MB Rader funnet: 1

SELECT * 
  FROM cni5j_k2_items 
  WHERE id=21 
  LIMIT 0, 1

Forklar

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

Profil

Status	Duration
starting	0.22 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	3.23 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.24 ms
preparing	0.06 ms
executing	0.11 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.06 ms
freeing items	0.18 ms
cleaning up	0.02 ms

Call Stack

#	Oppkaller	Fil og linjenummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:33
12	K2ModelItem->getData()	JROOT/components/com_k2/views/item/view.html.php:44
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 6.10 ms Etter siste spørring: 1.54 ms Spørreminne: 0.028 MB Minne før spørring: 10.149 MB Rader funnet: 14

SHOW FULL COLUMNS 
  FROM `cni5j_k2_categories`

Forklar

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

Profil

Status	Duration
starting	0.28 ms
Executing hook on transaction	0.02 ms
starting	0.09 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	3.11 ms
init	0.03 ms
System lock	0.03 ms
optimizing	0.07 ms
statistics	0.44 ms
preparing	0.10 ms
Creating tmp table	0.15 ms
executing	0.29 ms
checking permissions	0.20 ms
checking permissions	0.13 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.06 ms
checking permissions	0.08 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.12 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.03 ms
freeing items	0.20 ms
cleaning up	0.02 ms

Call Stack

#	Oppkaller	Fil og linjenummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:34
14	TableK2Category->__construct()	JROOT/libraries/src/Table/Table.php:328
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:64
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 0.80 ms Etter siste spørring: 1.29 ms Spørreminne: 0.023 MB Minne før spørring: 10.187 MB Rader funnet: 1

SELECT * 
  FROM cni5j_k2_categories 
  WHERE id = '1'

Forklar

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

Profil

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

Call Stack

#	Oppkaller	Fil og linjenummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
13	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 1.07 ms Etter siste spørring: 2.46 ms Spørreminne: 0.024 MB Minne før spørring: 10.262 MB Rader funnet: 6

SELECT id, name, parent 
  FROM cni5j_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1,5) 
  ORDER BY parent

Forklar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cni5j_k2_categories	NULL	ref	category,published,access,trash	published	2	const	6	100.00	Using where; Bruker filsortering

Profil

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

Call Stack

#	Oppkaller	Fil og linjenummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:881
15	K2ModelItemlist->getCategoriesTree()	JROOT/components/com_k2/helpers/route.php:261
14	K2HelperRoute::findMenuItem()	JROOT/components/com_k2/helpers/route.php:56
13	K2HelperRoute::getCategoryRoute()	JROOT/components/com_k2/models/item.php:68
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 1.89 ms Etter siste spørring: 1.56 ms Spørreminne: 0.023 MB Minne før spørring: 10.327 MB Rader funnet: 0

SELECT * 
  FROM cni5j_k2_attachments 
  WHERE itemID=21

Forklar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cni5j_k2_attachments	NULL	ref	itemID	itemID	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.17 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	1.03 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.03 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.07 ms
freeing items	0.12 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/components/com_k2/models/item.php:1450
13	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:164
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 4.74 ms Etter siste spørring: 1.49 ms Spørreminne: 0.029 MB Minne før spørring: 10.399 MB Rader funnet: 17

SHOW FULL COLUMNS 
  FROM `cni5j_users`

Forklar

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

Profil

Status	Duration
starting	0.21 ms
Executing hook on transaction	0.01 ms
starting	1.05 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	1.38 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.23 ms
preparing	0.06 ms
Creating tmp table	0.09 ms
executing	0.14 ms
checking permissions	0.11 ms
checking permissions	0.06 ms
checking permissions	0.07 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.06 ms
checking permissions	0.04 ms
checking permissions	0.14 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.04 ms
freeing items	0.16 ms
cleaning up	0.02 ms

Call Stack

#	Oppkaller	Fil og linjenummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
20	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
19	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
18	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
17	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:210
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 1.18 ms Etter siste spørring: 0.27 ms Spørreminne: 0.025 MB Minne før spørring: 10.430 MB Rader funnet: 1

SELECT *

  FROM `cni5j_users`

  WHERE `id` = 19

Forklar

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

Profil

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

Call Stack

#	Oppkaller	Fil og linjenummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:210
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 2.00 ms Etter siste spørring: 6.51 ms Spørreminne: 0.025 MB Minne før spørring: 11.184 MB Rader funnet: 1

SELECT `g`.`id`,`g`.`title`

  FROM `cni5j_usergroups` AS g

  INNER JOIN `cni5j_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 19

Forklar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	villekul_db2.m.group_id	1	100.00	NULL

Profil

Status	Duration
starting	0.19 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.97 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.15 ms
preparing	0.06 ms
executing	0.06 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.09 ms
freeing items	0.13 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:210
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 2.07 ms Etter siste spørring: 1.60 ms Spørreminne: 0.023 MB Minne før spørring: 11.190 MB Rader funnet: 1

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM cni5j_k2_users 
  WHERE userID=19

Forklar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cni5j_k2_users	NULL	ref	userID	userID	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.18 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	1.20 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.03 ms
executing	0.09 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.03 ms
freeing items	0.14 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
14	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:46
13	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:213
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 2.03 ms Etter siste spørring: 0.16 ms Spørreminne: 0.023 MB Minne før spørring: 11.198 MB Rader funnet: 1

SELECT COUNT(*) 
  FROM cni5j_k2_comments 
  WHERE itemID=21 
  AND published=1

Forklar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cni5j_k2_comments	NULL	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	100.00	Using index

Profil

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	1.17 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.22 ms
preparing	0.05 ms
executing	0.06 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.14 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/components/com_k2/models/item.php:1489
13	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:227
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 5.45 ms Etter siste spørring: 20.35 ms Spørreminne: 0.026 MB Minne før spørring: 12.000 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 cni5j_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_k2.item-media' 
  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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Bruker filsortering
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	villekul_db2.a.language	1	100.00	Using index condition
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	villekul_db2.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	villekul_db2.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	villekul_db2.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	villekul_db2.a.group_id	1	100.00	Using where

Profil

Status	Duration
starting	0.40 ms
Executing hook on transaction	0.02 ms
starting	0.02 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
Opening tables	3.61 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.44 ms
preparing	0.06 ms
Creating tmp table	0.12 ms
executing	0.12 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.08 ms
freeing items	0.15 ms
cleaning up	0.03 ms

Call Stack

#	Oppkaller	Fil og linjenummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:603
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 2.80 ms Etter siste spørring: 2.66 ms Spørreminne: 0.025 MB Minne før spørring: 12.058 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 cni5j_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_k2.item' 
  AND (fc.category_id IS NULL OR fc.category_id IN (1,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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Bruker filsortering
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	villekul_db2.a.language	1	100.00	Using index condition
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	villekul_db2.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	villekul_db2.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	villekul_db2.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	villekul_db2.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	villekul_db2.a.id	1	100.00	Using where; Using index; Distinct

Profil

Status	Duration
starting	0.41 ms
Executing hook on transaction	0.02 ms
starting	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
Opening tables	1.07 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.27 ms
preparing	0.07 ms
Creating tmp table	0.20 ms
executing	0.13 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.06 ms
freeing items	0.14 ms
cleaning up	0.02 ms

Call Stack

#	Oppkaller	Fil og linjenummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:674
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 1.03 ms Etter siste spørring: 6.85 ms Spørreminne: 0.025 MB Minne før spørring: 12.439 MB Rader funnet: 1

SELECT * 
  FROM cni5j_k2_items 
  WHERE id=21

Forklar

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

Profil

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

Call Stack

#	Oppkaller	Fil og linjenummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_k2store/helpers/cart.php:294
17	K2StoreHelperCart::getItemInfo()	JROOT/plugins/k2/k2store/k2store.php:387
16	plgK2K2Store->_loadCart()	JROOT/plugins/k2/k2store/k2store.php:98
15	plgK2K2Store->onK2AfterDisplay()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:771
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 4.86 ms Etter siste spørring: 1.40 ms Spørreminne: 0.036 MB Minne før spørring: 12.498 MB Rader funnet: 36

SHOW FULL COLUMNS 
  FROM `cni5j_k2_items`

Forklar

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

Profil

Status	Duration
starting	0.24 ms
Executing hook on transaction	0.02 ms
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	1.58 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.28 ms
preparing	0.07 ms
Creating tmp table	0.11 ms
executing	0.14 ms
checking permissions	0.12 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.07 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.14 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.04 ms
freeing items	0.16 ms
cleaning up	0.02 ms

Call Stack

#	Oppkaller	Fil og linjenummer
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
22	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2item.php:56
21	TableK2Item->__construct()	JROOT/libraries/src/Table/Table.php:328
20	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_k2store/library/prices.php:303
19	K2StorePrices::_getK2Item()	JROOT/administrator/components/com_k2store/library/prices.php:239
18	K2StorePrices::getProduct()	JROOT/components/com_k2store/helpers/cart.php:296
17	K2StoreHelperCart::getItemInfo()	JROOT/plugins/k2/k2store/k2store.php:387
16	plgK2K2Store->_loadCart()	JROOT/plugins/k2/k2store/k2store.php:98
15	plgK2K2Store->onK2AfterDisplay()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:771
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 0.79 ms Etter siste spørring: 0.41 ms Spørreminne: 0.027 MB Minne før spørring: 12.551 MB Rader funnet: 1

SELECT *

  FROM cni5j_k2_items

  WHERE `id` = '21'

Forklar

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

Profil

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

Call Stack

#	Oppkaller	Fil og linjenummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
22	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
21	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_k2/tables/table.php:20
20	K2Table->load()	JROOT/administrator/components/com_k2store/library/prices.php:305
19	K2StorePrices::_getK2Item()	JROOT/administrator/components/com_k2store/library/prices.php:239
18	K2StorePrices::getProduct()	JROOT/components/com_k2store/helpers/cart.php:296
17	K2StoreHelperCart::getItemInfo()	JROOT/plugins/k2/k2store/k2store.php:387
16	plgK2K2Store->_loadCart()	JROOT/plugins/k2/k2store/k2store.php:98
15	plgK2K2Store->onK2AfterDisplay()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:771
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 1.88 ms Etter siste spørring: 0.24 ms Spørreminne: 0.025 MB Minne før spørring: 12.562 MB Rader funnet: 0

SELECT *

  FROM cni5j_k2store_products

  WHERE product_id='21'

Forklar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cni5j_k2store_products	NULL	ref	product_id	product_id	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	1.18 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.12 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_k2store/library/prices.php:244
18	K2StorePrices::getProduct()	JROOT/components/com_k2store/helpers/cart.php:296
17	K2StoreHelperCart::getItemInfo()	JROOT/plugins/k2/k2store/k2store.php:387
16	plgK2K2Store->_loadCart()	JROOT/plugins/k2/k2store/k2store.php:98
15	plgK2K2Store->onK2AfterDisplay()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:771
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM cni5j_k2store_storeprofiles

  WHERE state=1

  ORDER BY store_id ASC 
  LIMIT 1

Forklar

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

Profil

Status	Duration
starting	0.18 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	1.14 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.12 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/components/com_k2store/helpers/cart.php:471
18	K2StoreHelperCart::getStoreAddress()	JROOT/components/com_k2store/helpers/cart.php:313
17	K2StoreHelperCart::getItemInfo()	JROOT/plugins/k2/k2store/k2store.php:387
16	plgK2K2Store->_loadCart()	JROOT/plugins/k2/k2store/k2store.php:98
15	plgK2K2Store->onK2AfterDisplay()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:771
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 1.72 ms Etter siste spørring: 0.65 ms Spørreminne: 0.008 MB Minne før spørring: 12.613 MB

UPDATE cni5j_k2_items

  SET `hits` = (`hits` + 1)

  WHERE `id` = '21'

Forklar

'EXPLAIN' er ikke mulig på spørringen: UPDATE cni5j_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '21'

Profil

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.08 ms
updating	0.22 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.93 ms
closing tables	0.02 ms
freeing items	0.12 ms
cleaning up	0.01 ms

Call Stack

#	Oppkaller	Fil og linjenummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
13	Joomla\CMS\Table\Table->hit()	JROOT/components/com_k2/models/item.php:855
12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 5.20 ms Etter siste spørring: 17.66 ms Spørreminne: 0.026 MB Minne før spørring: 13.272 MB Rader funnet: 6

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

  FROM cni5j_modules AS m

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

  LEFT JOIN cni5j_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 <= '2026-05-10 15:05:38') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-05-10 15:05:38') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 427 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Forklar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	23	1.60	Using index condition; Using where; Bruker filsortering
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	villekul_db2.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	villekul_db2.m.id	4	40.00	Using where; Using index

Profil

Status	Duration
starting	0.27 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	2.49 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.06 ms
statistics	0.26 ms
preparing	0.09 ms
executing	1.48 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.05 ms
freeing items	0.15 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()	Samme som oppkall i linjen nedenfor.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/buildr/zengrid/zen.php:202
11	Zen4->countModules()	JROOT/templates/buildr/zengrid/zen.php:1395
10	Zen4->getMainLayout()	JROOT/templates/buildr/zengrid/zen.php:826
9	Zen4->bodyclass()	JROOT/templates/buildr/tpls/default.php:5
8	include JROOT/templates/buildr/tpls/default.php	JROOT/templates/buildr/index.php:53
7	require JROOT/templates/buildr/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Spørringstid: 1.85 ms Etter siste spørring: 36.02 ms Spørreminne: 0.026 MB Minne før spørring: 14.381 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 cni5j_fields AS a

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

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

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

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

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

  WHERE a.context = 'mod_custom.content' 
  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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Bruker filsortering
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	villekul_db2.a.language	1	100.00	Using index condition
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	villekul_db2.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	villekul_db2.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	villekul_db2.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	villekul_db2.a.group_id	1	100.00	Using where

Profil

Status	Duration
starting	0.38 ms
Executing hook on transaction	0.02 ms
starting	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
Opening tables	0.18 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.35 ms
preparing	0.06 ms
Creating tmp table	0.13 ms
executing	0.10 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.03 ms
freeing items	0.13 ms
cleaning up	0.02 ms

Call Stack

#	Oppkaller	Fil og linjenummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Samme som oppkall i linjen nedenfor.
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

VELG tabeller:

```
3 × SELECT * 
  FROM cni5j_k2_items
```

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

2 × 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 cni5j_fields AS a 
  LEFT JOIN `cni5j_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN cni5j_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN cni5j_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN cni5j_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN cni5j_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT id, name, parent 
  FROM cni5j_k2_categories

1 × SELECT * 
  FROM cni5j_k2store_storeprofiles

1 × SELECT * 
  FROM cni5j_k2store_products

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 cni5j_fields AS a 
  LEFT JOIN `cni5j_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN cni5j_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN cni5j_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN cni5j_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN cni5j_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `cni5j_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT COUNT(*) 
  FROM cni5j_k2_comments

1 × SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM cni5j_k2_users

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `cni5j_usergroups` AS g 
  INNER JOIN `cni5j_user_usergroup_map` AS m 
  ON m.group_id = g.id

```
1 × SELECT * 
  FROM `cni5j_users`
```

1 × SELECT * 
  FROM cni5j_k2_attachments

1 × SELECT `data` 
  FROM `cni5j_session`

1 × SELECT * 
  FROM cni5j_k2_categories

1 × SELECT `session_id` 
  FROM `cni5j_session`

1 × SELECT id 
  FROM cni5j_k2_categories

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

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

```
1 × SELECT * 
  FROM cni5j_languages
```

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

1 × SELECT * 
  FROM cni5j_rsform_confi

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

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

1 × SELECT id, rules 
  FROM `cni5j_viewlevels

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

ANDRE tabeller:

1 × INSERT INTO `cni5j_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3166343638616266303638343465363866323862353939313331653335383033', 1, 1778425538, 0, '', 0

1 × UPDATE `cni5j_extensions` 
  SET `params` = '{\"mediaversion\":\"4e45c5964fa091893171a6a4a662f90b\"}'

1 × SHOW FULL COLUMNS 
  FROM `cni5j_k2_categories

1 × SHOW FULL COLUMNS 
  FROM `cni5j_users

1 × SHOW FULL COLUMNS 
  FROM `cni5j_k2_items

1 × UPDATE cni5j_k2_items 
  SET `hits` = (`hits` + 1)