EAV-Gebedsmaand
In de maand oktober besteden we extra aandacht aan gebed. Er verschijnt een speciaal gebedsrooster met een of meerdere onderwerpen voor iedere dag.
In de maand oktober besteden we extra aandacht aan gebed. Er verschijnt een speciaal gebedsrooster met een of meerdere onderwerpen voor iedere dag.
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1553283341,
"last": 1553283341,
"now": 1553283341
},
"token": "iFQ2CQrNSM8On5Hx19E9KblYFJ8JF3p5"
},
"registry": {
"jevents": {
"moduleid173": {
"shownEventIds": [
[
"326",
"326",
"327",
"326",
"328"
]
],
"page": 0,
"firstEventDate": "2019-03-22 18:00:00",
"lastEventDate": "2019-03-31 11:30:00"
}
},
"published_fv_ses": "0"
},
"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
}
}
}
SELECT `data`
FROM `qkruz_session`
WHERE `session_id` = 'as8ujg4j5rvr1dlmur0ai6kmk6'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qkruz_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.11 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.06 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.09 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 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:758 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 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:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `session_id`
FROM `qkruz_session`
WHERE `session_id` = 'as8ujg4j5rvr1dlmur0ai6kmk6'
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qkruz_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 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:153 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 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:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
INSERT INTO `qkruz_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('as8ujg4j5rvr1dlmur0ai6kmk6', 1, 1553283341, 0, '', 0)
| Status | Duration |
|---|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| update | 0.13 ms |
| end | 0.01 ms |
| query end | 0.63 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 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:153 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 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:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `qkruz_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qkruz_extensions | NULL | ref | extension | extension | 82 | const | 46 | 1.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.13 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.13 ms |
| preparing | 0.03 ms |
| executing | 0.00 ms |
| Sending data | 0.54 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, rules
FROM `qkruz_viewlevels`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qkruz_viewlevels | NULL | ALL | NULL | INDEX KEY ONTBREEKT | NULL | NULL | 5 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.07 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT b.id
FROM qkruz_usergroups AS a
LEFT JOIN qkruz_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where; Using index |
| Status | Duration |
|---|---|
| starting | 0.06 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.10 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM qkruz_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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qkruz_extensions | NULL | ref | extension | extension | 82 | const | 161 | 0.60 | Using index condition; Using where; Gebruikt bestandssortering |
| Status | Duration |
|---|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 1.36 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `enabled`
FROM `qkruz_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qkruz_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 10.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.12 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.17 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.08 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | Bestand en regelnummer |
|---|---|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 8 | JDatabaseDriver->loadResult() | JROOT/plugins/system/backuponupdate/backuponupdate.php:36 |
| 7 | require_once JROOT/plugins/system/backuponupdate/backuponupdate.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:625 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 qkruz_menu AS m
LEFT JOIN qkruz_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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | NULL | ALL | idx_client_id_parent_id_alias_language | INDEX KEY ONTBREEKT | NULL | NULL | 192 | 6.67 | Using where; Gebruikt bestandssortering |
| 1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | eav_joomla3.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.12 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.09 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 1.56 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 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:375 |
| 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:491 |
| 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:1073 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `qkruz_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qkruz_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.12 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.06 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 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:1119 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE `qkruz_extensions`
SET `params` = '{\"mediaversion\":\"a937b0a66e56a2c4511d12042d9bd3e8\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | UPDATE | qkruz_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.05 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.07 ms |
| updating | 0.09 ms |
| end | 0.01 ms |
| query end | 0.66 ms |
| closing tables | 0.02 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.00 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:1119 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM qkruz_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qkruz_languages | NULL | ALL | NULL | INDEX KEY ONTBREEKT | NULL | NULL | 1 | 100.00 | Using where; Gebruikt bestandssortering |
| Status | Duration |
|---|---|
| starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.03 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.11 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, home, template, s.params
FROM qkruz_template_styles as s
LEFT JOIN qkruz_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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | NULL | ALL | idx_template | INDEX KEY ONTBREEKT | NULL | NULL | 6 | 16.67 | Using where |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | eav_joomla3.s.template,const | 1 | 4.46 | Using index condition; Using where |
| Status | Duration |
|---|---|
| starting | 0.06 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.12 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.14 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `qkruz_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gmapfp','com_installer','com_jce','com_jevents','com_jifile','com_joomdle','com_joomlaupdate','com_languages','com_login','com_magiczoomplus','com_mailto','com_media','com_menus','com_messages','com_modules','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_widgetkit','com_wrapper')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qkruz_assets | NULL | range | idx_asset_name | idx_asset_name | 202 | NULL | 42 | 100.00 | Using index condition |
| Status | Duration |
|---|---|
| starting | 0.18 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.10 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.30 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 1.94 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `qkruz_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qkruz_assets | NULL | ALL | idx_asset_name,idx_parent_id | INDEX KEY ONTBREEKT | NULL | NULL | 1688 | 21.29 | Using where |
| Status | Duration |
|---|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.10 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 4.54 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.00 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `qkruz_content`
| Status | Duration |
|---|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.19 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| Opening tables | 0.14 ms |
| checking permissions | 0.05 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending data | 0.16 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.04 ms |
| closing tables | 0.00 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM qkruz_content
WHERE `id` = '85'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qkruz_content | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.22 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.15 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE qkruz_content
SET `hits` = (`hits` + 1)
WHERE `id` = '85'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | UPDATE | qkruz_content | NULL | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.05 ms |
| updating | 0.10 ms |
| end | 0.01 ms |
| query end | 0.64 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 qkruz_content AS a
INNER JOIN qkruz_categories AS c
on c.id = a.catid
LEFT JOIN qkruz_users AS u
on u.id = a.created_by
LEFT JOIN qkruz_categories as parent
ON parent.id = c.parent_id
LEFT JOIN qkruz_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 85
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-03-22 19:35:41')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-03-22 19:35:41')
AND (a.state = 1 OR a.state =2)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY,idx_state,idx_catid | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | u | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | v | NULL | const | PRIMARY | PRIMARY | 4 | const | 0 | 0.00 | unique row not found |
| Status | Duration |
|---|---|
| starting | 0.20 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.15 ms |
| init | 0.07 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.20 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.13 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `m`.`tag_id`,`t`.*
FROM `qkruz_contentitem_tag_map` AS m
INNER JOIN `qkruz_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 85
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | INDEX KEY ONTBREEKT | NULL | NULL | 1 | 100.00 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | eav_joomla3.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.05 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.13 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.08 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 `qkruz_categories` AS `s`
INNER JOIN `qkruz_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 = 14
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Gebruikt bestandssortering |
| 1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | INDEX KEY ONTBREEKT | NULL | NULL | 110 | 23.88 | Using where |
| Status | Duration |
|---|---|
| starting | 0.23 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.09 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.28 ms |
| preparing | 0.04 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.61 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT 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 qkruz_fields AS a
LEFT JOIN `qkruz_languages` AS l
ON l.lang_code = a.language
LEFT JOIN qkruz_users AS uc
ON uc.id=a.checked_out
LEFT JOIN qkruz_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN qkruz_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN qkruz_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `qkruz_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 (14,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 ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Gebruikt bestandssortering |
| 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | eav_joomla3.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | eav_joomla3.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | eav_joomla3.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | eav_joomla3.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | eav_joomla3.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | eav_joomla3.a.id | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|---|
| starting | 0.21 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.12 ms |
| init | 0.11 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.21 ms |
| preparing | 0.06 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT params
FROM qkruz_extensions AS e
WHERE e.element='com_widgetkit'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 402 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.10 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.06 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | Bestand en regelnummer |
|---|---|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 14 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_widgetkit/helpers/system.php:254 |
| 13 | SystemWidgetkitHelper->_getParams() | JROOT/administrator/components/com_widgetkit/helpers/system.php:54 |
| 12 | SystemWidgetkitHelper->__construct() | JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129 |
| 11 | Widgetkit->loadHelper() | JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76 |
| 10 | Widgetkit->getHelper() | JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137 |
| 9 | Widgetkit->offsetGet() | JROOT/administrator/components/com_widgetkit/widgetkit.php:17 |
| 8 | require_once JROOT/administrator/components/com_widgetkit/widgetkit.php | JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20 |
| 7 | plgSystemWidgetkit_System->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM qkruz_modules AS m
LEFT JOIN qkruz_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN qkruz_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 <= '2019-03-22 19:35:41')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-03-22 19:35:41')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 187 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds | published | 5 | NULL | 22 | 1.60 | Using index condition; Using where; Gebruikt bestandssortering |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | eav_joomla3.m.module,const | 1 | 10.00 | Using index condition; Using where |
| 1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | eav_joomla3.m.id | 5 | 40.00 | Using where; Using index |
| Status | Duration |
|---|---|
| starting | 0.15 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.07 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.16 ms |
| preparing | 0.04 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.68 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Caller | Bestand en regelnummer |
|---|---|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 18 | JDatabaseDriver->loadObjectList() | Zelfde als de call in onderstaande regel. |
| 17 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 16 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:432 |
| 15 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:362 |
| 14 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
| 13 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:581 |
| 12 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:49 |
| 11 | ModulesWarpHelper->count() | JROOT/templates/jp-hope/layouts/template.config.php:42 |
| 10 | include JROOT/templates/jp-hope/layouts/template.config.php | JROOT/templates/jp-hope/layouts/template.php:10 |
| 9 | include JROOT/templates/jp-hope/layouts/template.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 8 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/index.php:19 |
| 7 | require JROOT/templates/jp-hope/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:1030 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT 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 qkruz_fields AS a
LEFT JOIN `qkruz_languages` AS l
ON l.lang_code = a.language
LEFT JOIN qkruz_users AS uc
ON uc.id=a.checked_out
LEFT JOIN qkruz_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN qkruz_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN qkruz_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `qkruz_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'mod_custom.content'
AND (fc.category_id IS NULL OR fc.category_id IN (14,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 ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Gebruikt bestandssortering |
| 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | eav_joomla3.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | eav_joomla3.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | eav_joomla3.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | eav_joomla3.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | eav_joomla3.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | eav_joomla3.a.id | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|---|
| starting | 0.21 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| init | 0.08 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.15 ms |
| preparing | 0.04 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.00 ms |
| # | Caller | Bestand en regelnummer |
|---|---|---|
| 29 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 28 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 27 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 26 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 25 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
| 24 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:488 |
| 23 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 22 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 21 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 20 | JHtmlContent::prepare() | Zelfde als de call in onderstaande regel. |
| 19 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 18 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 17 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/modules/mod_custom/mod_custom.php:15 |
| 16 | include JROOT/modules/mod_custom/mod_custom.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 14 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:86 |
| 13 | ModulesWarpHelper->load() | JROOT/templates/jp-hope/warp/systems/joomla/layouts/modules.php:10 |
| 12 | include JROOT/templates/jp-hope/warp/systems/joomla/layouts/modules.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 11 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:64 |
| 10 | ModulesWarpHelper->render() | JROOT/templates/jp-hope/layouts/template.php:48 |
| 9 | include JROOT/templates/jp-hope/layouts/template.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 8 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/index.php:19 |
| 7 | require JROOT/templates/jp-hope/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:1030 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `qkruz_jev_users`
| Status | Duration |
|---|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.19 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.10 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending data | 0.08 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.04 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | Bestand en regelnummer |
|---|---|---|
| 30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 29 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 28 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 27 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 26 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_jevents/tables/jevuser.php:69 |
| 25 | TableUser->__construct() | JROOT/components/com_jevents/libraries/helper.php:2344 |
| 24 | JEVHelper::getAuthorisedUser() | JROOT/components/com_jevents/libraries/helper.php:1237 |
| 23 | JEVHelper::isEventCreator() | JROOT/components/com_jevents/libraries/filters/Published.php:50 |
| 22 | jevPublishedFilter->__construct() | JROOT/components/com_jevents/libraries/filters.php:142 |
| 21 | jevFilterProcessing->__construct() | JROOT/components/com_jevents/libraries/filters.php:200 |
| 20 | jevFilterProcessing::getInstance() | JROOT/components/com_jevents/libraries/dbmodel.php:947 |
| 19 | JEventsDBModel->listLatestIcalEvents() | JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398 |
| 18 | DefaultModLatestView->getLatestEventsData() | JROOT/modules/mod_jevents_latest/tmpl/flatplus/latest.php:26 |
| 17 | FlatplusModLatestView->displayLatestEvents() | JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 |
| 16 | include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 14 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:86 |
| 13 | ModulesWarpHelper->load() | JROOT/templates/jp-hope/warp/systems/joomla/layouts/modules.php:10 |
| 12 | include JROOT/templates/jp-hope/warp/systems/joomla/layouts/modules.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 11 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:64 |
| 10 | ModulesWarpHelper->render() | JROOT/templates/jp-hope/layouts/template.php:114 |
| 9 | include JROOT/templates/jp-hope/layouts/template.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 8 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/index.php:19 |
| 7 | require JROOT/templates/jp-hope/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:1030 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT c.id AS id, a.name AS asset_name
FROM ( SELECT id,asset_id
FROM qkruz_categories
WHERE extension = 'com_jevents'
AND published = 1) AS c
INNER JOIN qkruz_assets AS a
ON c.asset_id = a.id
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qkruz_categories | NULL | ref | cat_idx | cat_idx | 203 | const,const | 13 | 100.00 | NULL |
| 1 | SIMPLE | a | NULL | eq_ref | PRIMARY | PRIMARY | 4 | eav_joomla3.qkruz_categories.asset_id | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.08 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.10 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.20 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | Bestand en regelnummer |
|---|---|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/User/User.php:428 |
| 25 | Joomla\CMS\User\User->getAuthorisedCategories() | JROOT/components/com_jevents/libraries/helper.php:2386 |
| 24 | JEVHelper::getAuthorisedCategories() | JROOT/components/com_jevents/libraries/helper.php:1276 |
| 23 | JEVHelper::isEventCreator() | JROOT/components/com_jevents/libraries/filters/Published.php:50 |
| 22 | jevPublishedFilter->__construct() | JROOT/components/com_jevents/libraries/filters.php:142 |
| 21 | jevFilterProcessing->__construct() | JROOT/components/com_jevents/libraries/filters.php:200 |
| 20 | jevFilterProcessing::getInstance() | JROOT/components/com_jevents/libraries/dbmodel.php:947 |
| 19 | JEventsDBModel->listLatestIcalEvents() | JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398 |
| 18 | DefaultModLatestView->getLatestEventsData() | JROOT/modules/mod_jevents_latest/tmpl/flatplus/latest.php:26 |
| 17 | FlatplusModLatestView->displayLatestEvents() | JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 |
| 16 | include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 14 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:86 |
| 13 | ModulesWarpHelper->load() | JROOT/templates/jp-hope/warp/systems/joomla/layouts/modules.php:10 |
| 12 | include JROOT/templates/jp-hope/warp/systems/joomla/layouts/modules.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 11 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:64 |
| 10 | ModulesWarpHelper->render() | JROOT/templates/jp-hope/layouts/template.php:114 |
| 9 | include JROOT/templates/jp-hope/layouts/template.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 8 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/index.php:19 |
| 7 | require JROOT/templates/jp-hope/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:1030 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `qkruz_assets`
WHERE `name` LIKE 'com_jevents.%' OR `name` = 'com_jevents' OR `parent_id` = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qkruz_assets | NULL | ALL | idx_asset_name,idx_parent_id | INDEX KEY ONTBREEKT | NULL | NULL | 1688 | 21.29 | Using where |
| Status | Duration |
|---|---|
| starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.08 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 1.56 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | Bestand en regelnummer |
|---|---|---|
| 32 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 31 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
| 30 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
| 29 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
| 28 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 27 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 26 | Joomla\CMS\User\User->authorise() | JROOT/libraries/src/User/User.php:433 |
| 25 | Joomla\CMS\User\User->getAuthorisedCategories() | JROOT/components/com_jevents/libraries/helper.php:2386 |
| 24 | JEVHelper::getAuthorisedCategories() | JROOT/components/com_jevents/libraries/helper.php:1276 |
| 23 | JEVHelper::isEventCreator() | JROOT/components/com_jevents/libraries/filters/Published.php:50 |
| 22 | jevPublishedFilter->__construct() | JROOT/components/com_jevents/libraries/filters.php:142 |
| 21 | jevFilterProcessing->__construct() | JROOT/components/com_jevents/libraries/filters.php:200 |
| 20 | jevFilterProcessing::getInstance() | JROOT/components/com_jevents/libraries/dbmodel.php:947 |
| 19 | JEventsDBModel->listLatestIcalEvents() | JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398 |
| 18 | DefaultModLatestView->getLatestEventsData() | JROOT/modules/mod_jevents_latest/tmpl/flatplus/latest.php:26 |
| 17 | FlatplusModLatestView->displayLatestEvents() | JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 |
| 16 | include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 14 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:86 |
| 13 | ModulesWarpHelper->load() | JROOT/templates/jp-hope/warp/systems/joomla/layouts/modules.php:10 |
| 12 | include JROOT/templates/jp-hope/warp/systems/joomla/layouts/modules.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 11 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:64 |
| 10 | ModulesWarpHelper->render() | JROOT/templates/jp-hope/layouts/template.php:114 |
| 9 | include JROOT/templates/jp-hope/layouts/template.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 8 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/index.php:19 |
| 7 | require JROOT/templates/jp-hope/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:1030 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 `qkruz_categories` AS `c`
WHERE (c.extension='com_jevents' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | c | NULL | range | cat_idx,idx_access | cat_idx | 207 | NULL | 16 | 100.00 | Using index condition; Gebruikt bestandssortering |
| Status | Duration |
|---|---|
| starting | 0.14 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.12 ms |
| preparing | 0.02 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.44 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | Bestand en regelnummer |
|---|---|---|
| 30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 29 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 28 | Joomla\CMS\Categories\Categories->_load() | JROOT/components/com_jevents/helpers/category.php:47 |
| 27 | JEventsCategories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 26 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_jevents/libraries/dbmodel.php:77 |
| 25 | JEventsDBModel->accessibleCategoryList() | JROOT/components/com_jevents/libraries/datamodel.php:887 |
| 24 | JEventsDataModel->accessibleCategoryList() | JROOT/components/com_jevents/libraries/helper.php:1283 |
| 23 | JEVHelper::isEventCreator() | JROOT/components/com_jevents/libraries/filters/Published.php:50 |
| 22 | jevPublishedFilter->__construct() | JROOT/components/com_jevents/libraries/filters.php:142 |
| 21 | jevFilterProcessing->__construct() | JROOT/components/com_jevents/libraries/filters.php:200 |
| 20 | jevFilterProcessing::getInstance() | JROOT/components/com_jevents/libraries/dbmodel.php:947 |
| 19 | JEventsDBModel->listLatestIcalEvents() | JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398 |
| 18 | DefaultModLatestView->getLatestEventsData() | JROOT/modules/mod_jevents_latest/tmpl/flatplus/latest.php:26 |
| 17 | FlatplusModLatestView->displayLatestEvents() | JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 |
| 16 | include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 14 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:86 |
| 13 | ModulesWarpHelper->load() | JROOT/templates/jp-hope/warp/systems/joomla/layouts/modules.php:10 |
| 12 | include JROOT/templates/jp-hope/warp/systems/joomla/layouts/modules.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 11 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:64 |
| 10 | ModulesWarpHelper->render() | JROOT/templates/jp-hope/layouts/template.php:114 |
| 9 | include JROOT/templates/jp-hope/layouts/template.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 8 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/index.php:19 |
| 7 | require JROOT/templates/jp-hope/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:1030 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT c.id
FROM qkruz_categories AS c
WHERE c.access IN (1,1,5)
AND c.published = 1
AND c.language in ('nl-NL','*')
AND c.extension = 'com_jevents'
ORDER BY c.lft asc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | c | NULL | range | cat_idx,idx_access,idx_language | cat_idx | 207 | NULL | 14 | 100.00 | Using index condition; Using where; Gebruikt bestandssortering |
| Status | Duration |
|---|---|
| starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.08 ms |
| preparing | 0.05 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.17 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | Bestand en regelnummer |
|---|---|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
| 26 | JDatabaseDriver->loadColumn() | JROOT/components/com_jevents/libraries/dbmodel.php:186 |
| 25 | JEventsDBModel->accessibleCategoryList() | JROOT/components/com_jevents/libraries/datamodel.php:887 |
| 24 | JEventsDataModel->accessibleCategoryList() | JROOT/components/com_jevents/libraries/helper.php:1283 |
| 23 | JEVHelper::isEventCreator() | JROOT/components/com_jevents/libraries/filters/Published.php:50 |
| 22 | jevPublishedFilter->__construct() | JROOT/components/com_jevents/libraries/filters.php:142 |
| 21 | jevFilterProcessing->__construct() | JROOT/components/com_jevents/libraries/filters.php:200 |
| 20 | jevFilterProcessing::getInstance() | JROOT/components/com_jevents/libraries/dbmodel.php:947 |
| 19 | JEventsDBModel->listLatestIcalEvents() | JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398 |
| 18 | DefaultModLatestView->getLatestEventsData() | JROOT/modules/mod_jevents_latest/tmpl/flatplus/latest.php:26 |
| 17 | FlatplusModLatestView->displayLatestEvents() | JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 |
| 16 | include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 14 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:86 |
| 13 | ModulesWarpHelper->load() | JROOT/templates/jp-hope/warp/systems/joomla/layouts/modules.php:10 |
| 12 | include JROOT/templates/jp-hope/warp/systems/joomla/layouts/modules.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 11 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:64 |
| 10 | ModulesWarpHelper->render() | JROOT/templates/jp-hope/layouts/template.php:114 |
| 9 | include JROOT/templates/jp-hope/layouts/template.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 8 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/index.php:19 |
| 7 | require JROOT/templates/jp-hope/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:1030 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM qkruz_jevents_repetition as rpt
INNER JOIN qkruz_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN qkruz_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN qkruz_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN qkruz_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,20,88,89,90,91,92,93,94,95,96,97,98,99)
AND rpt.endrepeat >= '2019-03-22 20:35:41'
AND rpt.startrepeat <= '2019-04-21 23:59:59'
AND (rpt.startrepeat >= '2019-03-22 00:00:00' OR det.multiday=1)
AND ev.state=1
AND ev.access IN (1,1,5)
AND icsf.state=1
AND icsf.access IN (1,1,5)
AND rpt.startrepeat=( SELECT MIN(startrepeat)
FROM qkruz_jevents_repetition as rpt2
WHERE rpt2.eventid=rpt.eventid
AND ( (rpt2.startrepeat >= '2019-03-22 20:35:41'
AND rpt2.startrepeat <= '2019-04-21 23:59:59') OR (rpt2.startrepeat <= '2019-03-22 20:35:41'
AND rpt2.endrepeat > '2019-03-22 20:35:41'
AND det.multiday=1) ) )
GROUP BY ev.ev_id
ORDER BY rpt.startrepeat
LIMIT 10
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | PRIMARY | icsf | NULL | ref | PRIMARY,stateidx | stateidx | 1 | const | 1 | 50.00 | Using where; Using temporary; Gebruikt bestandssortering |
| 1 | PRIMARY | rpt | NULL | range | eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat | endrepeat | 5 | NULL | 23 | 97.72 | Using index condition; Using where; Using join buffer (Block Nested Loop) |
| 1 | PRIMARY | ev | NULL | eq_ref | PRIMARY,icsid,stateidx,evaccess | PRIMARY | 4 | eav_joomla3.rpt.eventid | 1 | 20.32 | Using where |
| 1 | PRIMARY | rr | NULL | ref | eventid | eventid | 4 | eav_joomla3.rpt.eventid | 1 | 100.00 | NULL |
| 1 | PRIMARY | det | NULL | eq_ref | PRIMARY,multiday | PRIMARY | 4 | eav_joomla3.rpt.eventdetail_id | 1 | 100.00 | Using where |
| 2 | DEPENDENT SUBQUERY | rpt2 | NULL | ref | eventid,eventstart,eventend,startrepeat,startend,endrepeat | eventid | 4 | eav_joomla3.rpt.eventid | 1 | 97.72 | Using where |
| Status | Duration |
|---|---|
| starting | 0.19 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.12 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.17 ms |
| preparing | 0.06 ms |
| Creating tmp table | 0.09 ms |
| Sorting result | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.15 ms |
| executing | 0.00 ms |
| Sending data | 0.38 ms |
| executing | 0.00 ms |
| Sending data | 0.09 ms |
| executing | 0.00 ms |
| Sending data | 0.06 ms |
| Creating sort index | 0.15 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| removing tmp table | 0.04 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Caller | Bestand en regelnummer |
|---|---|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jevents/libraries/dbmodel.php:2622 |
| 21 | JEventsDBModel->_cachedlistIcalEvents() | JROOT/components/com_jevents/libraries/jevCache.php:73 |
| 20 | jevCache->call() | JROOT/components/com_jevents/libraries/dbmodel.php:1103 |
| 19 | JEventsDBModel->listLatestIcalEvents() | JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398 |
| 18 | DefaultModLatestView->getLatestEventsData() | JROOT/modules/mod_jevents_latest/tmpl/flatplus/latest.php:26 |
| 17 | FlatplusModLatestView->displayLatestEvents() | JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 |
| 16 | include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 14 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:86 |
| 13 | ModulesWarpHelper->load() | JROOT/templates/jp-hope/warp/systems/joomla/layouts/modules.php:10 |
| 12 | include JROOT/templates/jp-hope/warp/systems/joomla/layouts/modules.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 11 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:64 |
| 10 | ModulesWarpHelper->render() | JROOT/templates/jp-hope/layouts/template.php:114 |
| 9 | include JROOT/templates/jp-hope/layouts/template.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 8 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/index.php:19 |
| 7 | require JROOT/templates/jp-hope/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:1030 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM qkruz_jevents_repetition as rpt
INNER JOIN qkruz_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN qkruz_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN qkruz_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN qkruz_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,20,88,89,90,91,92,93,94,95,96,97,98,99)
AND rpt.endrepeat >= '2019-03-22 00:00:00'
AND rpt.startrepeat <= '2019-03-22 20:35:41'
AND (rpt.startrepeat <= '2019-03-22 00:00:00'OR det.multiday=1)
AND ev.state=1
AND ev.access IN (1,1,5)
AND icsf.state=1
AND icsf.access IN (1,1,5)
AND rpt.startrepeat <= '2019-03-22 20:35:41'
AND rpt.endrepeat >= '2019-03-22 20:35:41'
GROUP BY ev.ev_id
ORDER BY rpt.startrepeat
LIMIT 10
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | icsf | NULL | ref | PRIMARY,stateidx | stateidx | 1 | const | 1 | 50.00 | Using where; Using temporary; Gebruikt bestandssortering |
| 1 | SIMPLE | rpt | NULL | range | eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat | endrepeat | 5 | NULL | 23 | 93.81 | Using index condition; Using where; Using join buffer (Block Nested Loop) |
| 1 | SIMPLE | ev | NULL | eq_ref | PRIMARY,icsid,stateidx,evaccess | PRIMARY | 4 | eav_joomla3.rpt.eventid | 1 | 20.32 | Using where |
| 1 | SIMPLE | rr | NULL | ref | eventid | eventid | 4 | eav_joomla3.rpt.eventid | 1 | 100.00 | NULL |
| 1 | SIMPLE | det | NULL | eq_ref | PRIMARY,multiday | PRIMARY | 4 | eav_joomla3.rpt.eventdetail_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.18 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| init | 0.10 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.17 ms |
| preparing | 0.07 ms |
| Creating tmp table | 0.12 ms |
| Sorting result | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.49 ms |
| Creating sort index | 0.10 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| removing tmp table | 0.04 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Caller | Bestand en regelnummer |
|---|---|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jevents/libraries/dbmodel.php:2622 |
| 21 | JEventsDBModel->_cachedlistIcalEvents() | JROOT/components/com_jevents/libraries/jevCache.php:73 |
| 20 | jevCache->call() | JROOT/components/com_jevents/libraries/dbmodel.php:1203 |
| 19 | JEventsDBModel->listLatestIcalEvents() | JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398 |
| 18 | DefaultModLatestView->getLatestEventsData() | JROOT/modules/mod_jevents_latest/tmpl/flatplus/latest.php:26 |
| 17 | FlatplusModLatestView->displayLatestEvents() | JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 |
| 16 | include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 14 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:86 |
| 13 | ModulesWarpHelper->load() | JROOT/templates/jp-hope/warp/systems/joomla/layouts/modules.php:10 |
| 12 | include JROOT/templates/jp-hope/warp/systems/joomla/layouts/modules.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 11 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:64 |
| 10 | ModulesWarpHelper->render() | JROOT/templates/jp-hope/layouts/template.php:114 |
| 9 | include JROOT/templates/jp-hope/layouts/template.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 8 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/index.php:19 |
| 7 | require JROOT/templates/jp-hope/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:1030 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT c.*
FROM qkruz_categories as c
WHERE extension='com_jevents'
order by c.lft asc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | c | NULL | ref | cat_idx | cat_idx | 202 | const | 13 | 100.00 | Using index condition; Gebruikt bestandssortering |
| Status | Duration |
|---|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.08 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.25 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | Bestand en regelnummer |
|---|---|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jevents/libraries/commonfunctions.php:92 |
| 20 | JEV_CommonFunctions::getCategoryData() | JROOT/components/com_jevents/libraries/commonfunctions.php:117 |
| 19 | JEV_CommonFunctions::setColor() | JROOT/components/com_jevents/libraries/jeventcal.php:313 |
| 18 | jEventCal->bgcolor() | JROOT/modules/mod_jevents_latest/tmpl/flatplus/latest.php:91 |
| 17 | FlatplusModLatestView->displayLatestEvents() | JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 |
| 16 | include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 14 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:86 |
| 13 | ModulesWarpHelper->load() | JROOT/templates/jp-hope/warp/systems/joomla/layouts/modules.php:10 |
| 12 | include JROOT/templates/jp-hope/warp/systems/joomla/layouts/modules.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 11 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:64 |
| 10 | ModulesWarpHelper->render() | JROOT/templates/jp-hope/layouts/template.php:114 |
| 9 | include JROOT/templates/jp-hope/layouts/template.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 8 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/index.php:19 |
| 7 | require JROOT/templates/jp-hope/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:1030 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM qkruz_widgetkit_widget
WHERE id=1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qkruz_widgetkit_widget | NULL | system | PRIMARY | INDEX KEY ONTBREEKT | NULL | NULL | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | Bestand en regelnummer |
|---|---|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 19 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_widgetkit/helpers/widget.php:42 |
| 18 | WidgetWidgetkitHelper->get() | JROOT/administrator/components/com_widgetkit/helpers/widget.php:160 |
| 17 | WidgetWidgetkitHelper->render() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:22 |
| 16 | include JROOT/modules/mod_widgetkit/mod_widgetkit.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 14 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:86 |
| 13 | ModulesWarpHelper->load() | JROOT/templates/jp-hope/warp/systems/joomla/layouts/modules.php:10 |
| 12 | include JROOT/templates/jp-hope/warp/systems/joomla/layouts/modules.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 11 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/warp/systems/joomla/helpers/modules.php:64 |
| 10 | ModulesWarpHelper->render() | JROOT/templates/jp-hope/layouts/template.php:130 |
| 9 | include JROOT/templates/jp-hope/layouts/template.php | JROOT/templates/jp-hope/warp/helpers/template.php:49 |
| 8 | TemplateWarpHelper->render() | JROOT/templates/jp-hope/index.php:19 |
| 7 | require JROOT/templates/jp-hope/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:1030 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
3 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `qkruz_assets`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `qkruz_extensions`
2 × SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM qkruz_jevents_repetition as rpt
INNER JOIN qkruz_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN qkruz_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN qkruz_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN qkruz_jevents_rrule as rr
ON rr.eventid = rpt.eventid
2 × SELECT 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 qkruz_fields AS a
LEFT JOIN `qkruz_languages` AS l
ON l.lang_code = a.language
LEFT JOIN qkruz_users AS uc
ON uc.id=a.checked_out
LEFT JOIN qkruz_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN qkruz_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN qkruz_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `qkruz_fields_categories` AS fc
ON fc.field_id = a.id
1 × SELECT `data`
FROM `qkruz_session`
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 `qkruz_categories` AS `s`
INNER JOIN `qkruz_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 c.*
FROM qkruz_categories as c
1 × SELECT c.id
FROM qkruz_categories AS c
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 `qkruz_categories` AS `c`
1 × SELECT c.id AS id, a.name AS asset_name
FROM ( SELECT id,asset_id
FROM qkruz_categories
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM qkruz_modules AS m
LEFT JOIN qkruz_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN qkruz_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT params
FROM qkruz_extensions AS e
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 qkruz_content AS a
INNER JOIN qkruz_categories AS c
on c.id = a.catid
LEFT JOIN qkruz_users AS u
on u.id = a.created_by
LEFT JOIN qkruz_categories as parent
ON parent.id = c.parent_id
LEFT JOIN qkruz_content_rating AS v
ON a.id = v.content_id
1 × SELECT `m`.`tag_id`,`t`.*
FROM `qkruz_contentitem_tag_map` AS m
INNER JOIN `qkruz_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT `session_id`
FROM `qkruz_session`
1 × SELECT *
FROM qkruz_content
1 × SELECT id, home, template, s.params
FROM qkruz_template_styles as s
LEFT JOIN qkruz_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM qkruz_languages
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM qkruz_menu AS m
LEFT JOIN qkruz_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `enabled`
FROM `qkruz_extensions`
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM qkruz_extensions
1 × SELECT b.id
FROM qkruz_usergroups AS a
LEFT JOIN qkruz_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `qkruz_viewlevels
1 × SELECT *
FROM qkruz_widgetkit_widget
1 × INSERT INTO `qkruz_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('as8ujg4j5rvr1dlmur0ai6kmk6', 1, 1553283341, 0, '', 0
1 × UPDATE `qkruz_extensions`
SET `params` = '{\"mediaversion\":\"a937b0a66e56a2c4511d12042d9bd3e8\"}'
1 × SHOW FULL COLUMNS
FROM `qkruz_content
1 × UPDATE qkruz_content
SET `hits` = (`hits` + 1)
1 × SHOW FULL COLUMNS
FROM `qkruz_jev_users