Malin Schavenius
torsdag, 13 juni 2019 07:43
Ny musikkvideo!
Candy Store - Heathers the musical.
Publisert i
Nyheter
Merket under
søndag, 09 juni 2019 14:57
Villekulla tilbake på Tv2 - 25 juli.
Med eget nummer på "Allsang på Grensen"!
Publisert i
Nyheter
Merket under
fredag, 07 juni 2019 07:43
Villekulla Airlines.
Villlekulla Airlines med 2 fulle hus!
Publisert i
Nyheter
Merket under
søndag, 26 mai 2019 12:43
Kulåskalas - en kjempesuksess.
For en fest det ble!
Publisert i
Nyheter
Merket under
søndag, 05 mai 2019 14:47
Mamma Mia!
Ny musikkvideo fra Villekulla - ute nå.
Publisert i
Nyheter
Merket under
torsdag, 25 april 2019 09:11
Villekulla er så gøy at jeg leker at jeg er der, når jeg ikke er der.
Hva sier andre om Villekulla?
Publisert i
Nyheter
Merket under
torsdag, 25 april 2019 08:24
Reisen til Julestjernen - 2018
Publikumsrekord.
Etter 5 timers billettsalg var det solgt over 1800 billetter til "Reisen til julestjernen". Når forestillingen hadde teppefall var det 3442 som hadde sett julefortellingen. Villekulla satte ny rekord på Sarpsborg Scene. Aldri før hadde en forestilling solgt så mange billetter.
Publisert i
Oppsetninger
Merket under
fredag, 05 april 2019 07:52
Villekullastipendet 2013-2019
Ny utdeling mai 2019.
Publisert i
Nyheter
Merket under
torsdag, 04 april 2019 06:59
Villekulla Airlines.
Konsert av og med musikalspirer.
Publisert i
Nyheter
Merket under
lørdag, 23 mars 2019 20:30
AUDITION TIL GREASE
Vi søker gutter fra 15 år og oppover.
Publisert i
Nyheter
Merket under
Login
Joomlas feilsøkingskonsoll
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1782015458,
"last": 1782015458,
"now": 1782015458
},
"token": "TjfhOkqaWlpHgG1OIqpPGZ6O4PPmlgkJ"
},
"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
}
}
}
Tid
Minne
Tid: 36.07 ms / 36.07 ms Minne: 1.996 MB / 2.38 MB Application: afterLoad
Tid: 118.05 ms / 154.12 ms Minne: 5.124 MB / 7.51 MB Application: afterInitialise
Tid: 49.26 ms / 203.38 ms Minne: 1.623 MB / 9.13 MB Application: afterRoute
Tid: 0.69 ms / 204.07 ms Minne: 0.024 MB / 9.15 MB Application: beforeRenderComponent com_k2
Tid: 0.43 ms / 204.51 ms Minne: 0.027 MB / 9.18 MB Application: Before Access::preloadComponents (all components)
Tid: 2.81 ms / 207.32 ms Minne: 0.053 MB / 9.23 MB Application: After Access::preloadComponents (all components)
Tid: 0.06 ms / 207.38 ms Minne: -0.003 MB / 9.23 MB Application: Before Access::getAssetRules (id:1809 name:com_k2)
Tid: 0.99 ms / 208.37 ms Minne: 0.026 MB / 9.26 MB Application: After Access::getAssetRules (id:1809 name:com_k2)
Tid: 183.51 ms / 391.88 ms Minne: 3.840 MB / 13.10 MB Application: afterRenderComponent com_k2
Tid: 3.37 ms / 395.26 ms Minne: 0.098 MB / 13.19 MB Application: afterDispatch
Tid: 24.53 ms / 419.79 ms Minne: 0.311 MB / 13.51 MB Application: beforeRenderModule mod_login (Login)
Tid: 11.48 ms / 431.26 ms Minne: 0.346 MB / 13.85 MB Application: afterRenderModule mod_login (Login)
Tid: 0.27 ms / 431.54 ms Minne: 0.023 MB / 13.87 MB Application: beforeRenderModule mod_zentools2 (Banner - Backgrunn)
Tid: 11.16 ms / 442.69 ms Minne: 0.906 MB / 14.78 MB Application: afterRenderModule mod_zentools2 (Banner - Backgrunn)
Tid: 0.14 ms / 442.84 ms Minne: -0.058 MB / 14.72 MB Application: beforeRenderModule mod_custom (Footer)
Tid: 3.98 ms / 446.82 ms Minne: 0.021 MB / 14.74 MB Application: afterRenderModule mod_custom (Footer)
Tid: 0.07 ms / 446.89 ms Minne: -0.001 MB / 14.74 MB Application: beforeRenderModule mod_menu (Footer)
Tid: 5.80 ms / 452.69 ms Minne: 0.075 MB / 14.82 MB Application: afterRenderModule mod_menu (Footer)
Tid: 0.13 ms / 452.82 ms Minne: -0.003 MB / 14.81 MB Application: beforeRenderModule mod_menu (Main Menu)
Tid: 12.74 ms / 465.56 ms Minne: 0.072 MB / 14.88 MB Application: afterRenderModule mod_menu (Main Menu)
Tid: 0.12 ms / 465.69 ms Minne: -0.005 MB / 14.88 MB Application: beforeRenderModule mod_custom (Logo)
Tid: 0.74 ms / 466.42 ms Minne: 0.003 MB / 14.88 MB Application: afterRenderModule mod_custom (Logo)
Tid: 24.80 ms / 491.23 ms Minne: 0.473 MB / 15.36 MB Application: afterRender
Totalt antall database-spørringer: 80.60 ms
15,93 MB (16.707.520 Bytes)
50 spørring(er) logget 80.60 ms
- Spørringstid: 1.63 ms Spørreminne: 0.023 MB Minne før spørring: 4.154 MB Rader funnet: 0
SELECT `data`
FROM `cni5j_session`
WHERE `session_id` = X'6132633234316162646437646461356234376431613136363932363534653362'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 Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 1.19 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms executing 0.02 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # 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 - Spørringstid: 0.42 ms Etter siste spørring: 2.59 ms Spørreminne: 0.020 MB Minne før spørring: 4.249 MB Rader funnet: 0
SELECT `session_id`
FROM `cni5j_session`
WHERE `session_id` = X'6132633234316162646437646461356234376431613136363932363534653362'
LIMIT 1id 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 Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms executing 0.02 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # 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 - Spørringstid: 1.14 ms Etter siste spørring: 0.17 ms Spørreminne: 0.004 MB Minne før spørring: 4.254 MB
INSERT INTO `cni5j_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6132633234316162646437646461356234376431613136363932363534653362', 1, 1782015458, 0, '', 0)'EXPLAIN' er ikke mulig på spørringen: INSERT INTO `cni5j_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6132633234316162646437646461356234376431613136363932363534653362', 1, 1782015458, 0, '', 0)Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms update 0.22 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.65 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # 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 - Spørringstid: 2.32 ms Etter siste spørring: 4.82 ms Spørreminne: 0.040 MB Minne før spørring: 4.443 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` = 1id 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 Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 1.34 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.04 ms executing 0.51 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.01 ms # 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 - Spørringstid: 1.35 ms Etter siste spørring: 4.82 ms Spørreminne: 0.021 MB Minne før spørring: 4.705 MB Rader funnet: 4
SELECT id, rules
FROM `cni5j_viewlevels`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 Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.87 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.13 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # 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 - Spørringstid: 1.57 ms Etter siste spørring: 0.18 ms Spørreminne: 0.021 MB Minne før spørring: 4.716 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 = 9id 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 Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.05 ms executing 0.06 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # 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 - Spørringstid: 1.70 ms Etter siste spørring: 1.31 ms Spørreminne: 0.030 MB Minne før spørring: 4.785 MB Rader funnet: 95
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 orderingid 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 Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.08 ms preparing 0.07 ms executing 1.09 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.03 ms cleaning up 0.01 ms # 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 - Spørringstid: 1.53 ms Etter siste spørring: 52.14 ms Spørreminne: 0.023 MB Minne før spørring: 7.335 MB Rader funnet: 21
SELECT *
FROM cni5j_rsform_configid 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 Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.95 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.04 ms executing 0.17 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # 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 - Spørringstid: 3.06 ms Etter siste spørring: 6.20 ms Spørreminne: 0.048 MB Minne før spørring: 7.696 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.lftid 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 Status Duration starting 0.12 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.47 ms init 0.02 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.08 ms executing 0.98 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.04 ms cleaning up 0.01 ms # 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 - Spørringstid: 0.73 ms Etter siste spørring: 18.49 ms Spørreminne: 0.024 MB Minne før spørring: 8.452 MB Rader funnet: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `cni5j_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'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 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.05 ms init 0.02 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.03 ms executing 0.06 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.03 ms cleaning up 0.01 ms # 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 - Spørringstid: 1.30 ms Etter siste spørring: 0.29 ms Spørreminne: 0.006 MB Minne før spørring: 8.445 MB
UPDATE `cni5j_extensions`
SET `params` = '{\"mediaversion\":\"e39aaef9b8bcdcd05de84ca13a3806ef\"}'
WHERE `type` = 'library'
AND `element` = 'joomla''EXPLAIN' er ikke mulig på spørringen: UPDATE `cni5j_extensions` SET `params` = '{\"mediaversion\":\"e39aaef9b8bcdcd05de84ca13a3806ef\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.12 ms updating 0.16 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.66 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.01 ms # 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 - Spørringstid: 1.77 ms Etter siste spørring: 11.18 ms Spørreminne: 0.022 MB Minne før spørring: 8.817 MB Rader funnet: 1
SELECT *
FROM cni5j_languages
WHERE published=1
ORDER BY ordering ASCid 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 Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 1.19 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.04 ms executing 0.14 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.03 ms cleaning up 0.01 ms # 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 - Spørringstid: 1.90 ms Etter siste spørring: 4.47 ms Spørreminne: 0.027 MB Minne før spørring: 9.119 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 = 1id 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 Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.95 ms init 0.02 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.05 ms executing 0.35 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.03 ms cleaning up 0.01 ms # 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 - Spørringstid: 2.47 ms Etter siste spørring: 3.17 ms Spørreminne: 0.025 MB Minne før spørring: 9.185 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')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 Status Duration starting 0.12 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 1.08 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.15 ms preparing 0.03 ms executing 0.74 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.03 ms cleaning up 0.01 ms # 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 - Spørringstid: 4.47 ms Etter siste spørring: 27.71 ms Spørreminne: 0.029 MB Minne før spørring: 10.492 MB Rader funnet: 17
SHOW FULL COLUMNS
FROM `cni5j_users`'EXPLAIN' er ikke mulig på spørringen: SHOW FULL COLUMNS FROM `cni5j_users`Status Duration starting 0.13 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.48 ms init 0.02 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.17 ms preparing 0.06 ms Creating tmp table 0.09 ms executing 0.19 ms checking permissions 0.12 ms checking permissions 0.06 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.06 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.08 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.03 ms closing tables 0.06 ms freeing items 0.07 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 21 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 20 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 19 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41 18 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:328 17 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 16 Joomla\CMS\User\User::getTable() JROOT/libraries/src/User/User.php:877 15 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 14 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 13 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 12 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/views/itemlist/view.html.php:355 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.72 ms Etter siste spørring: 1.21 ms Spørreminne: 0.025 MB Minne før spørring: 10.538 MB Rader funnet: 1
SELECT *
FROM `cni5j_users`
WHERE `id` = 20id 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 Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.23 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.03 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.04 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 16 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 15 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 14 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 13 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 12 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/views/itemlist/view.html.php:355 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 1.53 ms Etter siste spørring: 12.29 ms Spørreminne: 0.025 MB Minne før spørring: 11.293 MB Rader funnet: 6
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` = 20id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref PRIMARY PRIMARY 4 const 6 100.00 Using index 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 villekul_db2.m.group_id 1 100.00 NULL Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.77 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 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.03 ms freeing items 0.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 17 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:112 16 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 15 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 14 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 13 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 12 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/views/itemlist/view.html.php:355 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 1.60 ms Etter siste spørring: 0.71 ms Spørreminne: 0.022 MB Minne før spørring: 11.299 MB Rader funnet: 1Duplikat-spørringer: #19
SELECT id, gender, description, image, url, `
group`, plugins
FROM cni5j_k2_users
WHERE userID=20id 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 Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 1.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.08 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/itemlist.php:492 12 K2ModelItemlist->getUserProfile() JROOT/components/com_k2/views/itemlist/view.html.php:363 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.55 ms Etter siste spørring: 1.02 ms Spørreminne: 0.023 MB Minne før spørring: 11.306 MB Rader funnet: 1Duplikat-spørringer: #18
SELECT id, gender, description, image, url, `
group`, plugins
FROM cni5j_k2_users
WHERE userID=20id 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 Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms executing 0.06 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1702 13 K2ModelItem->getUserProfile() JROOT/components/com_k2/helpers/utilities.php:46 12 K2HelperUtilities::getAvatar() JROOT/components/com_k2/views/itemlist/view.html.php:366 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 11.06 ms Etter siste spørring: 6.42 ms Spørreminne: 0.155 MB Minne før spørring: 11.382 MB Rader funnet: 10
/* Frontend / K2 / Items */ SELECT /*+ MAX_EXECUTION_TIME(60000) */ i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM cni5j_k2_items AS i
INNER JOIN cni5j_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1,5)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,5)
AND c.trash = 0
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-06-21 04:17:38')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-06-21 04:17:38')
AND i.created_by=20
AND i.created_by_alias=''
ORDER BY i.id DESC
LIMIT 130, 10'EXPLAIN' er ikke mulig på spørringen: /* Frontend / K2 / Items */ SELECT /*+ MAX_EXECUTION_TIME(60000) */ i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams FROM cni5j_k2_items AS i INNER JOIN cni5j_k2_categories AS c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1,5) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,5) AND c.trash = 0 AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-06-21 04:17:38') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-06-21 04:17:38') AND i.created_by=20 AND i.created_by_alias='' ORDER BY i.id DESC LIMIT 130, 10Status Duration starting 0.18 ms Executing hook on transaction 0.01 ms starting 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 2.59 ms init 0.02 ms System lock 0.01 ms optimizing 0.06 ms statistics 0.32 ms preparing 0.07 ms executing 7.50 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.04 ms freeing items 0.05 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:335 12 K2ModelItemlist->getData() JROOT/components/com_k2/views/itemlist/view.html.php:576 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 3.29 ms Etter siste spørring: 0.59 ms Spørreminne: 0.022 MB Minne før spørring: 11.506 MB Rader funnet: 1
/* Frontend / K2 / Items Count */ SELECT COUNT(*)
FROM cni5j_k2_items AS i
INNER JOIN cni5j_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1,5)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,5)
AND c.trash = 0
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-06-21 04:17:38')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-06-21 04:17:38')
AND i.created_by=20
AND i.created_by_alias='''EXPLAIN' er ikke mulig på spørringen: /* Frontend / K2 / Items Count */ SELECT COUNT(*) FROM cni5j_k2_items AS i INNER JOIN cni5j_k2_categories AS c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1,5) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,5) AND c.trash = 0 AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-06-21 04:17:38') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-06-21 04:17:38') AND i.created_by=20 AND i.created_by_alias=''Status Duration starting 0.15 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.06 ms statistics 0.21 ms preparing 0.07 ms executing 2.43 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.04 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:345 12 K2ModelItemlist->getData() JROOT/components/com_k2/views/itemlist/view.html.php:576 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 3.23 ms Etter siste spørring: 3.75 ms Spørreminne: 0.026 MB Minne før spørring: 11.687 MB Rader funnet: 14
SHOW FULL COLUMNS
FROM `cni5j_k2_categories`'EXPLAIN' er ikke mulig på spørringen: SHOW FULL COLUMNS FROM `cni5j_k2_categories`Status Duration starting 0.14 ms Executing hook on transaction 0.01 ms starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.37 ms init 0.02 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.18 ms preparing 0.07 ms Creating tmp table 0.14 ms executing 0.15 ms checking permissions 0.10 ms checking permissions 0.06 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.08 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.09 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 16 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 15 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 14 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_k2/tables/k2category.php:34 13 TableK2Category->__construct() JROOT/libraries/src/Table/Table.php:328 12 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_k2/views/itemlist/view.html.php:729 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.54 ms Etter siste spørring: 0.52 ms Spørreminne: 0.024 MB Minne før spørring: 11.727 MB Rader funnet: 1
SELECT *
FROM cni5j_k2_categories
WHERE id = '2'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 Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 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.08 ms preparing 0.02 ms executing 0.03 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:61 16 TableK2Category->load() JROOT/components/com_k2/models/item.php:65 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 2.23 ms Etter siste spørring: 1.53 ms Spørreminne: 0.024 MB Minne før spørring: 11.799 MB Rader funnet: 0
SELECT tag.*
FROM cni5j_k2_tags AS tag JOIN cni5j_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 167
ORDER BY xref.id ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xref NULL ref tagID,itemID itemID 4 const 1 100.00 NULL 1 SIMPLE tag NULL eq_ref PRIMARY,published PRIMARY 4 villekul_db2.xref.tagID 1 100.00 Using where Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.57 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.04 ms executing 0.04 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1222 16 K2ModelItem->getItemTags() JROOT/components/com_k2/models/item.php:111 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 1.67 ms Etter siste spørring: 1.62 ms Spørreminne: 0.024 MB Minne før spørring: 11.808 MB Rader funnet: 1
SELECT COUNT(*)
FROM cni5j_k2_comments
WHERE itemID=167
AND published=1id 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 Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 1.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.05 ms executing 0.04 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.03 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1489 16 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:227 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 4.95 ms Etter siste spørring: 11.40 ms Spørreminne: 0.026 MB Minne før spørring: 12.037 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.itemlist'
AND (fc.category_id IS NULL OR fc.category_id IN (2,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 ASCid 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 Status Duration starting 0.21 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.03 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.55 ms init 0.02 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.29 ms preparing 0.09 ms Creating tmp table 0.16 ms executing 0.11 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.03 ms closing tables 0.06 ms freeing items 0.05 ms cleaning up 0.01 ms # 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/itemlist/view.html.php:740 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.73 ms Etter siste spørring: 8.84 ms Spørreminne: 0.024 MB Minne før spørring: 12.479 MB Rader funnet: 0
SELECT tag.*
FROM cni5j_k2_tags AS tag JOIN cni5j_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 166
ORDER BY xref.id ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xref NULL ref tagID,itemID itemID 4 const 1 100.00 NULL 1 SIMPLE tag NULL eq_ref PRIMARY,published PRIMARY 4 villekul_db2.xref.tagID 1 100.00 Using where Status Duration starting 0.13 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.04 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1222 16 K2ModelItem->getItemTags() JROOT/components/com_k2/models/item.php:111 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.63 ms Etter siste spørring: 1.52 ms Spørreminne: 0.024 MB Minne før spørring: 12.488 MB Rader funnet: 1
SELECT COUNT(*)
FROM cni5j_k2_comments
WHERE itemID=166
AND published=1id 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 Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.04 ms executing 0.04 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1489 16 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:227 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.63 ms Etter siste spørring: 3.88 ms Spørreminne: 0.024 MB Minne før spørring: 12.532 MB Rader funnet: 0
SELECT tag.*
FROM cni5j_k2_tags AS tag JOIN cni5j_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 165
ORDER BY xref.id ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xref NULL ref tagID,itemID itemID 4 const 1 100.00 NULL 1 SIMPLE tag NULL eq_ref PRIMARY,published PRIMARY 4 villekul_db2.xref.tagID 1 100.00 Using where Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.04 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1222 16 K2ModelItem->getItemTags() JROOT/components/com_k2/models/item.php:111 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.64 ms Etter siste spørring: 1.44 ms Spørreminne: 0.024 MB Minne før spørring: 12.541 MB Rader funnet: 1
SELECT COUNT(*)
FROM cni5j_k2_comments
WHERE itemID=165
AND published=1id 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 Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.04 ms executing 0.03 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1489 16 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:227 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.64 ms Etter siste spørring: 3.20 ms Spørreminne: 0.024 MB Minne før spørring: 12.585 MB Rader funnet: 0
SELECT tag.*
FROM cni5j_k2_tags AS tag JOIN cni5j_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 164
ORDER BY xref.id ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xref NULL ref tagID,itemID itemID 4 const 1 100.00 NULL 1 SIMPLE tag NULL eq_ref PRIMARY,published PRIMARY 4 villekul_db2.xref.tagID 1 100.00 Using where Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.04 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1222 16 K2ModelItem->getItemTags() JROOT/components/com_k2/models/item.php:111 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.59 ms Etter siste spørring: 1.42 ms Spørreminne: 0.024 MB Minne før spørring: 12.593 MB Rader funnet: 1
SELECT COUNT(*)
FROM cni5j_k2_comments
WHERE itemID=164
AND published=1id 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 Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.04 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1489 16 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:227 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.70 ms Etter siste spørring: 3.17 ms Spørreminne: 0.025 MB Minne før spørring: 12.643 MB Rader funnet: 0
SELECT tag.*
FROM cni5j_k2_tags AS tag JOIN cni5j_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 163
ORDER BY xref.id ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xref NULL ref tagID,itemID itemID 4 const 1 100.00 NULL 1 SIMPLE tag NULL eq_ref PRIMARY,published PRIMARY 4 villekul_db2.xref.tagID 1 100.00 Using where Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.04 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1222 16 K2ModelItem->getItemTags() JROOT/components/com_k2/models/item.php:111 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.55 ms Etter siste spørring: 1.40 ms Spørreminne: 0.024 MB Minne før spørring: 12.654 MB Rader funnet: 1
SELECT COUNT(*)
FROM cni5j_k2_comments
WHERE itemID=163
AND published=1id 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 Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.04 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1489 16 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:227 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.66 ms Etter siste spørring: 3.61 ms Spørreminne: 0.024 MB Minne før spørring: 12.697 MB Rader funnet: 0
SELECT tag.*
FROM cni5j_k2_tags AS tag JOIN cni5j_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 162
ORDER BY xref.id ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xref NULL ref tagID,itemID itemID 4 const 1 100.00 NULL 1 SIMPLE tag NULL eq_ref PRIMARY,published PRIMARY 4 villekul_db2.xref.tagID 1 100.00 Using where Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.04 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.04 ms cleaning up 0.02 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1222 16 K2ModelItem->getItemTags() JROOT/components/com_k2/models/item.php:111 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.57 ms Etter siste spørring: 1.42 ms Spørreminne: 0.024 MB Minne før spørring: 12.706 MB Rader funnet: 1
SELECT COUNT(*)
FROM cni5j_k2_comments
WHERE itemID=162
AND published=1id 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 Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.04 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1489 16 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:227 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.53 ms Etter siste spørring: 2.34 ms Spørreminne: 0.024 MB Minne før spørring: 12.692 MB Rader funnet: 1
SELECT *
FROM cni5j_k2_categories
WHERE id = '5'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 Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.02 ms executing 0.03 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:61 16 TableK2Category->load() JROOT/components/com_k2/models/item.php:65 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.77 ms Etter siste spørring: 0.33 ms Spørreminne: 0.025 MB Minne før spørring: 12.708 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 parentid 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 Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.05 ms executing 0.13 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:881 18 K2ModelItemlist->getCategoriesTree() JROOT/components/com_k2/helpers/route.php:261 17 K2HelperRoute::findMenuItem() JROOT/components/com_k2/helpers/route.php:56 16 K2HelperRoute::getCategoryRoute() JROOT/components/com_k2/models/item.php:68 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.67 ms Etter siste spørring: 1.50 ms Spørreminne: 0.024 MB Minne før spørring: 12.779 MB Rader funnet: 0
SELECT tag.*
FROM cni5j_k2_tags AS tag JOIN cni5j_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 161
ORDER BY xref.id ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xref NULL ref tagID,itemID itemID 4 const 1 100.00 NULL 1 SIMPLE tag NULL eq_ref PRIMARY,published PRIMARY 4 villekul_db2.xref.tagID 1 100.00 Using where Status Duration starting 0.10 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.06 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.05 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1222 16 K2ModelItem->getItemTags() JROOT/components/com_k2/models/item.php:111 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.67 ms Etter siste spørring: 1.44 ms Spørreminne: 0.024 MB Minne før spørring: 12.787 MB Rader funnet: 1
SELECT COUNT(*)
FROM cni5j_k2_comments
WHERE itemID=161
AND published=1id 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 Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.04 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.03 ms cleaning up 0.04 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1489 16 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:227 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 1.57 ms Etter siste spørring: 2.27 ms Spørreminne: 0.025 MB Minne før spørring: 12.755 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.itemlist'
AND (fc.category_id IS NULL OR fc.category_id IN (5,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 ASCid 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 Status Duration starting 0.28 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 checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.02 ms System lock 0.04 ms optimizing 0.06 ms statistics 0.26 ms preparing 0.07 ms Creating tmp table 0.17 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.05 ms cleaning up 0.01 ms # 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/itemlist/view.html.php:740 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.75 ms Etter siste spørring: 1.70 ms Spørreminne: 0.024 MB Minne før spørring: 12.840 MB Rader funnet: 0
SELECT tag.*
FROM cni5j_k2_tags AS tag JOIN cni5j_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 160
ORDER BY xref.id ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xref NULL ref tagID,itemID itemID 4 const 1 100.00 NULL 1 SIMPLE tag NULL eq_ref PRIMARY,published PRIMARY 4 villekul_db2.xref.tagID 1 100.00 Using where Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.05 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1222 16 K2ModelItem->getItemTags() JROOT/components/com_k2/models/item.php:111 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.67 ms Etter siste spørring: 1.44 ms Spørreminne: 0.024 MB Minne før spørring: 12.849 MB Rader funnet: 1
SELECT COUNT(*)
FROM cni5j_k2_comments
WHERE itemID=160
AND published=1id 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 Status Duration starting 0.08 ms Executing hook on transaction 0.03 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.04 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1489 16 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:227 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.74 ms Etter siste spørring: 3.31 ms Spørreminne: 0.024 MB Minne før spørring: 12.892 MB Rader funnet: 0
SELECT tag.*
FROM cni5j_k2_tags AS tag JOIN cni5j_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 159
ORDER BY xref.id ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xref NULL ref tagID,itemID itemID 4 const 1 100.00 NULL 1 SIMPLE tag NULL eq_ref PRIMARY,published PRIMARY 4 villekul_db2.xref.tagID 1 100.00 Using where Status Duration starting 0.10 ms Executing hook on transaction 0.03 ms starting 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.05 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1222 16 K2ModelItem->getItemTags() JROOT/components/com_k2/models/item.php:111 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.63 ms Etter siste spørring: 1.65 ms Spørreminne: 0.024 MB Minne før spørring: 12.902 MB Rader funnet: 1
SELECT COUNT(*)
FROM cni5j_k2_comments
WHERE itemID=159
AND published=1id 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 Status Duration starting 0.08 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.02 ms statistics 0.10 ms preparing 0.04 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1489 16 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:227 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.74 ms Etter siste spørring: 4.96 ms Spørreminne: 0.024 MB Minne før spørring: 12.945 MB Rader funnet: 0
SELECT tag.*
FROM cni5j_k2_tags AS tag JOIN cni5j_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 158
ORDER BY xref.id ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE xref NULL ref tagID,itemID itemID 4 const 1 100.00 NULL 1 SIMPLE tag NULL eq_ref PRIMARY,published PRIMARY 4 villekul_db2.xref.tagID 1 100.00 Using where Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.05 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1222 16 K2ModelItem->getItemTags() JROOT/components/com_k2/models/item.php:111 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.65 ms Etter siste spørring: 1.42 ms Spørreminne: 0.024 MB Minne før spørring: 12.954 MB Rader funnet: 1
SELECT COUNT(*)
FROM cni5j_k2_comments
WHERE itemID=158
AND published=1id 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 Status Duration starting 0.10 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.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.04 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.03 ms cleaning up 0.01 ms # Oppkaller Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1489 16 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:227 15 K2ModelItem->prepareItem() Samme som oppkall i linjen nedenfor. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 0.77 ms Etter siste spørring: 2.24 ms Spørreminne: 0.022 MB Minne før spørring: 12.922 MB Rader funnet: 6
SELECT id
FROM cni5j_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1,5)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 Status Duration starting 0.11 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.01 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.04 ms executing 0.08 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.03 ms cleaning up 0.01 ms # 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/itemlist/view.html.php:788 11 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Spørringstid: 4.95 ms Etter siste spørring: 19.68 ms Spørreminne: 0.026 MB Minne før spørring: 13.577 MB Rader funnet: 7
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-06-21 04:17:38')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-21 04:17:38')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 433 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid 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 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 checking permissions 0.01 ms Opening tables 2.42 ms init 0.02 ms System lock 0.04 ms optimizing 0.07 ms statistics 0.19 ms preparing 0.10 ms executing 1.57 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.04 ms closing tables 0.07 ms freeing items 0.07 ms cleaning up 0.01 ms # 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 - Spørringstid: 1.44 ms Etter siste spørring: 38.10 ms Spørreminne: 0.026 MB Minne før spørring: 14.752 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 ASCid 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 Status Duration starting 0.25 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 checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.13 ms init 0.02 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.28 ms preparing 0.06 ms Creating tmp table 0.12 ms executing 0.10 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.04 ms closing tables 0.04 ms freeing items 0.05 ms cleaning up 0.01 ms # 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
28 spørre type(r) logget, sortert etter forekomster.
VELG tabeller:
10 × SELECT tag.*
FROM cni5j_k2_tags AS tag JOIN cni5j_k2_tags_xref AS xref
ON tag.id = xref.tagID10 × SELECT COUNT(*)
FROM cni5j_k2_comments2 × 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.id2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `cni5j_extensions`2 × SELECT *
FROM cni5j_k2_categories2 × SELECT id, gender, description, image, url, `
group`, plugins
FROM cni5j_k2_users1 × SELECT `data`
FROM `cni5j_session`1 × SELECT `g`.`id`,`g`.`title`
FROM `cni5j_usergroups` AS g
INNER JOIN `cni5j_user_usergroup_map` AS m
ON m.group_id = g.id1 × 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_id1 × SELECT id
FROM cni5j_k2_categories1 × SELECT id, name, parent
FROM cni5j_k2_categories1 × SELECT *
FROM `cni5j_users`1 × SELECT `session_id`
FROM `cni5j_session`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_id1 × SELECT *
FROM cni5j_languages1 × 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_id1 × SELECT *
FROM cni5j_rsform_confi1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM cni5j_extensions1 × SELECT b.id
FROM cni5j_usergroups AS a
LEFT JOIN cni5j_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `cni5j_viewlevels1 × 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
ANDRE tabeller:
1 × INSERT INTO `cni5j_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6132633234316162646437646461356234376431613136363932363534653362', 1, 1782015458, 0, '', 01 × UPDATE `cni5j_extensions`
SET `params` = '{\"mediaversion\":\"e39aaef9b8bcdcd05de84ca13a3806ef\"}'1 × SHOW FULL COLUMNS
FROM `cni5j_users1 × /* Frontend / K2 / Items */ SELECT /*+ MAX_EXECUTION_TIME(60000) */ i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM cni5j_k2_items AS i
INNER JOIN cni5j_k2_categories AS c
ON c.id = i.catid1 × /* Frontend / K2 / Items Count */ SELECT COUNT(*)
FROM cni5j_k2_items AS i
INNER JOIN cni5j_k2_categories AS c
ON c.id = i.catid1 × SHOW FULL COLUMNS
FROM `cni5j_k2_categories