Joomla! Foutopsporingsconsole
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1713434756,
"last": 1713434756,
"now": 1713434756
},
"token": "9bOqN2QE9AqfSLUWMXvqzpS0ZDV7McRi"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"com_mailto": {
"links": {
"3b13af5d2865b510c4216711116285d568ca203e": {
"link": "http:\/\/vlakaf.be\/index.php\/hansbeke\/ligging",
"expiry": 1713434756
}
}
}
}
}
Tijd
Geheugen
Tijd: 4.85 ms / 4.85 ms Geheugen: 0.408 MB / 0.74 MB Application: afterLoad
Tijd: 35.34 ms / 40.20 ms Geheugen: 0.782 MB / 1.52 MB Application: afterInitialise
Tijd: 5.58 ms / 45.78 ms Geheugen: 0.172 MB / 1.69 MB Application: afterRoute
Tijd: 5.91 ms / 51.69 ms Geheugen: 0.121 MB / 1.82 MB Application: beforeRenderComponent com_content
Tijd: 1.73 ms / 53.42 ms Geheugen: 0.052 MB / 1.87 MB Application: Before Access::preloadComponents (all components)
Tijd: 1.90 ms / 55.32 ms Geheugen: 0.053 MB / 1.92 MB Application: After Access::preloadComponents (all components)
Tijd: 0.03 ms / 55.34 ms Geheugen: 0.000 MB / 1.92 MB Application: Before Access::preloadPermissions (com_content)
Tijd: 0.99 ms / 56.33 ms Geheugen: 0.057 MB / 1.98 MB Application: After Access::preloadPermissions (com_content)
Tijd: 0.02 ms / 56.35 ms Geheugen: 0.000 MB / 1.97 MB Application: Before Access::getAssetRules (id:52 name:com_content.article.14)
Tijd: 0.24 ms / 56.59 ms Geheugen: 0.009 MB / 1.98 MB Application: After Access::getAssetRules (id:52 name:com_content.article.14)
Tijd: 27.08 ms / 83.67 ms Geheugen: 0.336 MB / 2.32 MB Application: afterRenderComponent com_content
Tijd: 0.73 ms / 84.40 ms Geheugen: 0.008 MB / 2.33 MB Application: afterDispatch
Tijd: 5.22 ms / 89.62 ms Geheugen: 0.055 MB / 2.38 MB Application: beforeRenderModule mod_menu (Hoofdmenu)
Tijd: 2.03 ms / 91.65 ms Geheugen: 0.086 MB / 2.47 MB Application: afterRenderModule mod_menu (Hoofdmenu)
Tijd: 0.54 ms / 92.19 ms Geheugen: 0.024 MB / 2.49 MB Application: afterRender
Totaal aantal database zoekopdrachten: 42.31 ms
2,83 MB (2.962.432 Bytes)
22 zoekopdrachten gelogd 42.31 ms
- Tijd zoekopdracht: 3.87 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 1.024 MB Regels teruggegeven: 0
SELECT `data`
FROM `kemnz_session`
WHERE `session_id` = 'ac7d1853867f3fd7b39ea734342286e0'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.21 ms checking permissions 0.02 ms Opening tables 2.75 ms After opening tables 0.05 ms System lock 0.02 ms table lock 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.04 ms Unlocking tables 0.02 ms closing tables 0.02 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.27 ms Preparing 0.03 ms Executing 0.02 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.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 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.61 ms Na de laatste zoekopdracht: 0.59 ms Zoekopdracht geheugen: 0.020 MB geheugen voor zoekopdracht: 1.038 MB Regels teruggegeven: 0
SELECT `session_id`
FROM `kemnz_session`
WHERE `session_id` = 'ac7d1853867f3fd7b39ea734342286e0'
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.03 ms Optimizing 0.03 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.02 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.05 ms Updating status 0.02 ms Reset for next command 0.01 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.37 ms Na de laatste zoekopdracht: 0.11 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 ('ac7d1853867f3fd7b39ea734342286e0', 1, 1713434756, 0, '', 0)VERKLAREN niet mogelijk voor zoekopdracht: INSERT INTO `kemnz_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('ac7d1853867f3fd7b39ea734342286e0', 1, 1713434756, 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.01 ms init for update 0.02 ms Update 0.59 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.34 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.05 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 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: 3.13 ms Na de laatste zoekopdracht: 1.00 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.09 ms checking permissions 0.02 ms Opening tables 0.84 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.03 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.06 ms Unlocking tables 0.02 ms closing tables 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.13 ms Preparing 0.04 ms Executing 0.01 ms Sending data 1.38 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 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: 1.42 ms Na de laatste zoekopdracht: 0.93 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.10 ms checking permissions 0.02 ms Opening tables 0.70 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.05 ms Unlocking tables 0.02 ms closing tables 0.02 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.03 ms Unlocking tables 0.03 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.05 ms Updating status 0.03 ms Reset for next command 0.03 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: 1.74 ms Na de laatste zoekopdracht: 0.09 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.09 ms checking permissions 0.02 ms Opening tables 0.93 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.03 ms Unlocking tables 0.02 ms closing tables 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.14 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.03 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.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 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.20 ms Na de laatste zoekopdracht: 0.27 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.10 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 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.54 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.03 ms Reset for next command 0.03 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: 2.25 ms Na de laatste zoekopdracht: 10.35 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.23 ms checking permissions 0.04 ms Opening tables 0.81 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.06 ms Unlocking tables 0.02 ms closing tables 0.04 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.04 ms Creating sort index 0.35 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.02 ms Starting cleanup 0.02 ms Freeing items 0.10 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: 0.82 ms Na de laatste zoekopdracht: 3.12 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 1.714 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.02 ms Opening tables 0.02 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.19 ms Preparing 0.06 ms Executing 0.02 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.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 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.91 ms Na de laatste zoekopdracht: 0.13 ms Zoekopdracht geheugen: 0.005 MB geheugen voor zoekopdracht: 1.705 MB
UPDATE `kemnz_extensions`
SET `params` = '{\"mediaversion\":\"855675e08b5b17f3e20d322e73808fce\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'VERKLAREN niet mogelijk voor zoekopdracht: UPDATE `kemnz_extensions` SET `params` = '{\"mediaversion\":\"855675e08b5b17f3e20d322e73808fce\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.07 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.01 ms init for update 0.05 ms Updating 0.10 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.34 ms closing tables 0.03 ms Unlocking tables 0.02 ms closing tables 0.04 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Reset for next command 0.03 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: 1.53 ms Na de laatste zoekopdracht: 0.51 ms Zoekopdracht geheugen: 0.019 MB geheugen voor zoekopdracht: 1.795 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.09 ms checking permissions 0.02 ms Opening tables 0.72 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.04 ms Unlocking tables 0.02 ms closing tables 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.04 ms Creating sort index 0.09 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 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 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: 1.32 ms Na de laatste zoekopdracht: 0.20 ms Zoekopdracht geheugen: 0.019 MB geheugen voor zoekopdracht: 1.808 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.12 ms checking permissions 0.02 ms Opening tables 0.52 ms After opening tables 0.04 ms System lock 0.04 ms table lock 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.03 ms Unlocking tables 0.01 ms closing tables 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.08 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.03 ms Reset for next command 0.02 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: 1.75 ms Na de laatste zoekopdracht: 2.08 ms Zoekopdracht geheugen: 0.027 MB geheugen voor zoekopdracht: 1.872 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 102 Using where Status Duration Starting 0.13 ms checking permissions 0.02 ms Opening tables 0.76 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms Opening tables 0.03 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.04 ms Unlocking tables 0.02 ms closing tables 0.02 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.15 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.03 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.05 ms Updating status 0.05 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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.15 ms Zoekopdracht geheugen: 0.029 MB geheugen voor zoekopdracht: 1.919 MB Regels teruggegeven: 55
SELECT `id`,`name`,`rules`,`parent_id`
FROM `kemnz_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' 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 102 Using where Status Duration Starting 0.09 ms checking permissions 0.04 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.19 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.11 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 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 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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: 3.63 ms Na de laatste zoekopdracht: 0.63 ms Zoekopdracht geheugen: 0.031 MB geheugen voor zoekopdracht: 1.986 MB Regels teruggegeven: 31
SHOW FULL COLUMNS
FROM `kemnz_content`VERKLAREN niet mogelijk voor zoekopdracht: SHOW FULL COLUMNS FROM `kemnz_content`Status Duration Starting 0.08 ms checking permissions 0.02 ms closing tables 0.01 ms Opening tables 0.29 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.03 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.02 ms Opening tables 2.24 ms After opening tables 0.06 ms checking permissions 0.17 ms closing tables 0.02 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.02 ms Removing tmp table 0.20 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:312 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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.19 ms Na de laatste zoekopdracht: 1.38 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 2.036 MB Regels teruggegeven: 1
SELECT *
FROM kemnz_content
WHERE `id` = '14'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE kemnz_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.11 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 Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.08 ms Unlocking tables 0.02 ms closing tables 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.33 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.05 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1459 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 10 Joomla\CMS\Table\Table->load() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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.87 ms Na de laatste zoekopdracht: 0.09 ms Zoekopdracht geheugen: 0.006 MB geheugen voor zoekopdracht: 2.044 MB
UPDATE kemnz_content
SET `hits` = (`hits` + 1)
WHERE `id` = '14'VERKLAREN niet mogelijk voor zoekopdracht: UPDATE kemnz_content SET `hits` = (`hits` + 1) WHERE `id` = '14'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.05 ms Updating 0.10 ms End of update loop 0.02 ms Query end 0.03 ms Commit 0.32 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 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1245 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:255 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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: 3.09 ms Na de laatste zoekopdracht: 0.68 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 2.131 MB Regels teruggegeven: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM kemnz_content AS a
INNER JOIN kemnz_categories AS c
on c.id = a.catid
LEFT JOIN kemnz_users AS u
on u.id = a.created_by
LEFT JOIN kemnz_categories as parent
ON parent.id = c.parent_id
LEFT JOIN kemnz_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 14
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-18 10:05:56')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-18 10:05:56')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.22 ms checking permissions 0.02 ms Opening tables 1.84 ms After opening tables 0.06 ms System lock 0.01 ms table lock 0.02 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.10 ms Unlocking tables 0.02 ms closing tables 0.02 ms init 0.09 ms Optimizing 0.05 ms Statistics 0.13 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.02 ms Query end 0.03 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 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.05 ms # Caller Bestand en regelnummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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: 2.84 ms Na de laatste zoekopdracht: 1.32 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 2.168 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_content.article'
AND `m`.`content_item_id` = 14
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 1.61 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.02 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.09 ms Unlocking tables 0.02 ms closing tables 0.02 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.24 ms Preparing 0.05 ms Executing 0.02 ms Sending data 0.05 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.02 ms Starting cleanup 0.02 ms Freeing items 0.08 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/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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: 1.66 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 2.214 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
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_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 9
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c range|filter cat_idx,idx_access,idx_left_right idx_left_right|cat_idx 4|207 NULL 4 (50%) Using index condition; Using where; Using rowid filter Status Duration Starting 0.19 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.07 ms Optimizing 0.04 ms Statistics 0.23 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.09 ms End of update loop 0.02 ms Query end 0.01 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.02 ms Reset for next command 0.02 ms # Caller Bestand en regelnummer 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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: 3.90 ms Na de laatste zoekopdracht: 0.27 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 2.234 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_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (9,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.16 ms checking permissions 0.02 ms Opening tables 1.65 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.14 ms Unlocking tables 0.03 ms closing tables 0.02 ms init 0.09 ms Optimizing 0.07 ms Statistics 0.30 ms Preparing 0.11 ms Creating tmp table 0.11 ms Sorting result 0.04 ms Executing 0.02 ms Sending data 0.42 ms Creating sort index 0.09 ms Removing tmp table 0.16 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.02 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.10 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller Bestand en regelnummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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: 2.91 ms Na de laatste zoekopdracht: 6.83 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 2.384 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 <= '2024-04-18 10:05:56')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-18 10:05:56')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 475 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.25 ms checking permissions 0.03 ms Opening tables 1.07 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.06 ms Unlocking tables 0.02 ms closing tables 0.05 ms init 0.05 ms Optimizing 0.05 ms Statistics 0.17 ms Preparing 0.06 ms Creating tmp table 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.42 ms Creating sort index 0.06 ms Removing tmp table 0.13 ms Creating sort index 0.03 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.08 ms Updating status 0.02 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:
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `kemnz_extensions`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `kemnz_assets`1 × SELECT `data`
FROM `kemnz_session`1 × SELECT `session_id`
FROM `kemnz_session`1 × SELECT id, rules
FROM `kemnz_viewlevels1 × 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 `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM kemnz_extensions1 × 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 *
FROM kemnz_languages1 × 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 *
FROM kemnz_content1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM kemnz_content AS a
INNER JOIN kemnz_categories AS c
on c.id = a.catid
LEFT JOIN kemnz_users AS u
on u.id = a.created_by
LEFT JOIN kemnz_categories as parent
ON parent.id = c.parent_id
LEFT JOIN kemnz_content_rating AS v
ON a.id = v.content_id1 × SELECT `m`.`tag_id`,`t`.*
FROM `kemnz_contentitem_tag_map` AS m
INNER JOIN `kemnz_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `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)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_id
LEFT JOIN `kemnz_fields_categories` AS fc
ON fc.field_id = a.id1 × 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 ('ac7d1853867f3fd7b39ea734342286e0', 1, 1713434756, 0, '', 01 × UPDATE `kemnz_extensions`
SET `params` = '{\"mediaversion\":\"855675e08b5b17f3e20d322e73808fce\"}'1 × SHOW FULL COLUMNS
FROM `kemnz_content1 × UPDATE kemnz_content
SET `hits` = (`hits` + 1)