Query tijd: 0.39 ms Query geheugen: 0.023 MB Geheugen voor query: 1.016 MB Teruggegeven rijen: 0
SELECT `data`
FROM `rins_session`
WHERE `session_id` = X'346b6a6e33656f38683774756c7668356732766c7062346a6a66'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | rins_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | Bestand en regelnummer |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | Hetzelfde als de aanroep in de regel hieronder. |
| 13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
| 12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
| 11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
| 10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:661 |
| 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 |
| 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 |
| 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 |
| 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query tijd: 0.28 ms Na laatste query: 0.38 ms Query geheugen: 0.020 MB Geheugen voor query: 1.030 MB Teruggegeven rijen: 0
SELECT `session_id`
FROM `rins_session`
WHERE `session_id` = X'346b6a6e33656f38683774756c7668356732766c7062346a6a66'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | rins_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | Bestand en regelnummer |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query tijd: 2.20 ms Na laatste query: 0.11 ms Query geheugen: 0.004 MB Geheugen voor query: 1.035 MB
INSERT INTO `rins_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'346b6a6e33656f38683774756c7668356732766c7062346a6a66', 1, 1739127796, 0, '', 0)
VERKLAAR niet mogelijk voor query: INSERT INTO `rins_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'346b6a6e33656f38683774756c7668356732766c7062346a6a66', 1, 1739127796, 0, '', 0)
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | 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:828 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query tijd: 0.68 ms Na laatste query: 0.51 ms Query geheugen: 0.025 MB Geheugen voor query: 1.066 MB Teruggegeven rijen: 43
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `rins_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | rins_extensions | ref | extension | extension | 82 | const | 43 | Using index condition; Using where |
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | Bestand en regelnummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
| 10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Hetzelfde als de aanroep in de regel hieronder. |
| 9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
| 7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
| 6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
| 5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
| 4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query tijd: 0.30 ms Na laatste query: 0.61 ms Query geheugen: 0.021 MB Geheugen voor query: 1.097 MB Teruggegeven rijen: 6
SELECT id, rules
FROM `rins_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | rins_viewlevels | ALL | NULL | GEEN INDEX KEY KON GEBRUIKT WORDEN | NULL | NULL | 5 | |
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | Bestand en regelnummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query tijd: 0.37 ms Na laatste query: 0.12 ms Query geheugen: 0.021 MB Geheugen voor query: 1.110 MB Teruggegeven rijen: 2
SELECT b.id
FROM rins_usergroups AS a
LEFT JOIN rins_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| id | 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 |
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | Bestand en regelnummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
| 9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query tijd: 0.90 ms Na laatste query: 0.17 ms Query geheugen: 0.030 MB Geheugen voor query: 1.131 MB Teruggegeven rijen: 103
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM rins_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | rins_extensions | ALL | extension | GEEN INDEX KEY KON GEBRUIKT WORDEN | NULL | NULL | 283 | Using where; Gebruik bestandssortering |
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | Bestand en regelnummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 |
| 9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Hetzelfde als de aanroep in de regel hieronder. |
| 8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:356 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query tijd: 0.74 ms Na laatste query: 17.59 ms Query geheugen: 0.025 MB Geheugen voor query: 1.764 MB Teruggegeven rijen: 1
SELECT id,template
FROM rins_template_styles
WHERE client_id=0
AND home=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | rins_template_styles | ref | idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 3 | Using where |
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | Bestand en regelnummer |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 17 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_widgetkit/widgetkit.php:23 |
| 16 | plgSystemWidgetkit->{closure}() | JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240 |
| 15 | YOOtheme\Framework\Container->offsetGet() | JROOT/administrator/components/com_widgetkit/src/Application.php:49 |
| 14 | YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}() | Hetzelfde als de aanroep in de regel hieronder. |
| 13 | call_user_func_array() | JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113 |
| 12 | YOOtheme\Framework\Event\EventDispatcher->trigger() | JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149 |
| 11 | YOOtheme\Framework\Application->boot() | JROOT/administrator/components/com_widgetkit/widgetkit.php:91 |
| 10 | include JROOT/administrator/components/com_widgetkit/widgetkit.php | JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6 |
| 9 | include JROOT/administrator/components/com_widgetkit/widgetkit-app.php | JROOT/plugins/system/widgetkit/widgetkit.php:9 |
| 8 | plgSystemWidgetkit->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query tijd: 2.70 ms Na laatste query: 0.84 ms Query geheugen: 0.247 MB Geheugen voor query: 1.809 MB Teruggegeven rijen: 204
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 rins_menu AS m
LEFT JOIN rins_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
| id | 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 | 217 | Using index condition; Using where; Gebruik bestandssortering |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | website_rijinstructeur_info.m.component_id | 1 | Using where |
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | Bestand en regelnummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
| 17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Hetzelfde als de aanroep in de regel hieronder. |
| 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
| 14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
| 13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
| 12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
| 11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
| 10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
| 9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
| 8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
| 7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 |
| 6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
| 5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1141 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query tijd: 0.56 ms Na laatste query: 5.15 ms Query geheugen: 0.021 MB Geheugen voor query: 2.717 MB Teruggegeven rijen: 3
SELECT id, home, template, s.params
FROM rins_template_styles as s
LEFT JOIN rins_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ref | idx_template,idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 3 | |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | website_rijinstructeur_info.s.template,const | 1 | Using index condition; Using where |
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | Bestand en regelnummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
| 10 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:987 |
| 9 | plgSystemEF4_JMFramework->getTemplateName() | JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:210 |
| 8 | plgSystemEF4_JMFramework->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query tijd: 0.49 ms Na laatste query: 2.57 ms Query geheugen: 0.024 MB Geheugen voor query: 2.901 MB Teruggegeven rijen: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `rins_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | rins_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | Bestand en regelnummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 17 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Hetzelfde als de aanroep in de regel hieronder. |
| 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
| 14 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 13 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 12 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:295 |
| 8 | plgSystemEF4_JMFramework->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query tijd: 1.76 ms Na laatste query: 0.21 ms Query geheugen: 0.006 MB Geheugen voor query: 2.893 MB
UPDATE `rins_extensions`
SET `params` = '{\"mediaversion\":\"b1ff96055152036abcf4a6ed2ddf92fa\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
VERKLAAR niet mogelijk voor query: UPDATE `rins_extensions`
SET `params` = '{\"mediaversion\":\"b1ff96055152036abcf4a6ed2ddf92fa\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | Bestand en regelnummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:295 |
| 8 | plgSystemEF4_JMFramework->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query tijd: 0.39 ms Na laatste query: 3.01 ms Query geheugen: 0.019 MB Geheugen voor query: 3.045 MB Teruggegeven rijen: 1
SELECT *
FROM rins_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | rins_languages | ALL | NULL | GEEN INDEX KEY KON GEBRUIKT WORDEN | NULL | NULL | 3 | Using where; Gebruik bestandssortering |
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | Bestand en regelnummer |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query tijd: 0.68 ms Na laatste query: 1.68 ms Query geheugen: 0.028 MB Geheugen voor query: 3.196 MB Teruggegeven rijen: 43
SELECT `id`,`name`,`rules`,`parent_id`
FROM `rins_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_driving_school_review','com_easyblog','com_fields','com_finder','com_installer','com_j2xml','com_jce','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nodechain','com_plugins','com_postinstall','com_privacy','com_redirect','com_rijscholendata','com_search','com_tags','com_templates','com_users','com_widgetkit','com_wrapper')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | rins_assets | ALL | idx_asset_name | GEEN INDEX KEY KON GEBRUIKT WORDEN | NULL | NULL | 228 | Using where |
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | Bestand en regelnummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 15 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 14 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 13 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 12 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 11 | Joomla\CMS\User\User->authorise() | JROOT/components/com_nodechain/views/document_pages/view.html.php:30 |
| 10 | NodechainViewDocument_pages->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_nodechain/controller.php:33 |
| 8 | NodechainController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_nodechain/nodechain.php:48 |
| 6 | require_once JROOT/components/com_nodechain/nodechain.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query tijd: 1.40 ms Na laatste query: 2.63 ms Query geheugen: 0.026 MB Geheugen voor query: 3.298 MB Teruggegeven rijen: 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 rins_fields AS a
LEFT JOIN `rins_languages` AS l
ON l.lang_code = a.language
LEFT JOIN rins_users AS uc
ON uc.id=a.checked_out
LEFT JOIN rins_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN rins_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN rins_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_nodechain.form'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | 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; Gebruik bestandssortering |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | website_rijinstructeur_info.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | website_rijinstructeur_info.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | website_rijinstructeur_info.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | website_rijinstructeur_info.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | website_rijinstructeur_info.a.group_id | 1 | Using where |
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | Bestand en regelnummer |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 20 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 19 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 18 | FieldsHelper::getFields() | JROOT/administrator/components/com_fields/helpers/fields.php:286 |
| 17 | FieldsHelper::prepareForm() | JROOT/plugins/system/fields/fields.php:305 |
| 16 | PlgSystemFields->onContentPrepareForm() | JROOT/libraries/joomla/event/event.php:70 |
| 15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 14 | JEventDispatcher->trigger() | JROOT/libraries/src/MVC/Model/FormModel.php:323 |
| 13 | Joomla\CMS\MVC\Model\FormModel->preprocessForm() | JROOT/libraries/src/MVC/Model/FormModel.php:244 |
| 12 | Joomla\CMS\MVC\Model\FormModel->loadForm() | JROOT/components/com_nodechain/models/document_pages.php:810 |
| 11 | NodechainModelDocument_pages->getform() | JROOT/components/com_nodechain/views/document_pages/view.html.php:37 |
| 10 | NodechainViewDocument_pages->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_nodechain/controller.php:33 |
| 8 | NodechainController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_nodechain/nodechain.php:48 |
| 6 | require_once JROOT/components/com_nodechain/nodechain.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query tijd: 0.76 ms Na laatste query: 0.15 ms Query geheugen: 0.022 MB Geheugen voor query: 3.308 MB Teruggegeven rijen: 1
SELECT
id,
document_id,
viewpath_identifier,
shortname,
description,
is_default,
canonical,
browser_page_title_prefix,
print_enabled,
print_title_left,
print_title_right,
print_footer_left,
print_footer_right,
question_answer_enabled
FROM rins_nodechain_viewpath
WHERE id = 131
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | rins_nodechain_viewpath | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | Bestand en regelnummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 12 | JDatabaseDriver->loadObject() | JROOT/components/com_nodechain/models/document_pages.php:721 |
| 11 | NodechainModelDocument_pages->getViewpathByID() | JROOT/components/com_nodechain/views/document_pages/view.html.php:41 |
| 10 | NodechainViewDocument_pages->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_nodechain/controller.php:33 |
| 8 | NodechainController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_nodechain/nodechain.php:48 |
| 6 | require_once JROOT/components/com_nodechain/nodechain.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query tijd: 11.97 ms Na laatste query: 1.27 ms Query geheugen: 0.023 MB Geheugen voor query: 3.325 MB Teruggegeven rijen: 1
SELECT MAX(pagegroup)
FROM rins_nodechain_viewpath_nodes
WHERE viewpath_id = "131"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | rins_nodechain_viewpath_nodes | ref | identifier_id | identifier_id | 4 | const | 3086 | |
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | Bestand en regelnummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 12 | JDatabaseDriver->loadResult() | JROOT/components/com_nodechain/models/document_pages.php:686 |
| 11 | NodechainModelDocument_pages->findLastPageNumber() | JROOT/components/com_nodechain/views/document_pages/view.html.php:73 |
| 10 | NodechainViewDocument_pages->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_nodechain/controller.php:33 |
| 8 | NodechainController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_nodechain/nodechain.php:48 |
| 6 | require_once JROOT/components/com_nodechain/nodechain.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query tijd: 0.33 ms Na laatste query: 0.13 ms Query geheugen: 0.022 MB Geheugen voor query: 3.332 MB Teruggegeven rijen: 0
SELECT *
FROM rins_nodechain_node_seo
WHERE viewpath_id = "131"
and `pagegroup` = "63"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | GEEN INDEX KEY KON GEBRUIKT WORDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | Bestand en regelnummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 13 | JDatabaseDriver->loadObject() | JROOT/components/com_nodechain/models/document_pages.php:739 |
| 12 | NodechainModelDocument_pages->getMetaTags() | JROOT/components/com_nodechain/views/document_pages/view.html.php:269 |
| 11 | NodechainViewDocument_pages->setSEO() | JROOT/components/com_nodechain/views/document_pages/view.html.php:84 |
| 10 | NodechainViewDocument_pages->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_nodechain/controller.php:33 |
| 8 | NodechainController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_nodechain/nodechain.php:48 |
| 6 | require_once JROOT/components/com_nodechain/nodechain.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query tijd: 0.86 ms Na laatste query: 0.19 ms Query geheugen: 0.024 MB Geheugen voor query: 3.341 MB Teruggegeven rijen: 10
SELECT
nodes.id,
nodes.node_identifier,
nodes.node_version,
nodes.content,
if((viewpath.html_prefix is null OR viewpath.html_prefix = ''),nodes.html_prefix,viewpath.html_prefix) as html_prefix,
if((viewpath.html_suffix is null OR viewpath.html_suffix = ''),nodes.html_suffix,viewpath.html_suffix) as html_suffix,
timeframe.valid_from,
timeframe.valid_until,
timeframe.display_from,
timeframe.display_until
FROM rins_nodechain_viewpath_nodes AS viewpath
LEFT JOIN rins_nodechain_node AS nodes
ON viewpath.node_id = nodes.id
LEFT JOIN rins_nodechain_node_timeframe AS timeframe
ON timeframe.node_id = nodes.id
WHERE viewpath.viewpath_id = 131
AND viewpath.pagegroup = 63
AND ( timeframe.display_from < NOW() or timeframe.display_from is null)
AND ( timeframe.display_until > NOW() or timeframe.display_until is null)
ORDER BY viewpath.pageorder| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | viewpath | ref | page,identifier_id | page | 4 | const | 23 | Using where |
| 1 | SIMPLE | nodes | eq_ref | PRIMARY | PRIMARY | 4 | website_rijinstructeur_info.viewpath.node_id | 1 | Using where |
| 1 | SIMPLE | timeframe | eq_ref | identifier_id | identifier_id | 4 | website_rijinstructeur_info.nodes.id | 1 | Using where |
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | Bestand en regelnummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_nodechain/models/document_pages.php:64 |
| 11 | NodechainModelDocument_pages->getPageNodes() | JROOT/components/com_nodechain/views/document_pages/view.html.php:94 |
| 10 | NodechainViewDocument_pages->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_nodechain/controller.php:33 |
| 8 | NodechainController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_nodechain/nodechain.php:48 |
| 6 | require_once JROOT/components/com_nodechain/nodechain.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query tijd: 0.77 ms Na laatste query: 0.09 ms Query geheugen: 0.022 MB Geheugen voor query: 3.359 MB Teruggegeven rijen: 4
SELECT
nodes.id,
count(violation.node_id) AS violation_count
FROM rins_nodechain_viewpath_nodes AS viewpath
LEFT JOIN rins_nodechain_node AS nodes
ON viewpath.node_id = nodes.id
LEFT JOIN rins_nodechain_node_timeframe AS timeframe
ON timeframe.node_id = nodes.id
INNER JOIN rins_nodechain_node_violation AS violation
ON violation.node_id = nodes.id
WHERE viewpath.viewpath_id = 131
AND viewpath.pagegroup = 63
AND ( timeframe.display_from < NOW() or timeframe.display_from is null)
AND ( timeframe.display_until > NOW() or timeframe.display_until is null)
GROUP BY violation.node_id| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | viewpath | ref | page,identifier_id | page | 4 | const | 23 | Using where; Using temporary; Gebruik bestandssortering |
| 1 | SIMPLE | nodes | eq_ref | PRIMARY | PRIMARY | 4 | website_rijinstructeur_info.viewpath.node_id | 1 | Using where; Using index |
| 1 | SIMPLE | timeframe | eq_ref | identifier_id | identifier_id | 4 | website_rijinstructeur_info.nodes.id | 1 | Using where |
| 1 | SIMPLE | violation | ref | identifier_id | identifier_id | 4 | website_rijinstructeur_info.nodes.id | 1 | Using where; Using index |
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | Bestand en regelnummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 12 | JDatabaseDriver->loadColumn() | JROOT/components/com_nodechain/models/document_pages.php:106 |
| 11 | NodechainModelDocument_pages->getPageNodeViolations() | JROOT/components/com_nodechain/views/document_pages/view.html.php:97 |
| 10 | NodechainViewDocument_pages->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_nodechain/controller.php:33 |
| 8 | NodechainController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_nodechain/nodechain.php:48 |
| 6 | require_once JROOT/components/com_nodechain/nodechain.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query tijd: 0.71 ms Na laatste query: 0.08 ms Query geheugen: 0.022 MB Geheugen voor query: 3.366 MB Teruggegeven rijen: 0
SELECT
nodes.id,
count(qa.node_id) as qa_count
FROM rins_nodechain_viewpath_nodes AS viewpath
LEFT JOIN rins_nodechain_node AS nodes
ON viewpath.node_id = nodes.id
LEFT JOIN rins_nodechain_node_timeframe AS timeframe
ON timeframe.node_id = nodes.id
INNER JOIN rins_nodechain_qa_questions AS qa
ON qa.user_id = 0
AND qa.node_id = nodes.id
WHERE viewpath.viewpath_id = 131
AND viewpath.pagegroup = 63
AND ( timeframe.display_from < NOW() or timeframe.display_from is null)
AND ( timeframe.display_until > NOW() or timeframe.display_until is null)
GROUP BY qa.node_id| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | viewpath | ref | page,identifier_id | page | 4 | const | 23 | Using where; Using temporary; Gebruik bestandssortering |
| 1 | SIMPLE | nodes | eq_ref | PRIMARY | PRIMARY | 4 | website_rijinstructeur_info.viewpath.node_id | 1 | Using where; Using index |
| 1 | SIMPLE | timeframe | eq_ref | identifier_id | identifier_id | 4 | website_rijinstructeur_info.nodes.id | 1 | Using where |
| 1 | SIMPLE | qa | ref | user,node_id | node_id | 5 | website_rijinstructeur_info.nodes.id | 1 | Using index condition; Using where |
Geen TOON PROFIEL (mogelijk omdat er meer dan 100 queries zijn)
| # | Aanroeper | Bestand en regelnummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 12 | JDatabaseDriver->loadColumn() | JROOT/components/com_nodechain/models/document_pages.php:150 |
| 11 | NodechainModelDocument_pages->getPageNodeQuestions() | JROOT/components/com_nodechain/views/document_pages/view.html.php:100 |
| 10 | NodechainViewDocument_pages->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_nodechain/controller.php:33 |
| 8 | NodechainController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_nodechain/nodechain.php:48 |
| 6 | require_once JROOT/components/com_nodechain/nodechain.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query tijd: 0.33 ms Na laatste query: 0.08 ms Query geheugen: 0.022 MB Geheugen voor query: 3.371 MB Teruggegeven rijen: 1
3De bestuurder van een auto of van een motorfiets mag een fietser of bestuurder van een tweewielige bromfiets die zich op de openbare weg bevindt onder de in dit reglement voorziene voorwaarden niet in gevaar brengen.