Gesamt 2018 - Update 2018-10-27
Tageswertung 2018 - Update 2018-10-27
Bei Fragen und Einsprüchen bitte Email an IsarCup(at)irsf.de
Bleibt sportlich!
Euer MTB Isarcup - Team
Gesamt 2018 - Update 2018-10-27
Tageswertung 2018 - Update 2018-10-27
Bei Fragen und Einsprüchen bitte Email an IsarCup(at)irsf.de
Bleibt sportlich!
Euer MTB Isarcup - Team
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1550574117,
"last": 1550574117,
"now": 1550574117
},
"token": "9eynFI8xBSfw6PIni14C9n4CMNSYIPAQ"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"gantry-current-template": "rt_sirocco",
"sirocco-e025496538caa05dd610e095c966b197-name": null,
"sirocco-e025496538caa05dd610e095c966b197-logo-type": null,
"sirocco-e025496538caa05dd610e095c966b197-logo-custom-image": null,
"sirocco-e025496538caa05dd610e095c966b197-accent-color1": null,
"sirocco-e025496538caa05dd610e095c966b197-accent-color2": null,
"sirocco-e025496538caa05dd610e095c966b197-top-textcolor": null,
"sirocco-e025496538caa05dd610e095c966b197-top-background": null,
"sirocco-e025496538caa05dd610e095c966b197-header-textcolor": null,
"sirocco-e025496538caa05dd610e095c966b197-header-background": null,
"sirocco-e025496538caa05dd610e095c966b197-header-type": null,
"sirocco-e025496538caa05dd610e095c966b197-showcase-textcolor": null,
"sirocco-e025496538caa05dd610e095c966b197-showcase-background": null,
"sirocco-e025496538caa05dd610e095c966b197-utility-textcolor": null,
"sirocco-e025496538caa05dd610e095c966b197-utility-background": null,
"sirocco-e025496538caa05dd610e095c966b197-feature-textcolor": null,
"sirocco-e025496538caa05dd610e095c966b197-feature-background": null,
"sirocco-e025496538caa05dd610e095c966b197-maintop-textcolor": null,
"sirocco-e025496538caa05dd610e095c966b197-maintop-background": null,
"sirocco-e025496538caa05dd610e095c966b197-expandedtop-textcolor": null,
"sirocco-e025496538caa05dd610e095c966b197-expandedtop-background": null,
"sirocco-e025496538caa05dd610e095c966b197-expandedbottom-textcolor": null,
"sirocco-e025496538caa05dd610e095c966b197-expandedbottom-background": null,
"sirocco-e025496538caa05dd610e095c966b197-mainbottom-textcolor": null,
"sirocco-e025496538caa05dd610e095c966b197-mainbottom-background": null,
"sirocco-e025496538caa05dd610e095c966b197-mainbody-overlay": null,
"sirocco-e025496538caa05dd610e095c966b197-extension-textcolor": null,
"sirocco-e025496538caa05dd610e095c966b197-extension-background": null,
"sirocco-e025496538caa05dd610e095c966b197-bottom-textcolor": null,
"sirocco-e025496538caa05dd610e095c966b197-bottom-background": null,
"sirocco-e025496538caa05dd610e095c966b197-footer-textcolor": null,
"sirocco-e025496538caa05dd610e095c966b197-footer-background": null,
"sirocco-e025496538caa05dd610e095c966b197-copyright-textcolor": null,
"sirocco-e025496538caa05dd610e095c966b197-copyright-background": null,
"sirocco-e025496538caa05dd610e095c966b197-font-family": null,
"sirocco-e025496538caa05dd610e095c966b197-font-size-is": null,
"sirocco-e025496538caa05dd610e095c966b197-menu-type": null,
"sirocco-e025496538caa05dd610e095c966b197-layout-mode": null
}
}
SELECT `data`
FROM `ywqd8_session`
WHERE `session_id` = '149b861992c9a79382c48ad0578d225c'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | ywqd8_session | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
| # | Caller | File and line number |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | Same as call in the line below. |
| 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 `ywqd8_session`
WHERE `session_id` = '149b861992c9a79382c48ad0578d225c'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | ywqd8_session | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
| # | Caller | File and line number |
|---|---|---|
| 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 `ywqd8_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('149b861992c9a79382c48ad0578d225c', 1, 1550574117, 0, '', 0)
| # | Caller | File and line number |
|---|---|---|
| 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 id, rules
FROM `ywqd8_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | ywqd8_viewlevels | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 3 | 100.00 | NULL |
| # | Caller | File and line number |
|---|---|---|
| 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 ywqd8_usergroups AS a
LEFT JOIN ywqd8_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | index | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 8 | NULL | 9 | 22.22 | Using where; Using index |
| # | Caller | File and line number |
|---|---|---|
| 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 template
FROM ywqd8_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | ALL | idx_home | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 6 | 100.00 | Using where |
| # | Caller | File and line number |
|---|---|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 13 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
| 12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 |
| 11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
| 10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
| 9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:95 |
| 8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:53 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 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 template
FROM ywqd8_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | ALL | idx_home | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 6 | 100.00 | Using where |
| # | Caller | File and line number |
|---|---|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 14 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
| 13 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 |
| 12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 |
| 11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
| 10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
| 9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:95 |
| 8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:53 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 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 extension, file, type
FROM ywqd8_rokcommon_configs
ORDER BY priority
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | ywqd8_rokcommon_configs | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 4 | 100.00 | filesort wurde genutzt |
| # | Caller | File and line number |
|---|---|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rokcommon/rokcommon.php:131 |
| 8 | plgSystemRokCommon->processRegisteredConfigs() | JROOT/plugins/system/rokcommon/rokcommon.php:75 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 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 |
SHOW TABLES
| # | Caller | File and line number |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:502 |
| 9 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/jdownloads/jdownloads.php:78 |
| 8 | plgSystemjdownloads->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:626 |
| 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 file_id
from ywqd8_jdownloads_files
WHERE published = 1
AND use_timeframe = 1
AND publish_to != '0000-00-00 00:00:00'
AND publish_to <= '2019-02-19 12:01:58'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | ywqd8_jdownloads_files | ref | idx_published | idx_published | 1 | const | 4 | 100.00 | Using where |
| # | Caller | File and line number |
|---|---|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
| 9 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/jdownloads/jdownloads.php:106 |
| 8 | plgSystemjdownloads->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:626 |
| 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 file_id
from ywqd8_jdownloads_files
WHERE published = 0
AND use_timeframe = 1
AND publish_from != '0000-00-00 00:00:00'
AND publish_from <= '2019-02-19 12:01:58'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | ywqd8_jdownloads_files | ALL | idx_published | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 13 | 84.62 | Using where |
| # | Caller | File and line number |
|---|---|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
| 9 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/jdownloads/jdownloads.php:114 |
| 8 | plgSystemjdownloads->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:626 |
| 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 |
Update
ywqd8_contentbuilder_articles As articles,
ywqd8_content As content,
ywqd8_contentbuilder_forms As forms,
ywqd8_contentbuilder_registered_users As cbusers,
ywqd8_users As users
Set
content.state = 0
Where
articles.article_id = content.id
And
content.state = 1
And
articles.form_id = forms.id
And
forms.act_as_registration = 1
And
forms.id = cbusers.form_id
And
content.created_by = cbusers.user_id
And
(
(
users.id = cbusers.user_id
And
users.block = 1
)
)| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| # | Caller | File and line number |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
| 10 | JDatabase->query() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:415 |
| 9 | plgSystemContentbuilder_system->onAfterInitialize() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:360 |
| 8 | plgSystemContentbuilder_system->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:626 |
| 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 |
Update
ywqd8_contentbuilder_articles As articles,
ywqd8_content As content,
ywqd8_contentbuilder_forms As forms,
ywqd8_contentbuilder_records As records,
ywqd8_contentbuilder_registered_users As cbusers,
ywqd8_users As users
Set
content.state = forms.auto_publish
Where
articles.article_id = content.id
And
content.state = 0
And
articles.form_id = forms.id
And
forms.act_as_registration = 1
And
forms.id = cbusers.form_id
And
content.created_by = cbusers.user_id
And
users.id = cbusers.user_id
And
records.record_id = cbusers.record_id
And
records.`type` = forms.`type`
And
users.block = 0| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| # | Caller | File and line number |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
| 10 | JDatabase->query() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:448 |
| 9 | plgSystemContentbuilder_system->onAfterInitialize() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:360 |
| 8 | plgSystemContentbuilder_system->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:626 |
| 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
form.id As form_id,
form.act_as_registration,
form.default_category,
form.registration_name_field,
form.registration_username_field,
form.registration_email_field,
form.registration_email_repeat_field,
form.`last_update`,
article.`article_id`,
form.`title_field`,
form.`create_articles`,
form.`name`,
form.`use_view_name_as_title`,
form.`protect_upload_directory`,
form.`reference_id`,
records.`record_id`,
form.`type`,
form.`published_only`,
form.`own_only`,
form.`own_only_fe`,
records.`last_update` As record_last_update,
article.`last_update` As article_last_update
From
ywqd8_contentbuilder_records As records
Left Join ywqd8_contentbuilder_forms As form
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id )
Left Join ywqd8_contentbuilder_articles As article
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id
And article.form_id = form.id
And article.record_id = records.record_id )
Left Join ywqd8_content As content
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id
And article.article_id = content.id
And article.form_id = form.id
And article.record_id = records.record_id )
Where
form.`published` = 1
And
form.create_articles = 1
And
form.`type` = records.`type`
And
form.reference_id = records.reference_id
And
(
(
article.form_id = form.id
And
article.record_id = records.record_id
And
article.article_id = content.id
And
( content.state = 1 Or content.state = 0 )
And
(
form.`last_update` > article.`last_update`
Or
records.`last_update` > article.`last_update`
)
)
Or
(
form.id Is Not Null
And records.id Is Not Null
And content.id Is Null
And article.id Is Null
)
)
Limit 50| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | form | ALL | PRIMARY,reference_id | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | 100.00 | Using where |
| 1 | SIMPLE | records | ref | PRIMARY,record_id,reference_id,type | reference_id | 4 | DB2114401.form.reference_id | 34 | 100.00 | Using where |
| 1 | SIMPLE | article | ALL | record_id,record_id_2 | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 10 | 80.00 | Using where; Using join buffer (Block Nested Loop) |
| 1 | SIMPLE | content | eq_ref | PRIMARY | PRIMARY | 4 | DB2114401.article.article_id | 1 | 100.00 | Using where |
| # | Caller | File and line number |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
| 10 | JDatabaseDriver->loadAssocList() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:514 |
| 9 | plgSystemContentbuilder_system->onAfterInitialize() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:360 |
| 8 | plgSystemContentbuilder_system->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:626 |
| 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 |
SET SESSION group_concat_max_len = 9999999
| # | Caller | File and line number |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
| 12 | JDatabase->query() | JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:20 |
| 11 | contentbuilder_com_breezingforms->__construct() | JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:992 |
| 10 | contentbuilder::getForm() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:528 |
| 9 | plgSystemContentbuilder_system->onAfterInitialize() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:360 |
| 8 | plgSystemContentbuilder_system->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:626 |
| 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 *
From ywqd8_facileforms_forms
Where id = 9
And published = 1
Order By `ordering`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | ywqd8_facileforms_forms | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| # | Caller | File and line number |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 12 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:23 |
| 11 | contentbuilder_com_breezingforms->__construct() | JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:992 |
| 10 | contentbuilder::getForm() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:528 |
| 9 | plgSystemContentbuilder_system->onAfterInitialize() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:360 |
| 8 | plgSystemContentbuilder_system->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:626 |
| 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 *
From ywqd8_facileforms_elements
Where `type` <> 'Sofortueberweisung'
And `type` <> 'PayPal'
And `type` <> 'Static Text/HTML'
And `type` <> 'Rectangle'
And `type` <> 'Image'
And `type` <> 'Tooltip'
And `type` <> 'Query List'
And `type` <> 'Icon'
And `type` <> 'Graphic Button'
And `type` <> 'Regular Button'
And `type`<> 'Unknown'
And `type` <> 'Summarize'
And `type` <> 'ReCaptcha'
And form = 9
And published = 1
Order By `ordering`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | ywqd8_facileforms_elements | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 57 | 100.00 | Using where; filesort wurde genutzt |