Malin Schavenius
torsdag, 16 november 2023 10:35
JULEworkshop.
Påmeldingen har startet!
Publisert i
Nyheter
Merket under
onsdag, 25 oktober 2023 12:45
ÅPEN Audition (10-17 år)
Til Villekullas barne og ungdomspartier.
Publisert i
Nyheter
Merket under
lørdag, 14 oktober 2023 13:30
Nærmere en halv million!
Ny musikkvideo!
Publisert i
Nyheter
Merket under
fredag, 01 september 2023 08:51
Billettsalget til SOUND OF MUSIC er åpnet.
Sound of Music
Publisert i
Nyheter
Merket under
tirsdag, 29 august 2023 11:59
I Ulrikkes fotspor.
Anna og Matilde skal spille "Maria" i "Sound of music.
Publisert i
Nyheter
Merket under
torsdag, 17 august 2023 13:41
Tv-serier og nasjonale produksjoner.
Villekullakids ute i verden.
Publisert i
Nyheter
Merket under
torsdag, 20 april 2023 11:19
Nye Villekullajakker.
torsdag, 13 april 2023 11:42
Sommerworkshop.
Påmeldingen har startet!
Publisert i
Nyheter
Merket under
fredag, 31 mars 2023 07:33
Villekullastipendet 2023
10 års-jubileum og 2 vinnere.
Publisert i
Nyheter
Merket under
Login
Joomlas feilsøkingskonsoll
{
"__default": {
"session": {
"counter": 2,
"timer": {
"start": 1782018132,
"last": 1782018132,
"now": 1782018133
},
"token": "OOMtEblu1Ut8YTynNGWlmXV5Luenbl6x"
},
"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: 35.08 ms / 35.08 ms Minne: 1.996 MB / 2.38 MB Application: afterLoad
Tid: 104.57 ms / 139.65 ms Minne: 5.105 MB / 7.49 MB Application: afterInitialise
Tid: 42.70 ms / 182.35 ms Minne: 1.623 MB / 9.11 MB Application: afterRoute
Tid: 0.63 ms / 182.98 ms Minne: 0.024 MB / 9.14 MB Application: beforeRenderComponent com_k2
Tid: 0.41 ms / 183.39 ms Minne: 0.027 MB / 9.16 MB Application: Before Access::preloadComponents (all components)
Tid: 1.66 ms / 185.05 ms Minne: 0.054 MB / 9.22 MB Application: After Access::preloadComponents (all components)
Tid: 0.09 ms / 185.14 ms Minne: -0.005 MB / 9.21 MB Application: Before Access::getAssetRules (id:1809 name:com_k2)
Tid: 0.96 ms / 186.10 ms Minne: 0.026 MB / 9.24 MB Application: After Access::getAssetRules (id:1809 name:com_k2)
Tid: 131.42 ms / 317.52 ms Minne: 3.793 MB / 13.03 MB Application: afterRenderComponent com_k2
Tid: 2.74 ms / 320.26 ms Minne: 0.106 MB / 13.14 MB Application: afterDispatch
Tid: 17.88 ms / 338.14 ms Minne: 0.311 MB / 13.45 MB Application: beforeRenderModule mod_login (Login)
Tid: 8.46 ms / 346.60 ms Minne: 0.332 MB / 13.78 MB Application: afterRenderModule mod_login (Login)
Tid: 0.25 ms / 346.84 ms Minne: 0.023 MB / 13.80 MB Application: beforeRenderModule mod_zentools2 (Banner - Backgrunn)
Tid: 8.48 ms / 355.32 ms Minne: 0.906 MB / 14.71 MB Application: afterRenderModule mod_zentools2 (Banner - Backgrunn)
Tid: 0.13 ms / 355.45 ms Minne: -0.058 MB / 14.65 MB Application: beforeRenderModule mod_custom (Footer)
Tid: 3.25 ms / 358.70 ms Minne: 0.021 MB / 14.67 MB Application: afterRenderModule mod_custom (Footer)
Tid: 0.06 ms / 358.76 ms Minne: -0.001 MB / 14.67 MB Application: beforeRenderModule mod_menu (Footer)
Tid: 4.61 ms / 363.37 ms Minne: 0.075 MB / 14.75 MB Application: afterRenderModule mod_menu (Footer)
Tid: 0.12 ms / 363.49 ms Minne: -0.003 MB / 14.74 MB Application: beforeRenderModule mod_menu (Main Menu)
Tid: 11.83 ms / 375.31 ms Minne: 0.072 MB / 14.81 MB Application: afterRenderModule mod_menu (Main Menu)
Tid: 0.13 ms / 375.45 ms Minne: -0.005 MB / 14.81 MB Application: beforeRenderModule mod_custom (Logo)
Tid: 0.64 ms / 376.08 ms Minne: 0.003 MB / 14.81 MB Application: afterRenderModule mod_custom (Logo)
Tid: 18.43 ms / 394.51 ms Minne: 0.473 MB / 15.29 MB Application: afterRender
Totalt antall database-spørringer: 45.78 ms
15,81 MB (16.573.520 Bytes)
45 spørring(er) logget 45.78 ms
- Spørringstid: 0.57 ms Spørreminne: 0.023 MB Minne før spørring: 4.155 MB Rader funnet: 1
SELECT `data`
FROM `cni5j_session`
WHERE `session_id` = X'3965366132653134646638336532393537343335343130373137326161613963'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.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.02 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 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: 1.02 ms Etter siste spørring: 6.30 ms Spørreminne: 0.040 MB Minne før spørring: 4.426 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.09 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.12 ms preparing 0.04 ms executing 0.45 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 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: 0.45 ms Etter siste spørring: 4.35 ms Spørreminne: 0.021 MB Minne før spørring: 4.687 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.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.06 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 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: 0.59 ms Etter siste spørring: 0.15 ms Spørreminne: 0.021 MB Minne før spørring: 4.699 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 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.15 ms preparing 0.04 ms executing 0.05 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.47 ms Etter siste spørring: 1.24 ms Spørreminne: 0.030 MB Minne før spørring: 4.768 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.05 ms executing 0.90 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 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: 0.69 ms Etter siste spørring: 50.87 ms Spørreminne: 0.023 MB Minne før spørring: 7.318 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.12 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.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.18 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: 1.45 ms Etter siste spørring: 6.16 ms Spørreminne: 0.048 MB Minne før spørring: 7.678 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.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.10 ms init 0.01 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.06 ms executing 0.71 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.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: 2.32 ms Etter siste spørring: 17.99 ms Spørreminne: 0.024 MB Minne før spørring: 8.434 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.09 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.02 ms statistics 1.81 ms preparing 0.03 ms executing 0.07 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.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.44 ms Etter siste spørring: 0.29 ms Spørreminne: 0.006 MB Minne før spørring: 8.428 MB
UPDATE `cni5j_extensions`
SET `params` = '{\"mediaversion\":\"b0dfc0e8987fb8feed4c18d8a3538bd3\"}'
WHERE `type` = 'library'
AND `element` = 'joomla''EXPLAIN' er ikke mulig på spørringen: UPDATE `cni5j_extensions` SET `params` = '{\"mediaversion\":\"b0dfc0e8987fb8feed4c18d8a3538bd3\"}' 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.15 ms updating 0.18 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.76 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: 0.55 ms Etter siste spørring: 7.57 ms Spørreminne: 0.022 MB Minne før spørring: 8.800 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.07 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.03 ms optimizing 0.02 ms statistics 0.03 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.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: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: 0.86 ms Etter siste spørring: 4.30 ms Spørreminne: 0.027 MB Minne før spørring: 9.101 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.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.05 ms executing 0.21 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: 1.32 ms Etter siste spørring: 3.03 ms Spørreminne: 0.025 MB Minne før spørring: 9.168 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.11 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.09 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.21 ms preparing 0.04 ms executing 0.54 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.02 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: 3.57 ms Etter siste spørring: 27.08 ms Spørreminne: 0.029 MB Minne før spørring: 10.475 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.12 ms Executing hook on transaction 0.01 ms starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.55 ms init 0.02 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.17 ms preparing 0.09 ms Creating tmp table 0.08 ms executing 0.15 ms checking permissions 0.11 ms checking permissions 0.05 ms checking permissions 0.06 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.05 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.08 ms checking permissions 0.04 ms checking permissions 0.11 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.05 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.52 ms Etter siste spørring: 1.15 ms Spørreminne: 0.025 MB Minne før spørring: 10.521 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.05 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.03 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/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: 0.64 ms Etter siste spørring: 4.87 ms Spørreminne: 0.025 MB Minne før spørring: 11.274 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.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 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.01 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: 0.48 ms Etter siste spørring: 0.20 ms Spørreminne: 0.022 MB Minne før spørring: 11.279 MB Rader funnet: 1Duplikat-spørringer: #17
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.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.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.05 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 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.56 ms Etter siste spørring: 0.28 ms Spørreminne: 0.023 MB Minne før spørring: 11.289 MB Rader funnet: 1Duplikat-spørringer: #16
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.07 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.09 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: 4.70 ms Etter siste spørring: 3.57 ms Spørreminne: 0.140 MB Minne før spørring: 11.364 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 05:02:13')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-06-21 05:02:13')
AND i.created_by=20
AND i.created_by_alias=''
ORDER BY i.id DESC
LIMIT 40, 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 05:02:13') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-06-21 05:02:13') AND i.created_by=20 AND i.created_by_alias='' ORDER BY i.id DESC LIMIT 40, 10Status Duration starting 0.15 ms Executing hook on transaction 0.01 ms starting 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.70 ms init 0.02 ms System lock 0.01 ms optimizing 0.06 ms statistics 0.24 ms preparing 0.06 ms executing 2.17 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.01 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: 2.28 ms Etter siste spørring: 0.18 ms Spørreminne: 0.022 MB Minne før spørring: 11.487 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 05:02:13')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-06-21 05:02:13')
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 05:02:13') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-06-21 05:02:13') AND i.created_by=20 AND i.created_by_alias=''Status Duration starting 0.12 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.02 ms System lock 0.01 ms optimizing 0.06 ms statistics 0.23 ms preparing 0.07 ms executing 1.53 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 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: 2.81 ms Etter siste spørring: 2.79 ms Spørreminne: 0.026 MB Minne før spørring: 11.669 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.08 ms Executing hook on transaction 0.01 ms starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.15 ms init 0.02 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.16 ms preparing 0.05 ms Creating tmp table 0.07 ms executing 0.12 ms checking permissions 0.11 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.02 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.03 ms checking permissions 0.03 ms checking permissions 0.05 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.09 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.05 ms freeing items 0.06 ms cleaning up 0.02 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.56 ms Etter siste spørring: 0.34 ms Spørreminne: 0.024 MB Minne før spørring: 11.708 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.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.06 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.61 ms Etter siste spørring: 1.19 ms Spørreminne: 0.024 MB Minne før spørring: 11.780 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 = 271
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.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.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.31 ms Spørreminne: 0.024 MB Minne før spørring: 11.789 MB Rader funnet: 1
SELECT COUNT(*)
FROM cni5j_k2_comments
WHERE itemID=271
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.09 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.05 ms executing 0.04 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.03 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: 1.23 ms Etter siste spørring: 8.19 ms Spørreminne: 0.026 MB Minne før spørring: 12.018 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.20 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.15 ms init 0.01 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.25 ms preparing 0.06 ms Creating tmp table 0.10 ms executing 0.11 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 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.61 ms Etter siste spørring: 7.06 ms Spørreminne: 0.024 MB Minne før spørring: 12.460 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 = 270
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.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.07 ms executing 0.05 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 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.50 ms Etter siste spørring: 1.28 ms Spørreminne: 0.024 MB Minne før spørring: 12.469 MB Rader funnet: 1
SELECT COUNT(*)
FROM cni5j_k2_comments
WHERE itemID=270
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.07 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.09 ms preparing 0.04 ms executing 0.03 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 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.62 ms Etter siste spørring: 2.94 ms Spørreminne: 0.024 MB Minne før spørring: 12.512 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 = 269
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.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.04 ms executing 0.05 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 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.61 ms Etter siste spørring: 1.33 ms Spørreminne: 0.024 MB Minne før spørring: 12.521 MB Rader funnet: 1
SELECT COUNT(*)
FROM cni5j_k2_comments
WHERE itemID=269
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.12 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.09 ms preparing 0.03 ms executing 0.03 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 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.58 ms Etter siste spørring: 2.79 ms Spørreminne: 0.024 MB Minne før spørring: 12.565 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 = 268
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.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.04 ms executing 0.03 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 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.58 ms Etter siste spørring: 1.34 ms Spørreminne: 0.024 MB Minne før spørring: 12.574 MB Rader funnet: 1
SELECT COUNT(*)
FROM cni5j_k2_comments
WHERE itemID=268
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.02 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms executing 0.03 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.04 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.62 ms Etter siste spørring: 2.78 ms Spørreminne: 0.024 MB Minne før spørring: 12.618 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 = 267
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.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.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.04 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 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.31 ms Spørreminne: 0.024 MB Minne før spørring: 12.627 MB Rader funnet: 1
SELECT COUNT(*)
FROM cni5j_k2_comments
WHERE itemID=267
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.07 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.12 ms preparing 0.03 ms executing 0.03 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.05 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.68 ms Etter siste spørring: 2.77 ms Spørreminne: 0.025 MB Minne før spørring: 12.677 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 = 266
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.08 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.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.02 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.03 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.56 ms Etter siste spørring: 1.42 ms Spørreminne: 0.024 MB Minne før spørring: 12.687 MB Rader funnet: 1
SELECT COUNT(*)
FROM cni5j_k2_comments
WHERE itemID=266
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.12 ms preparing 0.03 ms executing 0.03 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 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.60 ms Etter siste spørring: 2.80 ms Spørreminne: 0.024 MB Minne før spørring: 12.731 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 = 265
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.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.04 ms executing 0.03 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 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.37 ms Spørreminne: 0.024 MB Minne før spørring: 12.739 MB Rader funnet: 1
SELECT COUNT(*)
FROM cni5j_k2_comments
WHERE itemID=265
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.09 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.09 ms preparing 0.03 ms executing 0.03 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 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.60 ms Etter siste spørring: 2.86 ms Spørreminne: 0.024 MB Minne før spørring: 12.784 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 = 264
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.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms Opening tables 0.05 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.01 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.26 ms Spørreminne: 0.024 MB Minne før spørring: 12.793 MB Rader funnet: 1
SELECT COUNT(*)
FROM cni5j_k2_comments
WHERE itemID=264
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.09 ms preparing 0.03 ms executing 0.03 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.04 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.57 ms Etter siste spørring: 2.93 ms Spørreminne: 0.024 MB Minne før spørring: 12.836 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 = 263
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.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.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.04 ms executing 0.03 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 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.60 ms Etter siste spørring: 1.26 ms Spørreminne: 0.024 MB Minne før spørring: 12.846 MB Rader funnet: 1
SELECT COUNT(*)
FROM cni5j_k2_comments
WHERE itemID=263
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.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.03 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms executing 0.03 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.04 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: 2.98 ms Spørreminne: 0.024 MB Minne før spørring: 12.889 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 = 262
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.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.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.04 ms executing 0.03 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.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.60 ms Etter siste spørring: 1.32 ms Spørreminne: 0.024 MB Minne før spørring: 12.898 MB Rader funnet: 1
SELECT COUNT(*)
FROM cni5j_k2_comments
WHERE itemID=262
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.07 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.12 ms preparing 0.03 ms executing 0.03 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 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.67 ms Etter siste spørring: 1.90 ms Spørreminne: 0.022 MB Minne før spørring: 12.866 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.09 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.12 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.01 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: 1.85 ms Etter siste spørring: 16.09 ms Spørreminne: 0.026 MB Minne før spørring: 13.521 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 05:02:13')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-21 05:02:13')
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.18 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.13 ms init 0.01 ms System lock 0.02 ms optimizing 0.06 ms statistics 0.16 ms preparing 0.08 ms executing 0.89 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.05 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.29 ms Etter siste spørring: 29.18 ms Spørreminne: 0.026 MB Minne før spørring: 14.681 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.20 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.03 ms Opening tables 0.14 ms init 0.01 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.23 ms preparing 0.06 ms Creating tmp table 0.09 ms executing 0.10 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.08 ms freeing items 0.04 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
25 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 `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `cni5j_extensions`2 × SELECT id, gender, description, image, url, `
group`, plugins
FROM cni5j_k2_users1 × SELECT `data`
FROM `cni5j_session`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM cni5j_modules AS m
LEFT JOIN cni5j_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN cni5j_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT id
FROM cni5j_k2_categories1 × 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.id1 × SELECT *
FROM cni5j_k2_categories1 × 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 *
FROM `cni5j_users`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 × UPDATE `cni5j_extensions`
SET `params` = '{\"mediaversion\":\"b0dfc0e8987fb8feed4c18d8a3538bd3\"}'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
