Abfragezeit: 0.88 ms
DELETE
FROM `g87pb_session`
WHERE `time` < '1591160215'
„EXPLAIN“ unmöglich für Abfrage: DELETE
FROM `g87pb_session`
WHERE `time` < '1591160215'
| Error |
|---|
| MySql have_profiling = off |
| # | Caller | File and line number |
|---|
| 6 | JDatabaseDriverMysql->execute() | JROOT/libraries/cms/application/cms.php:822 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:413 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.94 ms Nach letzter Abfrage: 0.65 ms
SELECT `data`
FROM `g87pb_session`
WHERE `session_id` = 'acae5092cb13e7b91e4b8de8226912ba'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | g87pb_session | const | PRIMARY | PRIMARY | 575 | const | 1 | |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 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:82 |
| 10 | JSessionHandlerJoomla->start() | JROOT/libraries/joomla/session/session.php:648 |
| 9 | JSession->_start() | JROOT/libraries/joomla/session/session.php:608 |
| 8 | JSession->start() | JROOT/libraries/joomla/session/session.php:486 |
| 7 | JSession->get() | JROOT/libraries/joomla/session/session.php:443 |
| 6 | JSession->isNew() | JROOT/libraries/cms/application/cms.php:829 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:413 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 1.94 ms Nach letzter Abfrage: 2.14 ms
SELECT `session_id`
FROM `g87pb_session`
WHERE `session_id` = 'acae5092cb13e7b91e4b8de8226912ba'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | g87pb_session | const | PRIMARY | PRIMARY | 575 | const | 1 | Using index |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 8 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 7 | JDatabaseDriver->loadResult() | JROOT/libraries/cms/application/cms.php:176 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:831 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:413 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.69 ms Nach letzter Abfrage: 0.33 ms
INSERT INTO `g87pb_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('acae5092cb13e7b91e4b8de8226912ba', 1, '1591161115', 0, '', 0)
„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `g87pb_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('acae5092cb13e7b91e4b8de8226912ba', 1, '1591161115', 0, '', 0)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 7 | JDatabaseDriverMysql->execute() | JROOT/libraries/cms/application/cms.php:216 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:831 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:413 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 1.49 ms Nach letzter Abfrage: 3.85 ms
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `g87pb_extensions`
WHERE `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | g87pb_extensions | ref | extension | extension | 62 | const | 36 | Using where |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/component/helper.php:447 |
| 9 | {closure}() | Same as call in the line below. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 7 | JCacheControllerCallback->get() | JROOT/libraries/cms/component/helper.php:455 |
| 6 | JComponentHelper::load() | JROOT/libraries/cms/component/helper.php:43 |
| 5 | JComponentHelper::getComponent() | JROOT/libraries/cms/component/helper.php:111 |
| 4 | JComponentHelper::getParams() | JROOT/libraries/cms/application/site.php:593 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.57 ms Nach letzter Abfrage: 4.10 ms
SELECT id, rules
FROM `g87pb_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | g87pb_viewlevels | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1486 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:1061 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:453 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:309 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:603 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.56 ms Nach letzter Abfrage: 0.30 ms
SELECT b.id
FROM g87pb_usergroups AS a
LEFT JOIN g87pb_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 3 | Using where; Using index |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:978 |
| 9 | JAccess::getGroupsByUser() | JROOT/libraries/joomla/access/access.php:1093 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:453 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:309 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:603 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.44 ms Nach letzter Abfrage: 1.22 ms
SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM g87pb_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | g87pb_extensions | ref | extension | extension | 62 | const | 85 | Using where; filesort wurde genutzt |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/plugin/helper.php:327 |
| 9 | {closure}() | Same as call in the line below. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 7 | JCacheControllerCallback->get() | JROOT/libraries/cms/plugin/helper.php:332 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:603 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.68 ms Nach letzter Abfrage: 38.45 ms
SELECT template
FROM g87pb_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 | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_home | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | Using where |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 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:96 |
| 8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:54 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/cms/plugin/helper.php:271 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:181 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:683 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.55 ms Nach letzter Abfrage: 0.21 ms
SELECT template
FROM g87pb_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 | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_home | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | Using where |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 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:96 |
| 8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:54 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/cms/plugin/helper.php:271 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:181 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:683 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.56 ms Nach letzter Abfrage: 8.17 ms
SELECT extension, file, type
FROM g87pb_rokcommon_configs
ORDER BY priority
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | g87pb_rokcommon_configs | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 2 | filesort wurde genutzt |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rokcommon/rokcommon.php:132 |
| 8 | plgSystemRokCommon->processRegisteredConfigs() | JROOT/plugins/system/rokcommon/rokcommon.php:76 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/cms/plugin/helper.php:271 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:181 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:683 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 2.27 ms Nach letzter Abfrage: 26.47 ms
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 g87pb_menu AS m
LEFT JOIN g87pb_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 48 | Using where; filesort wurde genutzt |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | db11768_bogen.m.component_id | 1 | |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/menu/site.php:88 |
| 17 | {closure}() | Same as call in the line below. |
| 16 | call_user_func_array() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 15 | JCacheControllerCallback->get() | JROOT/libraries/cms/menu/site.php:96 |
| 14 | JMenuSite->load() | JROOT/libraries/cms/menu/menu.php:74 |
| 13 | JMenu->__construct() | JROOT/libraries/cms/menu/site.php:57 |
| 12 | JMenuSite->__construct() | JROOT/libraries/cms/menu/menu.php:129 |
| 11 | JMenu::getInstance() | JROOT/libraries/cms/application/cms.php:444 |
| 10 | JApplicationCms->getMenu() | JROOT/libraries/cms/application/site.php:272 |
| 9 | JApplicationSite->getMenu() | JROOT/libraries/cms/router/site.php:59 |
| 8 | JRouterSite->__construct() | JROOT/libraries/cms/router/router.php:198 |
| 7 | JRouter::getInstance() | JROOT/libraries/cms/application/cms.php:549 |
| 6 | JApplicationCms::getRouter() | JROOT/libraries/cms/application/site.php:402 |
| 5 | JApplicationSite::getRouter() | JROOT/libraries/cms/application/cms.php:1145 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.90 ms Nach letzter Abfrage: 24.33 ms
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `g87pb_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | g87pb_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | Using where |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 14 | JDatabaseDriver->loadObject() | JROOT/libraries/cms/library/helper.php:166 |
| 13 | {closure}() | Same as call in the line below. |
| 12 | call_user_func_array() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 11 | JCacheControllerCallback->get() | JROOT/libraries/cms/library/helper.php:174 |
| 10 | JLibraryHelper::loadLibrary() | JROOT/libraries/cms/library/helper.php:42 |
| 9 | JLibraryHelper::getLibrary() | JROOT/libraries/cms/library/helper.php:89 |
| 8 | JLibraryHelper::getParams() | JROOT/libraries/cms/version/version.php:270 |
| 7 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:760 |
| 6 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 5 | JFactory::getDocument() | JROOT/libraries/joomla/application/web.php:1023 |
| 4 | JApplicationWeb->loadDocument() | JROOT/libraries/cms/application/site.php:130 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.81 ms Nach letzter Abfrage: 0.43 ms
UPDATE `g87pb_extensions`
SET `params` = '{\"mediaversion\":\"34ed7a6f32131f409690a995b0aaf97b\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
„EXPLAIN“ unmöglich für Abfrage: UPDATE `g87pb_extensions`
SET `params` = '{\"mediaversion\":\"34ed7a6f32131f409690a995b0aaf97b\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysql->execute() | JROOT/libraries/cms/library/helper.php:116 |
| 9 | JLibraryHelper::saveParams() | JROOT/libraries/cms/version/version.php:321 |
| 8 | JVersion->setMediaVersion() | JROOT/libraries/cms/version/version.php:280 |
| 7 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:760 |
| 6 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 5 | JFactory::getDocument() | JROOT/libraries/joomla/application/web.php:1023 |
| 4 | JApplicationWeb->loadDocument() | JROOT/libraries/cms/application/site.php:130 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.63 ms Nach letzter Abfrage: 3.42 ms
SELECT *
FROM g87pb_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | g87pb_languages | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | Using where; filesort wurde genutzt |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 7 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/language/helper.php:148 |
| 5 | JLanguageHelper::getLanguages() | JROOT/libraries/cms/application/site.php:327 |
| 4 | JApplicationSite->getParams() | JROOT/libraries/cms/application/site.php:135 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.94 ms Nach letzter Abfrage: 0.56 ms
SELECT id, home, template, s.params
FROM g87pb_template_styles as s
LEFT JOIN g87pb_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_template | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 303 | db11768_bogen.s.template,const | 1 | Using where |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 6 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/application/site.php:485 |
| 4 | JApplicationSite->getTemplate() | JROOT/libraries/cms/application/site.php:165 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.67 ms Nach letzter Abfrage: 13.71 ms
DELETE
FROM `g87pb_session`
WHERE `time` < '1591160215'
„EXPLAIN“ unmöglich für Abfrage: DELETE
FROM `g87pb_session`
WHERE `time` < '1591160215'
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysql->execute() | JROOT/libraries/cms/application/cms.php:822 |
| 13 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 12 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 11 | JApplicationSite->__construct() | JROOT/components/com_easybookreloaded/views/easybookreloaded/view.html.php:30 |
| 10 | EasybookReloadedViewEasybookReloaded->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_easybookreloaded/controller.php:28 |
| 8 | EasybookReloadedController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_easybookreloaded/easybookreloaded.php:40 |
| 6 | require_once JROOT/components/com_easybookreloaded/easybookreloaded.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.79 ms Nach letzter Abfrage: 0.34 ms
SELECT `session_id`
FROM `g87pb_session`
WHERE `session_id` = 'acae5092cb13e7b91e4b8de8226912ba'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | g87pb_session | const | PRIMARY | PRIMARY | 575 | const | 1 | Using index |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/cms/application/cms.php:176 |
| 14 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:831 |
| 13 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 12 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 11 | JApplicationSite->__construct() | JROOT/components/com_easybookreloaded/views/easybookreloaded/view.html.php:30 |
| 10 | EasybookReloadedViewEasybookReloaded->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_easybookreloaded/controller.php:28 |
| 8 | EasybookReloadedController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_easybookreloaded/easybookreloaded.php:40 |
| 6 | require_once JROOT/components/com_easybookreloaded/easybookreloaded.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.13 ms Nach letzter Abfrage: 0.36 ms
SELECT *
FROM `g87pb_easybook`
WHERE `gbid` = 1
AND `published` = 1
ORDER BY `gbdate` DESC
LIMIT 40, 20
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | g87pb_easybook | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 156 | Using where; filesort wurde genutzt |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:307 |
| 13 | JModelLegacy->_getList() | JROOT/components/com_easybookreloaded/models/easybookreloaded.php:50 |
| 12 | EasybookReloadedModelEasybookReloaded->getData() | JROOT/libraries/legacy/view/legacy.php:422 |
| 11 | JViewLegacy->get() | JROOT/components/com_easybookreloaded/views/easybookreloaded/view.html.php:67 |
| 10 | EasybookReloadedViewEasybookReloaded->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_easybookreloaded/controller.php:28 |
| 8 | EasybookReloadedController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_easybookreloaded/easybookreloaded.php:40 |
| 6 | require_once JROOT/components/com_easybookreloaded/easybookreloaded.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.73 ms Nach letzter Abfrage: 0.47 ms
SELECT *
FROM `g87pb_easybook_gb`
WHERE `id` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | g87pb_easybook_gb | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:307 |
| 13 | JModelLegacy->_getList() | JROOT/components/com_easybookreloaded/models/easybookreloaded.php:97 |
| 12 | EasybookReloadedModelEasybookReloaded->getGBData() | JROOT/libraries/legacy/view/legacy.php:422 |
| 11 | JViewLegacy->get() | JROOT/components/com_easybookreloaded/views/easybookreloaded/view.html.php:68 |
| 10 | EasybookReloadedViewEasybookReloaded->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_easybookreloaded/controller.php:28 |
| 8 | EasybookReloadedController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_easybookreloaded/easybookreloaded.php:40 |
| 6 | require_once JROOT/components/com_easybookreloaded/easybookreloaded.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.48 ms Nach letzter Abfrage: 0.21 ms
SELECT *
FROM `g87pb_easybook`
WHERE `gbid` = 1
AND `published` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | g87pb_easybook | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 156 | Using where |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysql->execute() | JROOT/libraries/legacy/model/legacy.php:347 |
| 13 | JModelLegacy->_getListCount() | JROOT/components/com_easybookreloaded/models/easybookreloaded.php:132 |
| 12 | EasybookReloadedModelEasybookReloaded->getTotal() | JROOT/libraries/legacy/view/legacy.php:422 |
| 11 | JViewLegacy->get() | JROOT/components/com_easybookreloaded/views/easybookreloaded/view.html.php:69 |
| 10 | EasybookReloadedViewEasybookReloaded->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_easybookreloaded/controller.php:28 |
| 8 | EasybookReloadedController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_easybookreloaded/easybookreloaded.php:40 |
| 6 | require_once JROOT/components/com_easybookreloaded/easybookreloaded.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.48 ms Nach letzter Abfrage: 44.83 ms
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM g87pb_modules AS m
LEFT JOIN g87pb_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN g87pb_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 <= '2020-06-03 05:11:55')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-06-03 05:11:55')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 109 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 33 | Using where; filesort wurde genutzt |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | db11768_bogen.m.id | 1 | Using where; Using index |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 303 | db11768_bogen.m.module,const | 1 | Using where |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 14 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 12 | JCacheControllerCallback->get() | JROOT/libraries/cms/module/helper.php:424 |
| 11 | JModuleHelper::getModuleList() | JROOT/libraries/cms/module/helper.php:360 |
| 10 | JModuleHelper::load() | JROOT/libraries/cms/module/helper.php:84 |
| 9 | JModuleHelper::getModules() | JROOT/libraries/joomla/document/html.php:576 |
| 8 | JDocumentHtml->countModules() | JROOT/templates/full_screen_9/index.php:344 |
| 7 | require JROOT/templates/full_screen_9/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
2 × SELECT *
FROM `g87pb_easybook`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `g87pb_extensions`
2 × SELECT template
FROM g87pb_template_styles as s
2 × SELECT `session_id`
FROM `g87pb_session`
1 × SELECT id, home, template, s.params
FROM g87pb_template_styles as s
LEFT JOIN g87pb_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM `g87pb_easybook_gb`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM g87pb_modules AS m
LEFT JOIN g87pb_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN g87pb_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT *
FROM g87pb_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 g87pb_menu AS m
LEFT JOIN g87pb_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT b.id
FROM g87pb_usergroups AS a
LEFT JOIN g87pb_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM g87pb_extensions
1 × SELECT `data`
FROM `g87pb_session`
1 × SELECT extension, file, type
FROM g87pb_rokcommon_configs
1 × SELECT id, rules
FROM `g87pb_viewlevels
g.g.g.g. Lg. Karl aus dem Mühlviertel
Vor deinen Besuch bitte bei Fr. Erika Klammer telefonisch melden 0664 73663470.Liebe Grüße das Team vom BSW Dorfstetten
umsonst so weit gefahren, Mittwoch Ruhetag.
Lg. Toni
, Hallo Frage seit ihr noch im Winterschlaf. Wann finden die tollen Tuniere 2017 statt. 
, der Frühling kommt. lg der Waldläufer