Joomla! Foutopsporingsconsole
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1674938523,
"last": 1674938523,
"now": 1674938523
},
"token": "gBR46ORrFrKtlxf6Hax3NdDZxvl3Aq69"
},
"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
}
}
}
Tijd
Geheugen
Tijd: 3.74 ms / 3.74 ms Geheugen: 0.409 MB / 0.74 MB Application: afterLoad
Tijd: 61.76 ms / 65.49 ms Geheugen: 0.782 MB / 1.52 MB Application: afterInitialise
Tijd: 29.38 ms / 94.88 ms Geheugen: 0.276 MB / 1.80 MB Application: afterRoute
Tijd: 27.69 ms / 122.57 ms Geheugen: 0.051 MB / 1.85 MB Application: beforeRenderComponent com_weblinks
Tijd: 1.51 ms / 124.07 ms Geheugen: 0.128 MB / 1.98 MB Application: Before Access::preloadComponents (all components)
Tijd: 18.68 ms / 142.75 ms Geheugen: 0.054 MB / 2.03 MB Application: After Access::preloadComponents (all components)
Tijd: 0.06 ms / 142.81 ms Geheugen: 0.000 MB / 2.03 MB Application: Before Access::getAssetRules (id:25 name:com_weblinks)
Tijd: 0.21 ms / 143.02 ms Geheugen: 0.008 MB / 2.04 MB Application: After Access::getAssetRules (id:25 name:com_weblinks)
Tijd: 97.16 ms / 240.18 ms Geheugen: 0.325 MB / 2.36 MB Application: Before Access::preloadPermissions (com_weblinks)
Tijd: 1.18 ms / 241.35 ms Geheugen: 0.022 MB / 2.38 MB Application: After Access::preloadPermissions (com_weblinks)
Tijd: 0.02 ms / 241.37 ms Geheugen: 0.000 MB / 2.38 MB Application: Before Access::getAssetRules (id:61 name:com_weblinks.category.13)
Tijd: 0.05 ms / 241.42 ms Geheugen: 0.007 MB / 2.39 MB Application: After Access::getAssetRules (id:61 name:com_weblinks.category.13)
Tijd: 0.77 ms / 242.19 ms Geheugen: 0.000 MB / 2.33 MB Application: afterRenderComponent com_weblinks
Tijd: 0.81 ms / 243.00 ms Geheugen: 0.012 MB / 2.34 MB Application: afterDispatch
Tijd: 26.93 ms / 269.93 ms Geheugen: 0.048 MB / 2.39 MB Application: beforeRenderModule mod_menu (Hoofdmenu)
Tijd: 1.73 ms / 271.66 ms Geheugen: 0.078 MB / 2.47 MB Application: afterRenderModule mod_menu (Hoofdmenu)
Tijd: 0.52 ms / 272.18 ms Geheugen: 0.024 MB / 2.49 MB Application: afterRender
Totaal aantal database zoekopdrachten: 228.69 ms
2,85 MB (2.991.360 Bytes)
25 zoekopdrachten gelogd 228.69 ms
- Tijd zoekopdracht: 11.82 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 1.024 MB Regels teruggegeven: 0
SELECT `data`
FROM `kemnz_session`
WHERE `session_id` = '7a7b92bac24976075a7cbe22e5201e8c'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE kemnz_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.17 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 10.93 ms Preparing 0.11 ms Executing 0.04 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.03 ms closing tables 0.08 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.08 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Zelfde als de call in onderstaande regel. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:765 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:351 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tijd zoekopdracht: 0.68 ms Na de laatste zoekopdracht: 0.44 ms Zoekopdracht geheugen: 0.020 MB geheugen voor zoekopdracht: 1.038 MB Regels teruggegeven: 0
SELECT `session_id`
FROM `kemnz_session`
WHERE `session_id` = '7a7b92bac24976075a7cbe22e5201e8c'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE kemnz_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.12 ms checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.02 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.07 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller Bestand en regelnummer 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:767 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:351 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tijd zoekopdracht: 1.59 ms Na de laatste zoekopdracht: 0.08 ms Zoekopdracht geheugen: 0.004 MB geheugen voor zoekopdracht: 1.043 MB
INSERT INTO `kemnz_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('7a7b92bac24976075a7cbe22e5201e8c', 1, 1674938523, 0, '', 0)VERKLAREN niet mogelijk voor zoekopdracht: INSERT INTO `kemnz_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('7a7b92bac24976075a7cbe22e5201e8c', 1, 1674938523, 0, '', 0)Status Duration Starting 0.08 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init for update 0.03 ms Update 0.70 ms End of update loop 0.04 ms Query end 0.01 ms Commit 0.39 ms closing tables 0.04 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.08 ms Updating status 0.05 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:767 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:351 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tijd zoekopdracht: 1.85 ms Na de laatste zoekopdracht: 0.47 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 1.074 MB Regels teruggegeven: 36
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `kemnz_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE kemnz_extensions ref extension extension 82 const 36 Using index condition; Using where Status Duration Starting 0.13 ms checking permissions 0.03 ms Opening tables 0.05 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.03 ms init 0.04 ms Optimizing 0.05 ms Statistics 0.44 ms Preparing 0.07 ms Executing 0.02 ms Sending data 0.63 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.07 ms Updating status 0.05 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Zelfde als de call in onderstaande regel. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 12.58 ms Na de laatste zoekopdracht: 0.58 ms Zoekopdracht geheugen: 0.021 MB geheugen voor zoekopdracht: 1.100 MB Regels teruggegeven: 4
SELECT id, rules
FROM `kemnz_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE kemnz_viewlevels ALL NULL INDEX KEY ONTBREEKT NULL NULL 4 Status Duration Starting 0.13 ms checking permissions 0.03 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.02 ms Sending data 11.70 ms End of update loop 0.12 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.04 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.11 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1500 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 12.85 ms Na de laatste zoekopdracht: 0.15 ms Zoekopdracht geheugen: 0.021 MB geheugen voor zoekopdracht: 1.112 MB Regels teruggegeven: 2
SELECT b.id
FROM kemnz_usergroups AS a
LEFT JOIN kemnz_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 Using where; Using index Status Duration Starting 0.16 ms checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.07 ms System lock 0.02 ms table lock 0.03 ms init 0.05 ms Optimizing 0.05 ms Statistics 11.72 ms Preparing 0.11 ms Unlocking tables 0.03 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.07 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.04 ms Starting cleanup 0.02 ms Freeing items 0.09 ms Updating status 0.04 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 1.74 ms Na de laatste zoekopdracht: 0.35 ms Zoekopdracht geheugen: 0.030 MB geheugen voor zoekopdracht: 1.133 MB Regels teruggegeven: 79
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM kemnz_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE kemnz_extensions ALL extension INDEX KEY ONTBREEKT NULL NULL 200 Using where; Gebruikt bestandssortering Status Duration Starting 0.20 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.06 ms Statistics 0.07 ms Preparing 0.03 ms Sorting result 0.04 ms Executing 0.02 ms Sending data 0.02 ms Creating sort index 0.78 ms End of update loop 0.04 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.03 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.07 ms Updating status 0.04 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Zelfde als de call in onderstaande regel. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:359 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 11.88 ms Na de laatste zoekopdracht: 12.72 ms Zoekopdracht geheugen: 0.048 MB geheugen voor zoekopdracht: 1.550 MB Regels teruggegeven: 22
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 kemnz_menu AS m
LEFT JOIN kemnz_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 type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 22 Using index condition; Using where; Gebruikt bestandssortering 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 deb41643n2_joomla.m.component_id 1 Using where Status Duration Starting 0.21 ms checking permissions 0.02 ms Opening tables 0.08 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.03 ms Statistics 10.51 ms Preparing 0.12 ms Sorting result 0.05 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 0.41 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Zelfde als de call in onderstaande regel. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:382 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:64 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:498 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:1080 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 12.13 ms Na de laatste zoekopdracht: 4.35 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 1.765 MB Regels teruggegeven: 6
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `kemnz_categories` AS `c`
WHERE (c.extension='com_weblinks' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ALL cat_idx,idx_access INDEX KEY ONTBREEKT NULL NULL 16 Using where; Gebruikt bestandssortering Status Duration Starting 0.17 ms checking permissions 0.02 ms Opening tables 0.08 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.07 ms Optimizing 0.04 ms Statistics 10.99 ms Preparing 0.12 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.04 ms Creating sort index 0.19 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 11 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 10 Joomla\CMS\Categories\Categories->get() JROOT/components/com_weblinks/router.php:208 9 WeblinksRouter->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1081 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 0.84 ms Na de laatste zoekopdracht: 0.59 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 1.818 MB Regels teruggegeven: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `kemnz_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE kemnz_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.12 ms checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.13 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.05 ms Starting cleanup 0.04 ms Freeing items 0.06 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Zelfde als de call in onderstaande regel. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1129 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 0.96 ms Na de laatste zoekopdracht: 0.12 ms Zoekopdracht geheugen: 0.005 MB geheugen voor zoekopdracht: 1.809 MB
UPDATE `kemnz_extensions`
SET `params` = '{\"mediaversion\":\"b920ec546677e35bac1389e25cd0cb97\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'VERKLAREN niet mogelijk voor zoekopdracht: UPDATE `kemnz_extensions` SET `params` = '{\"mediaversion\":\"b920ec546677e35bac1389e25cd0cb97\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.09 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init for update 0.06 ms Updating 0.10 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.41 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.05 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1129 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 12.16 ms Na de laatste zoekopdracht: 0.35 ms Zoekopdracht geheugen: 0.019 MB geheugen voor zoekopdracht: 1.830 MB Regels teruggegeven: 2
SELECT *
FROM kemnz_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE kemnz_languages ALL NULL INDEX KEY ONTBREEKT NULL NULL 2 Using where; Gebruikt bestandssortering Status Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.04 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.04 ms Creating sort index 11.32 ms End of update loop 0.12 ms Query end 0.02 ms Commit 0.03 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 12.44 ms Na de laatste zoekopdracht: 0.40 ms Zoekopdracht geheugen: 0.019 MB geheugen voor zoekopdracht: 1.842 MB Regels teruggegeven: 4
SELECT id, home, template, s.params
FROM kemnz_template_styles as s
LEFT JOIN kemnz_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 type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template INDEX KEY ONTBREEKT NULL NULL 6 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 deb41643n2_joomla.s.template,const 1 Using index condition; Using where Status Duration Starting 0.10 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.04 ms Executing 0.02 ms Sending data 11.57 ms End of update loop 0.13 ms Query end 0.02 ms Commit 0.03 ms closing tables 0.03 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller Bestand en regelnummer 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 18.45 ms Na de laatste zoekopdracht: 1.84 ms Zoekopdracht geheugen: 0.028 MB geheugen voor zoekopdracht: 1.982 MB Regels teruggegeven: 36
SELECT `id`,`name`,`rules`,`parent_id`
FROM `kemnz_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_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE kemnz_assets ALL idx_asset_name INDEX KEY ONTBREEKT NULL NULL 100 Using where Status Duration Starting 0.20 ms checking permissions 0.03 ms Opening tables 0.09 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.02 ms init 0.07 ms Optimizing 0.03 ms Statistics 0.17 ms Preparing 0.04 ms Executing 0.02 ms Sending data 17.27 ms End of update loop 0.11 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.09 ms Updating status 0.04 ms Reset for next command 0.03 ms # Caller Bestand en regelnummer 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 18 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_weblinks/models/category.php:258 13 WeblinksModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_weblinks/views/category/view.html.php:28 10 WeblinksViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_weblinks/controller.php:65 8 WeblinksController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_weblinks/weblinks.php:15 6 require_once JROOT/components/com_weblinks/weblinks.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 30.72 ms Na de laatste zoekopdracht: 0.62 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 2.046 MB Regels teruggegeven: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `kemnz_weblinks` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `kemnz_categories` AS `s`
INNER JOIN `kemnz_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_weblinks' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 13
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right INDEX KEY ONTBREEKT NULL NULL 16 Using where; Gebruikt bestandssortering 2 DEPENDENT SUBQUERY i ref idx_state,idx_catid idx_catid 4 deb41643n2_joomla.c.id 1 Using where Status Duration Starting 0.23 ms checking permissions 0.03 ms Opening tables 0.11 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.12 ms Optimizing 0.06 ms Statistics 0.28 ms Preparing 0.04 ms Unlocking tables 0.01 ms Preparing 0.03 ms Optimizing 0.03 ms Statistics 28.44 ms Preparing 0.16 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 0.15 ms Executing 0.02 ms Sending data 0.15 ms Executing 0.02 ms Sending data 0.26 ms End of update loop 0.04 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Removing tmp table 0.02 ms Freeing items 0.11 ms Updating status 0.04 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 15 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 14 Joomla\CMS\Categories\Categories->get() JROOT/components/com_weblinks/models/category.php:299 13 WeblinksModelCategory->getCategory() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:122 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_weblinks/views/category/view.html.php:28 10 WeblinksViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_weblinks/controller.php:65 8 WeblinksController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_weblinks/weblinks.php:15 6 require_once JROOT/components/com_weblinks/weblinks.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 12.72 ms Na de laatste zoekopdracht: 0.29 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 2.062 MB Regels teruggegeven: 2
SELECT a.*,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM `kemnz_weblinks` AS a
LEFT JOIN kemnz_categories AS c
ON c.id = a.catid
LEFT JOIN kemnz_users AS ua
ON ua.id = a.created_by
LEFT JOIN kemnz_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1,5)
AND a.catid = 13
AND c.access IN (1,1,5)
AND a.state = 1
AND a.state != -2
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-01-28 20:42:03')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-01-28 20:42:03')
ORDER BY ordering ASC
LIMIT 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a ref idx_access,idx_state,idx_catid idx_catid 4 const 2 Using where; Gebruikt bestandssortering 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 deb41643n2_joomla.a.created_by 1 Using where Status Duration Starting 0.21 ms checking permissions 0.03 ms Opening tables 0.12 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.09 ms Optimizing 0.05 ms Statistics 0.16 ms Preparing 0.02 ms Unlocking tables 0.03 ms Preparing 0.05 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 11.36 ms End of update loop 0.11 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.04 ms Starting cleanup 0.02 ms Freeing items 0.12 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 15 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 14 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_weblinks/models/category.php:81 13 WeblinksModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_weblinks/views/category/view.html.php:28 10 WeblinksViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_weblinks/controller.php:65 8 WeblinksController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_weblinks/weblinks.php:15 6 require_once JROOT/components/com_weblinks/weblinks.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 25.69 ms Na de laatste zoekopdracht: 0.42 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 2.085 MB Regels teruggegeven: 0
SELECT `m`.`tag_id`,`t`.*
FROM `kemnz_contentitem_tag_map` AS m
INNER JOIN `kemnz_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_weblinks.weblink'
AND `m`.`content_item_id` = 2
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type INDEX KEY ONTBREEKT NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 deb41643n2_joomla.m.tag_id 1 Using where Status Duration Starting 0.17 ms checking permissions 0.02 ms Opening tables 0.12 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.04 ms init 0.09 ms Optimizing 0.06 ms Statistics 12.34 ms Preparing 0.17 ms Executing 0.02 ms Sending data 12.16 ms End of update loop 0.12 ms Query end 0.02 ms Commit 0.03 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.04 ms Starting cleanup 0.02 ms Freeing items 0.11 ms Updating status 0.04 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 14 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_weblinks/models/category.php:95 13 WeblinksModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_weblinks/views/category/view.html.php:28 10 WeblinksViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_weblinks/controller.php:65 8 WeblinksController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_weblinks/weblinks.php:15 6 require_once JROOT/components/com_weblinks/weblinks.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 1.18 ms Na de laatste zoekopdracht: 0.17 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 2.095 MB Regels teruggegeven: 0
SELECT `m`.`tag_id`,`t`.*
FROM `kemnz_contentitem_tag_map` AS m
INNER JOIN `kemnz_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_weblinks.weblink'
AND `m`.`content_item_id` = 8
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type INDEX KEY ONTBREEKT NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 deb41643n2_joomla.m.tag_id 1 Using where Status Duration Starting 0.21 ms checking permissions 0.03 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.10 ms Optimizing 0.06 ms Statistics 0.20 ms Preparing 0.07 ms Executing 0.02 ms Sending data 0.08 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.08 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 14 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_weblinks/models/category.php:95 13 WeblinksModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_weblinks/views/category/view.html.php:28 10 WeblinksViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_weblinks/controller.php:65 8 WeblinksController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_weblinks/weblinks.php:15 6 require_once JROOT/components/com_weblinks/weblinks.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 1.12 ms Na de laatste zoekopdracht: 0.39 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 2.110 MB Regels teruggegeven: 1
SELECT COUNT(*)
FROM `kemnz_weblinks` AS a
LEFT JOIN kemnz_categories AS c
ON c.id = a.catid
LEFT JOIN kemnz_users AS ua
ON ua.id = a.created_by
LEFT JOIN kemnz_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1,5)
AND a.catid = 13
AND c.access IN (1,1,5)
AND a.state = 1
AND a.state != -2
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-01-28 20:42:03')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-01-28 20:42:03')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a ref idx_access,idx_state,idx_catid idx_catid 4 const 2 Using where Status Duration Starting 0.18 ms checking permissions 0.03 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.07 ms Statistics 0.16 ms Preparing 0.03 ms Unlocking tables 0.03 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.07 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.07 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 16 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340 15 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:282 14 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:232 13 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:145 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_weblinks/views/category/view.html.php:28 10 WeblinksViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_weblinks/controller.php:65 8 WeblinksController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_weblinks/weblinks.php:15 6 require_once JROOT/components/com_weblinks/weblinks.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 0.85 ms Na de laatste zoekopdracht: 0.25 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 2.118 MB Regels teruggegeven: 0
SELECT `m`.`tag_id`,`t`.*
FROM `kemnz_contentitem_tag_map` AS m
INNER JOIN `kemnz_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = '.category'
AND `m`.`content_item_id` = 13
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type INDEX KEY ONTBREEKT NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 deb41643n2_joomla.m.tag_id 1 Using where Status Duration Starting 0.12 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.05 ms Executing 0.02 ms Sending data 0.06 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.07 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/libraries/src/MVC/View/CategoryView.php:229 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_weblinks/views/category/view.html.php:28 10 WeblinksViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_weblinks/controller.php:65 8 WeblinksController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_weblinks/weblinks.php:15 6 require_once JROOT/components/com_weblinks/weblinks.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 14.40 ms Na de laatste zoekopdracht: 2.05 ms Zoekopdracht geheugen: 0.028 MB geheugen voor zoekopdracht: 2.196 MB Regels teruggegeven: 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 kemnz_fields AS a
LEFT JOIN `kemnz_languages` AS l
ON l.lang_code = a.language
LEFT JOIN kemnz_users AS uc
ON uc.id=a.checked_out
LEFT JOIN kemnz_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN kemnz_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN kemnz_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_weblinks.categories'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Gebruikt bestandssortering 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 deb41643n2_joomla.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 deb41643n2_joomla.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 deb41643n2_joomla.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 deb41643n2_joomla.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 deb41643n2_joomla.a.group_id 1 Using where Status Duration Starting 0.31 ms checking permissions 0.03 ms Opening tables 0.15 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.11 ms Optimizing 0.07 ms Statistics 12.18 ms Preparing 0.18 ms Creating tmp table 0.16 ms Sorting result 0.05 ms Executing 0.02 ms Sending data 0.45 ms Creating sort index 0.06 ms Removing tmp table 0.11 ms Creating sort index 0.04 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.04 ms Starting cleanup 0.02 ms Freeing items 0.09 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 24 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 23 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 22 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 21 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 20 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 19 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 18 JEventDispatcher->trigger() JROOT/layouts/joomla/content/category_default.php:25 17 include JROOT/layouts/joomla/content/category_default.php JROOT/libraries/src/Layout/FileLayout.php:125 16 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 15 Joomla\CMS\Layout\LayoutHelper::render() JROOT/components/com_weblinks/views/category/tmpl/default.php:14 14 include JROOT/components/com_weblinks/views/category/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:697 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_weblinks/views/category/view.html.php:51 10 WeblinksViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_weblinks/controller.php:65 8 WeblinksController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_weblinks/weblinks.php:15 6 require_once JROOT/components/com_weblinks/weblinks.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 1.88 ms Na de laatste zoekopdracht: 0.63 ms Zoekopdracht geheugen: 0.028 MB geheugen voor zoekopdracht: 2.291 MB Regels teruggegeven: 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 kemnz_fields AS a
LEFT JOIN `kemnz_languages` AS l
ON l.lang_code = a.language
LEFT JOIN kemnz_users AS uc
ON uc.id=a.checked_out
LEFT JOIN kemnz_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN kemnz_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN kemnz_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `kemnz_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_weblinks.categories'
AND (fc.category_id IS NULL OR fc.category_id IN (13,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 type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Gebruikt bestandssortering 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 deb41643n2_joomla.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 deb41643n2_joomla.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 deb41643n2_joomla.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 deb41643n2_joomla.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 deb41643n2_joomla.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 deb41643n2_joomla.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.27 ms checking permissions 0.04 ms Opening tables 0.09 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.10 ms Optimizing 0.08 ms Statistics 0.17 ms Preparing 0.08 ms Creating tmp table 0.08 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.36 ms Creating sort index 0.05 ms Removing tmp table 0.09 ms Creating sort index 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.03 ms Unlocking tables 0.04 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 26 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 25 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 24 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 23 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 22 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:397 21 PlgSystemFields->display() JROOT/plugins/system/fields/fields.php:317 20 PlgSystemFields->onContentAfterTitle() JROOT/libraries/joomla/event/event.php:70 19 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 18 JEventDispatcher->trigger() JROOT/layouts/joomla/content/category_default.php:28 17 include JROOT/layouts/joomla/content/category_default.php JROOT/libraries/src/Layout/FileLayout.php:125 16 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 15 Joomla\CMS\Layout\LayoutHelper::render() JROOT/components/com_weblinks/views/category/tmpl/default.php:14 14 include JROOT/components/com_weblinks/views/category/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:697 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_weblinks/views/category/view.html.php:51 10 WeblinksViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_weblinks/controller.php:65 8 WeblinksController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_weblinks/weblinks.php:15 6 require_once JROOT/components/com_weblinks/weblinks.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 1.81 ms Na de laatste zoekopdracht: 0.74 ms Zoekopdracht geheugen: 0.030 MB geheugen voor zoekopdracht: 2.325 MB Regels teruggegeven: 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 kemnz_fields AS a
LEFT JOIN `kemnz_languages` AS l
ON l.lang_code = a.language
LEFT JOIN kemnz_users AS uc
ON uc.id=a.checked_out
LEFT JOIN kemnz_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN kemnz_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN kemnz_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `kemnz_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_weblinks.category.title'
AND (fc.category_id IS NULL OR fc.category_id IN (13,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 type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Gebruikt bestandssortering 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 deb41643n2_joomla.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 deb41643n2_joomla.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 deb41643n2_joomla.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 deb41643n2_joomla.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 deb41643n2_joomla.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 deb41643n2_joomla.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.24 ms checking permissions 0.03 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.09 ms Optimizing 0.06 ms Statistics 0.14 ms Preparing 0.08 ms Creating tmp table 0.07 ms Sorting result 0.04 ms Executing 0.02 ms Sending data 0.38 ms Creating sort index 0.07 ms Removing tmp table 0.11 ms Creating sort index 0.04 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.07 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 30 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 29 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 28 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 27 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 26 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 25 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 24 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 23 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 22 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 21 JHtmlContent::prepare() Zelfde als de call in onderstaande regel. 20 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 19 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 18 Joomla\CMS\HTML\HTMLHelper::_() JROOT/layouts/joomla/content/category_default.php:57 17 include JROOT/layouts/joomla/content/category_default.php JROOT/libraries/src/Layout/FileLayout.php:125 16 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 15 Joomla\CMS\Layout\LayoutHelper::render() JROOT/components/com_weblinks/views/category/tmpl/default.php:14 14 include JROOT/components/com_weblinks/views/category/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:697 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_weblinks/views/category/view.html.php:51 10 WeblinksViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_weblinks/controller.php:65 8 WeblinksController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_weblinks/weblinks.php:15 6 require_once JROOT/components/com_weblinks/weblinks.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 1.04 ms Na de laatste zoekopdracht: 1.71 ms Zoekopdracht geheugen: 0.029 MB geheugen voor zoekopdracht: 2.366 MB Regels teruggegeven: 7
SELECT `id`,`name`,`rules`,`parent_id`
FROM `kemnz_assets`
WHERE `name` LIKE 'com_weblinks.%' OR `name` = 'com_weblinks' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE kemnz_assets ALL idx_asset_name,idx_parent_id INDEX KEY ONTBREEKT NULL NULL 100 Using where Status Duration Starting 0.12 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.03 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.24 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.18 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.07 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 24 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 23 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 22 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 21 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 20 Joomla\CMS\User\User->authorise() JROOT/components/com_weblinks/views/category/tmpl/default_items.php:20 19 include JROOT/components/com_weblinks/views/category/tmpl/default_items.php JROOT/libraries/src/MVC/View/HtmlView.php:697 18 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/layouts/joomla/content/category_default.php:79 17 include JROOT/layouts/joomla/content/category_default.php JROOT/libraries/src/Layout/FileLayout.php:125 16 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 15 Joomla\CMS\Layout\LayoutHelper::render() JROOT/components/com_weblinks/views/category/tmpl/default.php:14 14 include JROOT/components/com_weblinks/views/category/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:697 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_weblinks/views/category/view.html.php:51 10 WeblinksViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_weblinks/controller.php:65 8 WeblinksController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_weblinks/weblinks.php:15 6 require_once JROOT/components/com_weblinks/weblinks.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tijd zoekopdracht: 25.32 ms Na de laatste zoekopdracht: 2.29 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 2.383 MB Regels teruggegeven: 6
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM kemnz_modules AS m
LEFT JOIN kemnz_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN kemnz_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 <= '2023-01-28 20:42:03')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-01-28 20:42:03')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 479 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mm index PRIMARY PRIMARY 8 NULL 23 Using where; Using index; Using temporary; Gebruikt bestandssortering 1 SIMPLE m eq_ref PRIMARY,published,newsfeeds PRIMARY 4 deb41643n2_joomla.mm.moduleid 1 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 deb41643n2_joomla.m.module,const 1 Using index condition; Using where Status Duration Starting 0.14 ms checking permissions 0.03 ms Opening tables 0.07 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.07 ms Statistics 11.49 ms Preparing 0.17 ms Creating tmp table 0.05 ms Sorting result 0.05 ms Executing 0.02 ms Sending data 12.33 ms Creating sort index 0.21 ms Removing tmp table 0.18 ms Creating sort index 0.05 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.09 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() Zelfde als de call in onderstaande regel. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 12 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 11 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 10 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:581 9 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/casinotime/functions.php:4 8 require JROOT/templates/casinotime/functions.php JROOT/templates/casinotime/index.php:12 7 require JROOT/templates/casinotime/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1037 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
20 zoekopdrachttypes gelogd, gesorteerd op weergave
SELECTEER Tabellen:
3 × SELECT `m`.`tag_id`,`t`.*
FROM `kemnz_contentitem_tag_map` AS m
INNER JOIN `kemnz_tags` AS t
ON `m`.`tag_id` = `t`.`id`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `kemnz_assets`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `kemnz_extensions`2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM kemnz_fields AS a
LEFT JOIN `kemnz_languages` AS l
ON l.lang_code = a.language
LEFT JOIN kemnz_users AS uc
ON uc.id=a.checked_out
LEFT JOIN kemnz_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN kemnz_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN kemnz_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `kemnz_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT `data`
FROM `kemnz_session`1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM kemnz_fields AS a
LEFT JOIN `kemnz_languages` AS l
ON l.lang_code = a.language
LEFT JOIN kemnz_users AS uc
ON uc.id=a.checked_out
LEFT JOIN kemnz_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN kemnz_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN kemnz_fields_groups AS g
ON g.id = a.group_id1 × SELECT COUNT(*)
FROM `kemnz_weblinks` AS a
LEFT JOIN kemnz_categories AS c
ON c.id = a.catid
LEFT JOIN kemnz_users AS ua
ON ua.id = a.created_by
LEFT JOIN kemnz_users AS uam
ON uam.id = a.modified_by1 × SELECT a.*,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM `kemnz_weblinks` AS a
LEFT JOIN kemnz_categories AS c
ON c.id = a.catid
LEFT JOIN kemnz_users AS ua
ON ua.id = a.created_by
LEFT JOIN kemnz_users AS uam
ON uam.id = a.modified_by1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `kemnz_weblinks` AS `i`1 × SELECT id, home, template, s.params
FROM kemnz_template_styles as s
LEFT JOIN kemnz_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `session_id`
FROM `kemnz_session`1 × SELECT *
FROM kemnz_languages1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `kemnz_categories` AS `c`1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM kemnz_menu AS m
LEFT JOIN kemnz_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM kemnz_extensions1 × SELECT b.id
FROM kemnz_usergroups AS a
LEFT JOIN kemnz_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `kemnz_viewlevels1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM kemnz_modules AS m
LEFT JOIN kemnz_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN kemnz_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
ANDERE Tabellen:
1 × INSERT INTO `kemnz_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('7a7b92bac24976075a7cbe22e5201e8c', 1, 1674938523, 0, '', 01 × UPDATE `kemnz_extensions`
SET `params` = '{\"mediaversion\":\"b920ec546677e35bac1389e25cd0cb97\"}'